Join the 1-day Testing & QA Summit featuring 15+ Expert Speakers.Register for FREE! Join TestMu Conference

How to use DiscoverMemberCommand class of NBi.Core.Analysis.Member package

Best NBi code snippet using NBi.Core.Analysis.Member.DiscoverMemberCommand

DiscoverMemberCommand.cs

Source:DiscoverMemberCommand.cs

2using Microsoft.AnalysisServices.AdomdClient;34namespace NBi.Core.Analysis.Member5{6    public class DiscoverMemberCommand7    {8        public string ConnectionString { get; set; }9        public string Perspective { get; set; }10        public string Path { get; set; }1112        public DiscoverMemberCommand(string connectionString)13        {14            ConnectionString = connectionString;15        }1617        18    }19}
...

DiscoverMemberCommand

Using AI Code Generation

1using System;2using System.Collections.Generic;3using System.Linq;4using System.Text;5using System.Threading.Tasks;6using NBi.Core.Analysis.Member;7{8    {9        static void Main(string[] args)10        {11            DiscoverMemberCommand cmd = new DiscoverMemberCommand();12            cmd.ConnectionString = "Provider=MSOLAP;Data Source=ServerName;Initial Catalog=DatabaseName";13            cmd.Cube = "CubeName";14            cmd.HierarchyUniqueName = "[Dim1].[Dim1].[Dim1]";15            cmd.MemberUniqueName = "[Dim1].[Dim1].[Dim1].[Dim1]";16            var result = cmd.Execute();17            Console.WriteLine(result);18            Console.ReadLine();19        }20    }21}

DiscoverMemberCommand

Using AI Code Generation

