How to use List method of NBi.Core.Analysis.Member.MembersCommand class

Best NBi code snippet using NBi.Core.Analysis.Member.MembersCommand.List

MembersCommandTest.cs

Source:MembersCommandTest.cs

...11    [Category ("Olap")]12    public class MembersCommandTest13    {14        [Test]15        public void List_Level_ListOfMembers()16        {17            var connStr = ConnectionStringReader.GetAdomd();18            var cmd = new MembersCommand(connStr, "Members", null);19            var filters = new List<CaptionFilter>(){ 20                    new CaptionFilter("Adventure Works", DiscoveryTarget.Perspectives),21                    new CaptionFilter("Date", DiscoveryTarget.Dimensions),22                    new CaptionFilter("Calendar", DiscoveryTarget.Hierarchies),23                    new CaptionFilter("Month", DiscoveryTarget.Levels)24                };2526            var result = cmd.List(filters);27            Assert.That(result.Count, Is.EqualTo(72));28        }2930        [Test]31        public void List_Hierarchy_ListOfMembers()32        {33            var connStr = ConnectionStringReader.GetAdomd();34            var cmd = new MembersCommand(connStr, "Members", null);35            var filters = new List<CaptionFilter>(){ 36                    new CaptionFilter("Adventure Works", DiscoveryTarget.Perspectives),37                    new CaptionFilter("Date", DiscoveryTarget.Dimensions),38                    new CaptionFilter("Month Of Year", DiscoveryTarget.Hierarchies),39                };4041            var result = cmd.List(filters);42            Assert.That(result.Count, Is.EqualTo(13));43        }4445        [Test]46        public void List_LevelWithExclusionOfJanuary2005_ListOfMembers()47        {48            var connStr = ConnectionStringReader.GetAdomd();49            var excludedMembers = new List<string>() { "January 2005" };50            var cmd = new MembersCommand(connStr, "Members", null, excludedMembers, null);51            var filters = new List<CaptionFilter>(){ 52                    new CaptionFilter("Adventure Works", DiscoveryTarget.Perspectives),53                    new CaptionFilter("Date", DiscoveryTarget.Dimensions),54                    new CaptionFilter("Calendar", DiscoveryTarget.Hierarchies),55                    new CaptionFilter("Month", DiscoveryTarget.Levels)56                };5758            var result = cmd.List(filters);59            Assert.That(result.Count, Is.EqualTo(71));60        }6162        [Test]63        public void List_LevelWithExclusionOfJanuary2005AndNovember2005_ListOfMembers()64        {65            var connStr = ConnectionStringReader.GetAdomd();66            var excludedMembers = new List<string>() { "January 2005", "November 2005" };67            var cmd = new MembersCommand(connStr, "Members", null, excludedMembers, null);68            var filters = new List<CaptionFilter>(){ 69                    new CaptionFilter("Adventure Works", DiscoveryTarget.Perspectives),70                    new CaptionFilter("Date", DiscoveryTarget.Dimensions),71                    new CaptionFilter("Calendar", DiscoveryTarget.Hierarchies),72                    new CaptionFilter("Month", DiscoveryTarget.Levels)73                };7475            var result = cmd.List(filters);76            Assert.That(result.Count, Is.EqualTo(70));77        }7879        [Test]80        public void List_LevelWithExclusionOfJanuary2005AndNonExistingMember_ListOfMembers()81        {82            var connStr = ConnectionStringReader.GetAdomd();83            var excludedMembers = new List<string>() { "January 2005", "Non existing month 2005" };84            var cmd = new MembersCommand(connStr, "Members", null, excludedMembers, null);85            var filters = new List<CaptionFilter>(){ 86                    new CaptionFilter("Adventure Works", DiscoveryTarget.Perspectives),87                    new CaptionFilter("Date", DiscoveryTarget.Dimensions),88                    new CaptionFilter("Calendar", DiscoveryTarget.Hierarchies),89                    new CaptionFilter("Month", DiscoveryTarget.Levels)90                };9192            var result = cmd.List(filters);93            Assert.That(result.Count, Is.EqualTo(71));94        }9596        [Test]97        public void List_HierarchyWithExclusionOfAll_ListOfMembers()98        {99            var connStr = ConnectionStringReader.GetAdomd();100            var excludedMembers = new List<string>() { "All" };101            var cmd = new MembersCommand(connStr, "Members", null, excludedMembers, null);102            var filters = new List<CaptionFilter>(){ 103                    new CaptionFilter("Adventure Works", DiscoveryTarget.Perspectives),104                    new CaptionFilter("Date", DiscoveryTarget.Dimensions),105                    new CaptionFilter("Month Of Year", DiscoveryTarget.Hierarchies),106                };107108            var result = cmd.List(filters);109            Assert.That(result.Count, Is.EqualTo(12));110        }111112        [Test]113        public void List_HierarchyWithExclusionOfPatternEndingByBer_ListOfMembers()114        {115            var connStr = ConnectionStringReader.GetAdomd();116            var excludedMembers = new List<string>() { "All" };117            var excludedPatterns = new List<PatternValue>() { new PatternValue() {Pattern=Pattern.EndWith, Text="ber" }};118            var cmd = new MembersCommand(connStr, "Members", null, excludedMembers, excludedPatterns);119            var filters = new List<CaptionFilter>(){ 120                    new CaptionFilter("Adventure Works", DiscoveryTarget.Perspectives),121                    new CaptionFilter("Date", DiscoveryTarget.Dimensions),122                    new CaptionFilter("Month Of Year", DiscoveryTarget.Hierarchies),123                };124125            var result = cmd.List(filters);126            Assert.That(result.Count, Is.EqualTo(8));127        }128129        [Test]130        public void List_HierarchyWithExclusionOfPatternStartingByJu_ListOfMembers()131        {132            var connStr = ConnectionStringReader.GetAdomd();133            var excludedMembers = new List<string>() { "All" };134            var excludedPatterns = new List<PatternValue>() { new PatternValue() { Pattern = Pattern.StartWith, Text = "Ju" } };135            var cmd = new MembersCommand(connStr, "Members", null, excludedMembers, excludedPatterns);136            var filters = new List<CaptionFilter>(){ 137                    new CaptionFilter("Adventure Works", DiscoveryTarget.Perspectives),138                    new CaptionFilter("Date", DiscoveryTarget.Dimensions),139                    new CaptionFilter("Month Of Year", DiscoveryTarget.Hierarchies),140                };141142            var result = cmd.List(filters);143            Assert.That(result.Count, Is.EqualTo(10));144        }145146        [Test]147        public void List_HierarchyWithExclusionOfPatternContainEm_ListOfMembers()148        {149            var connStr = ConnectionStringReader.GetAdomd();150            var excludedMembers = new List<string>() { "All" };151            var excludedPatterns = new List<PatternValue>() { new PatternValue() { Pattern = Pattern.Contain, Text = "em" } };152            var cmd = new MembersCommand(connStr, "Members", null, excludedMembers, excludedPatterns);153            var filters = new List<CaptionFilter>(){ 154                    new CaptionFilter("Adventure Works", DiscoveryTarget.Perspectives),155                    new CaptionFilter("Date", DiscoveryTarget.Dimensions),156                    new CaptionFilter("Month Of Year", DiscoveryTarget.Hierarchies),157                };158159            var result = cmd.List(filters);160            //SeptEMber, NovEMber, DecEMber161            Assert.That(result.Count, Is.EqualTo(9));162        }163164        [Test]165        public void List_LevelWithExclusionOfPatternContainEm_ListOfMembers()166        {167            var connStr = ConnectionStringReader.GetAdomd();168            var excludedMembers = new List<string>() { "All" };169            var excludedPatterns = new List<PatternValue>() { new PatternValue() { Pattern = Pattern.Contain, Text = "em" } };170            var cmd = new MembersCommand(connStr, "Members", null, excludedMembers, excludedPatterns);171            var filters = new List<CaptionFilter>(){ 172                    new CaptionFilter("Adventure Works", DiscoveryTarget.Perspectives),173                    new CaptionFilter("Date", DiscoveryTarget.Dimensions),174                    new CaptionFilter("Calendar", DiscoveryTarget.Hierarchies),175                    new CaptionFilter("Month", DiscoveryTarget.Levels),176                };177178            var result = cmd.List(filters);179            //6years and exlude SeptEMber, NovEMber, DecEMber (+All)180            Assert.That(result.Count, Is.EqualTo(6*9));181        }182183        [Test]184        public void List_HierarchyWithMemberChildren_ListOfMembers()185        {186            var connStr = ConnectionStringReader.GetAdomd();187            var member = "Q3 CY 2006";188            var cmd = new MembersCommand(connStr, "Children", member, null, null);189            var filters = new List<CaptionFilter>(){ 190                    new CaptionFilter("Adventure Works", DiscoveryTarget.Perspectives),191                    new CaptionFilter("Date", DiscoveryTarget.Dimensions),192                    new CaptionFilter("Calendar", DiscoveryTarget.Hierarchies),193                };194195            var result = cmd.List(filters);196            //REturns the 3 months of the Q3197            Assert.That(result.Count, Is.EqualTo(3));198        }199200        [Test]201        public void List_HierarchyWithMemberChildrenAndExclusion_ListOfMembers()202        {203            var connStr = ConnectionStringReader.GetAdomd();204            var member = "Q3 CY 2006";205            var excludedMembers = new List<string>() { "All" };206            var excludedPatterns = new List<PatternValue>() { new PatternValue() { Pattern = Pattern.Contain, Text = "em" } };207            var cmd = new MembersCommand(connStr, "Children", member, excludedMembers, excludedPatterns);208            var filters = new List<CaptionFilter>(){ 209                    new CaptionFilter("Adventure Works", DiscoveryTarget.Perspectives),210                    new CaptionFilter("Date", DiscoveryTarget.Dimensions),211                    new CaptionFilter("Calendar", DiscoveryTarget.Hierarchies),212                };213214            var result = cmd.List(filters);215            //REturns the 3 months of the Q3 and remove SeptEMber216            Assert.That(result.Count, Is.EqualTo(2));217        }218219        [Test]220        public void List_LevelWithMemberChildren_ListOfMembers()221        {222            var connStr = ConnectionStringReader.GetAdomd();223            var member = "January 2005";224            var cmd = new MembersCommand(connStr, "Children", member, null, null);225            var filters = new List<CaptionFilter>(){ 226                    new CaptionFilter("Adventure Works", DiscoveryTarget.Perspectives),227                    new CaptionFilter("Date", DiscoveryTarget.Dimensions),228                    new CaptionFilter("Calendar", DiscoveryTarget.Hierarchies),229                    new CaptionFilter("Month", DiscoveryTarget.Levels)230                };231232            var result = cmd.List(filters);233            //Returns the 31 days of the month234            Assert.That(result.Count, Is.EqualTo(31));235        }236237        [Test]238        public void List_LevelsWithMemberChildrenAndExclusion_ListOfMembers()239        {240            var connStr = ConnectionStringReader.GetAdomd();241            var member = "January 2005";242            var excludedPatterns = new List<PatternValue>() { new PatternValue() { Pattern = Pattern.Contain, Text = "3" } };243            var cmd = new MembersCommand(connStr, "Children", member, null, excludedPatterns);244            var filters = new List<CaptionFilter>(){ 245                    new CaptionFilter("Adventure Works", DiscoveryTarget.Perspectives),246                    new CaptionFilter("Date", DiscoveryTarget.Dimensions),247                    new CaptionFilter("Calendar", DiscoveryTarget.Hierarchies),248                    new CaptionFilter("Month", DiscoveryTarget.Levels)249                };250251            var result = cmd.List(filters);252            //Returns the 31 days of the month minus 3, 13, 23, 30, 31253            Assert.That(result.Count, Is.EqualTo(31-5));254        }255256        [Test]257        public void List_Set_ListOfMembers()258        {259            var connStr = ConnectionStringReader.GetAdomd();260            var cmd = new MembersCommand(connStr, string.Empty, string.Empty, null, null);261            var filters = new List<CaptionFilter>(){ 262                    new CaptionFilter("Adventure Works", DiscoveryTarget.Perspectives),263                    new CaptionFilter("Top 50 Customers", DiscoveryTarget.Sets)264                };265266            var result = cmd.List(filters);267            Assert.That(result.Count, Is.EqualTo(50));268        }269270        [Test]271        [Ignore("Filtering not defined for sets")]272        public void List_SetWithExclusion_ListOfMembers()273        {274            var connStr = ConnectionStringReader.GetAdomd();275            var excludedPatterns = new List<PatternValue>() { new PatternValue() { Pattern = Pattern.StartWith, Text = "A" } };276            var cmd = new MembersCommand(connStr, string.Empty, string.Empty, null, excludedPatterns);277            var filters = new List<CaptionFilter>(){ 278                    new CaptionFilter("Adventure Works", DiscoveryTarget.Perspectives),279                    new CaptionFilter("Top 50 Customers", DiscoveryTarget.Sets)280                };281282            var result = cmd.List(filters);283            Assert.That(result.Count, Is.EqualTo(50));284        }285    }286}
...

MembersCommand.cs

Source:MembersCommand.cs

...79        }808182        [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Security", "CA2100:Review SQL queries for security vulnerabilities")]83        public virtual MemberResult List(IEnumerable<IFilter> filters)84        {85            var list = new MemberResult();8687            Inform("Investigating members");8889            using (var cmd = CreateCommand())90            {91                var path = BuildPath(filters);92                var perspective = GetPerspective(filters);93                var commandText = Build(perspective.Value, path, Function, MemberCaption, ExcludedMembers, ExcludedPatterns);94                cmd.CommandText = commandText;95                if (!(cmd is AdomdCommand))96                    throw new NotImplementedException();97                var cs = ExecuteCellSet(cmd as AdomdCommand);
...

List

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;7using NBi.Core.Analysis.Metadata;8using NBi.Core.Analysis.Request;9using NBi.Core.Calculation;10using NBi.Core.Calculation.Predicate;11using NBi.Core.Calculation.Predicate.Numeric;12using NBi.Core.Calculation.Predicate.Text;13using NBi.Core.ResultSet;14using NBi.Core.ResultSet.Alteration.Duplication;15using NBi.Core.ResultSet.Alteration.Extension;16using NBi.Core.ResultSet.Alteration.Renaming;17using NBi.Core.ResultSet.Alteration.Summarization;18using NBi.Core.ResultSet.Alteration.Type;19using NBi.Core.ResultSet.Resolver;20using NBi.Core.Sequence.Resolver;21using NBi.Core.Scalar.Resolver;22using NBi.Core.Transformation;23using NBi.Core.Transformation.Aggregation;24using NBi.Core.Transformation.Transformer.Native;25using NBi.Core.Variable;26using NBi.Core.Xml;27using NBi.Core.Xml.Constraints;28using NBi.Core.Xml.Settings;29using NBi.Core.Xml.Variables;30using NBi.Core.Xml.Variables.Sequence;31using NBi.Core.Xml.Variables.Scalar;32using NBi.Core.Xml.Variables.Sequence;33using NBi.Core.Xml.Variables.Scalar;

List

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;7using NBi.Core.Analysis.Request;8using NBi.Core.Analysis.Member.Resolver;9using NBi.Core.Etl;10using NBi.Core.Analysis.Metadata.Adomd;11using NBi.Core.Analysis.Metadata;12using NBi.Core.Analysis.Metadata.Member;13using NBi.Core.Analysis;14using NBi.Core;15using NBi.Core.Calculation;16using NBi.Core.Calculation.Grouping;17using NBi.Core.Calculation.Predicate;18using NBi.Core.Calculation.Ranking;19using NBi.Core.Calculation.Ranking.Percentile;20using NBi.Core.Calculation.Ranking.Quintile;21using NBi.Core.Calculation.Ranking.Quartile;22using NBi.Core.Calculation.Ranking.Decile;23using NBi.Core.Calculation.Ranking.Ntile;

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.