1using NBi.Core.Analysis.Member;2using NBi.Core.Analysis.Request;3using NBi.Core.Analysis;4using System;5using System.Collections.Generic;6using System.Linq;7using System.Text;8using System.Threading.Tasks;9using System.Data;10using System.Data.SqlClient;11{12    {13        private readonly IDiscoverRequest request;14        private readonly IDiscoverer discoverer;15        private readonly IList<string> hierarchyUniqueNames;16        private readonly IList<string> levelsUniqueNames;17        private readonly IList<string> membersUniqueNames;18        public DiscoverMemberCommand(IDiscoverRequest request, IDiscoverer discoverer)19        {20            this.request = request;21            this.discoverer = discoverer;22            this.hierarchyUniqueNames = new List<string>();23            this.levelsUniqueNames = new List<string>();24            this.membersUniqueNames = new List<string>();25        }26        public DiscoverMemberCommand(IDiscoverRequest request, IDiscoverer discoverer, IList<string> hierarchyUniqueNames, IList<string> levelsUniqueNames, IList<string> membersUniqueNames)27        {28            this.request = request;29            this.discoverer = discoverer;30            this.hierarchyUniqueNames = hierarchyUniqueNames;31            this.levelsUniqueNames = levelsUniqueNames;32            this.membersUniqueNames = membersUniqueNames;33        }34        public IEnumerable<MemberDiscoveryResult> Execute()35        {36            var result = new List<MemberDiscoveryResult>();37            var members = new List<MemberDiscoveryResult>();38            var rs = discoverer.Execute(request);39            var dt = rs.Table;40            if (dt.Rows.Count > 0)41            {42                foreach (DataRow row in dt.Rows)43                {44                    var member = new MemberDiscoveryResult();45                    member.Caption = row["MEMBER_CAPTION"].ToString();46                    member.UniqueName = row["MEMBER_UNIQUE_NAME"].ToString();47                    member.Type = row["MEMBER_TYPE"].ToString();48                    member.Depth = Convert.ToInt32(row["MEMBER_DEPTH"]);49                    member.Ordinal = Convert.ToInt32(row["MEMBER_ORDINAL"]);50                    member.ParentUniqueName = row["MEMBER_PARENT_UNIQUE_NAME"].ToString();51                    member.ChildrenCardinality = Convert.ToInt32(row["MEMBER_CHILDREN_CARDINALITY"]);52                    member.LevelUniqueName = row["LEVEL_UNIQUE_NAME"].ToString();53                    member.LevelCaption = row["LEVEL_CAPTION"].ToString();54                    member.LevelNumber = Convert.ToInt32(row["LEVEL_NUMBER"]);

DiscoverMemberCommand

Using AI Code Generation

1using NBi.Core.Analysis.Member;2DiscoverMemberCommand cmd = new DiscoverMemberCommand();3cmd.CubeName = "Adventure Works";4cmd.DimensionName = "Customer";5cmd.HierarchyName = "Customer Geography";6cmd.LevelName = "Country";7cmd.MemberName = "United States";8cmd.MemberType = MemberType.Leaf;9cmd.Execute();10using NBi.Core.Analysis.Member;11DiscoverMemberCommand cmd = new DiscoverMemberCommand();12cmd.CubeName = "Adventure Works";13cmd.DimensionName = "Customer";14cmd.HierarchyName = "Customer Geography";15cmd.LevelName = "Country";16cmd.MemberName = "United States";17cmd.MemberType = MemberType.Leaf;18cmd.Execute();19using NBi.Core.Analysis.Member;20DiscoverMemberCommand cmd = new DiscoverMemberCommand();21cmd.CubeName = "Adventure Works";22cmd.DimensionName = "Customer";23cmd.HierarchyName = "Customer Geography";24cmd.LevelName = "Country";25cmd.MemberName = "United States";26cmd.MemberType = MemberType.Leaf;27cmd.Execute();28using NBi.Core.Analysis.Member;29DiscoverMemberCommand cmd = new DiscoverMemberCommand();

DiscoverMemberCommand

Using AI Code Generation

1DiscoverMemberCommand command = new DiscoverMemberCommand();2command.CubeName = "Adventure Works";3command.HierarchyUniqueName = "[Date].[Calendar]";4command.SearchDepth = SearchDepth.Children;5command.SearchMode = SearchMode.ExactMatch;6command.SearchValue = "Q1";7command.Execute();8DiscoverMembersCommand command = new DiscoverMembersCommand();9command.CubeName = "Adventure Works";10command.HierarchyUniqueName = "[Date].[Calendar]";11command.SearchDepth = SearchDepth.Children;12command.SearchMode = SearchMode.ExactMatch;13command.SearchValue = "Q1";14command.Execute();15DiscoverMembersCommand command = new DiscoverMembersCommand();16command.CubeName = "Adventure Works";17command.HierarchyUniqueName = "[Date].[Calendar]";18command.SearchDepth = SearchDepth.Children;19command.SearchMode = SearchMode.ExactMatch;20command.SearchValue = "Q1";21command.Execute();22DiscoverMembersCommand command = new DiscoverMembersCommand();23command.CubeName = "Adventure Works";24command.HierarchyUniqueName = "[Date].[Calendar]";25command.SearchDepth = SearchDepth.Children;26command.SearchMode = SearchMode.ExactMatch;27command.SearchValue = "Q1";28command.Execute();29DiscoverMembersCommand command = new DiscoverMembersCommand();

DiscoverMemberCommand

Using AI Code Generation

1using NBi.Core.Analysis.Member;2using System;3using System.Collections.Generic;4using System.Linq;5using System.Text;6using System.Threading.Tasks;7{8    {9        static void Main(string[] args)10        {11            {12                var cmd = new DiscoverMemberCommand();13                cmd.ConnectionString = "Data Source=localhost;Initial Catalog=Adventure Works DW Standard Edition;Integrated Security=True;";14                cmd.CubeName = "Adventure Works";15                cmd.DimensionName = "Date";16                cmd.HierarchyName = "Date";17                cmd.LevelName = "Fiscal Year";18                cmd.Execute();19                var result = cmd.GetResult();20                foreach (var item in result)21                {22                    Console.WriteLine(item.Caption);23                }24            }25            catch (Exception ex)26            {27                Console.WriteLine(ex.Message);28            }29            Console.ReadLine();30        }31    }32}

DiscoverMemberCommand

Using AI Code Generation

1using System;2using System.Data;3using NBi.Core.Analysis.Member;4using NBi.Core.Analysis.Metadata;5using NBi.Core.Analysis.Request;6using NBi.Core.Analysis.Member.Discovery;7using NBi.Core.Analysis.Member.Resolver;8{9    {10        static void Main(string[] args)11        {12            var request = new MetadataDiscoveryRequest();13            request.ConnectionString = connectionString;14            request.Catalog = "Adventure Works DW Standard Edition";15            request.Dimension = "Date";16            request.Hierarchy = "Date";17            request.Level = "Date";18            var command = new DiscoverMemberCommand(request);19            var result = command.Execute();20            foreach (var row in result.Rows)21            {22                Console.WriteLine(row["Caption"]);23            }24            Console.ReadKey();25        }26    }27}28using System;29using System.Data;30using NBi.Core.Analysis.Member;31using NBi.Core.Analysis.Metadata;32using NBi.Core.Analysis.Request;33using NBi.Core.Analysis.Member.Discovery;34using NBi.Core.Analysis.Member.Resolver;35{36    {37        static void Main(string[] args)38        {39            var request = new MetadataDiscoveryRequest();40            request.ConnectionString = connectionString;41            request.Catalog = "Adventure Works DW Standard Edition";42            request.Dimension = "Date";43            request.Hierarchy = "Date";44            request.Level = "Date";45            var command = new DiscoverMemberCommand(request);46            var result = command.Execute();47            foreach (var row in result.Rows)48            {49                Console.WriteLine(row["Caption"]);50            }51            Console.ReadKey();52        }53    }54}55using System;56using System.Data;57using NBi.Core.Analysis.Member;

Automation Testing Tutorials

Learn to execute automation testing from scratch with LambdaTest Learning Hub. Right from setting up the prerequisites to run your first automation test, to following best practices and diving deeper into advanced test scenarios. LambdaTest Learning Hubs compile a list of step-by-step guides to help you be proficient with different test automation frameworks i.e. Selenium, Cypress, TestNG etc.