예제 #1
0
        public void List_LevelsWithMemberChildrenAndExclusion_ListOfMembers()
        {
            var connStr          = ConnectionStringReader.GetAdomd();
            var member           = "January 2005";
            var excludedPatterns = new List <PatternValue>()
            {
                new PatternValue()
                {
                    Pattern = Pattern.Contain, Text = "3"
                }
            };
            var cmd     = new MembersCommand(connStr, "Children", member, null, excludedPatterns);
            var filters = new List <CaptionFilter>()
            {
                new CaptionFilter("Adventure Works", DiscoveryTarget.Perspectives),
                new CaptionFilter("Date", DiscoveryTarget.Dimensions),
                new CaptionFilter("Calendar", DiscoveryTarget.Hierarchies),
                new CaptionFilter("Month", DiscoveryTarget.Levels)
            };

            var result = cmd.List(filters);

            //Returns the 31 days of the month minus 3, 13, 23, 30, 31
            Assert.That(result.Count, Is.EqualTo(31 - 5));
        }
예제 #2
0
        public void List_HierarchyWithMemberChildrenAndExclusion_ListOfMembers()
        {
            var connStr         = ConnectionStringReader.GetAdomd();
            var member          = "Q3 CY 2006";
            var excludedMembers = new List <string>()
            {
                "All"
            };
            var excludedPatterns = new List <PatternValue>()
            {
                new PatternValue()
                {
                    Pattern = Pattern.Contain, Text = "em"
                }
            };
            var cmd     = new MembersCommand(connStr, "Children", member, excludedMembers, excludedPatterns);
            var filters = new List <CaptionFilter>()
            {
                new CaptionFilter("Adventure Works", DiscoveryTarget.Perspectives),
                new CaptionFilter("Date", DiscoveryTarget.Dimensions),
                new CaptionFilter("Calendar", DiscoveryTarget.Hierarchies),
            };

            var result = cmd.List(filters);

            //REturns the 3 months of the Q3 and remove SeptEMber
            Assert.That(result.Count, Is.EqualTo(2));
        }
예제 #3
0
        public void List_LevelWithExclusionOfPatternContainEm_ListOfMembers()
        {
            var connStr         = ConnectionStringReader.GetAdomd();
            var excludedMembers = new List <string>()
            {
                "All"
            };
            var excludedPatterns = new List <PatternValue>()
            {
                new PatternValue()
                {
                    Pattern = Pattern.Contain, Text = "em"
                }
            };
            var cmd     = new MembersCommand(connStr, "Members", null, excludedMembers, excludedPatterns);
            var filters = new List <CaptionFilter>()
            {
                new CaptionFilter("Adventure Works", DiscoveryTarget.Perspectives),
                new CaptionFilter("Date", DiscoveryTarget.Dimensions),
                new CaptionFilter("Calendar", DiscoveryTarget.Hierarchies),
                new CaptionFilter("Month", DiscoveryTarget.Levels),
            };

            var result = cmd.List(filters);

            //6years and exlude SeptEMber, NovEMber, DecEMber (+All)
            Assert.That(result.Count, Is.EqualTo(6 * 9));
        }
예제 #4
0
        public void List_HierarchyWithExclusionOfPatternStartingByJu_ListOfMembers()
        {
            var connStr         = ConnectionStringReader.GetAdomd();
            var excludedMembers = new List <string>()
            {
                "All"
            };
            var excludedPatterns = new List <PatternValue>()
            {
                new PatternValue()
                {
                    Pattern = Pattern.StartWith, Text = "Ju"
                }
            };
            var cmd     = new MembersCommand(connStr, "Members", null, excludedMembers, excludedPatterns);
            var filters = new List <CaptionFilter>()
            {
                new CaptionFilter("Adventure Works", DiscoveryTarget.Perspectives),
                new CaptionFilter("Date", DiscoveryTarget.Dimensions),
                new CaptionFilter("Month Of Year", DiscoveryTarget.Hierarchies),
            };

            var result = cmd.List(filters);

            Assert.That(result.Count, Is.EqualTo(10));
        }
예제 #5
0
        public void List_Set_ListOfMembers()
        {
            var connStr = ConnectionStringReader.GetAdomd();
            var cmd     = new MembersCommand(connStr, string.Empty, string.Empty, null, null);
            var filters = new List <CaptionFilter>()
            {
                new CaptionFilter("Adventure Works", DiscoveryTarget.Perspectives),
                new CaptionFilter("Top 50 Customers", DiscoveryTarget.Sets)
            };

            var result = cmd.List(filters);

            Assert.That(result.Count, Is.EqualTo(50));
        }
예제 #6
0
        public void List_Hierarchy_ListOfMembers()
        {
            var connStr = ConnectionStringReader.GetAdomd();
            var cmd     = new MembersCommand(connStr, "Members", null);
            var filters = new List <CaptionFilter>()
            {
                new CaptionFilter("Adventure Works", DiscoveryTarget.Perspectives),
                new CaptionFilter("Date", DiscoveryTarget.Dimensions),
                new CaptionFilter("Month Of Year", DiscoveryTarget.Hierarchies),
            };

            var result = cmd.List(filters);

            Assert.That(result.Count, Is.EqualTo(13));
        }
예제 #7
0
        public void List_HierarchyWithMemberChildren_ListOfMembers()
        {
            var connStr = ConnectionStringReader.GetAdomd();
            var member  = "Q3 CY 2006";
            var cmd     = new MembersCommand(connStr, "Children", member, null, null);
            var filters = new List <CaptionFilter>()
            {
                new CaptionFilter("Adventure Works", DiscoveryTarget.Perspectives),
                new CaptionFilter("Date", DiscoveryTarget.Dimensions),
                new CaptionFilter("Calendar", DiscoveryTarget.Hierarchies),
            };

            var result = cmd.List(filters);

            //REturns the 3 months of the Q3
            Assert.That(result.Count, Is.EqualTo(3));
        }
예제 #8
0
        public void List_LevelWithExclusionOfJanuary2005AndNonExistingMember_ListOfMembers()
        {
            var connStr         = ConnectionStringReader.GetAdomd();
            var excludedMembers = new List <string>()
            {
                "January 2005", "Non existing month 2005"
            };
            var cmd     = new MembersCommand(connStr, "Members", null, excludedMembers, null);
            var filters = new List <CaptionFilter>()
            {
                new CaptionFilter("Adventure Works", DiscoveryTarget.Perspectives),
                new CaptionFilter("Date", DiscoveryTarget.Dimensions),
                new CaptionFilter("Calendar", DiscoveryTarget.Hierarchies),
                new CaptionFilter("Month", DiscoveryTarget.Levels)
            };

            var result = cmd.List(filters);

            Assert.That(result.Count, Is.EqualTo(71));
        }
예제 #9
0
        public void List_SetWithExclusion_ListOfMembers()
        {
            var connStr          = ConnectionStringReader.GetAdomd();
            var excludedPatterns = new List <PatternValue>()
            {
                new PatternValue()
                {
                    Pattern = Pattern.StartWith, Text = "A"
                }
            };
            var cmd     = new MembersCommand(connStr, string.Empty, string.Empty, null, excludedPatterns);
            var filters = new List <CaptionFilter>()
            {
                new CaptionFilter("Adventure Works", DiscoveryTarget.Perspectives),
                new CaptionFilter("Top 50 Customers", DiscoveryTarget.Sets)
            };

            var result = cmd.List(filters);

            Assert.That(result.Count, Is.EqualTo(50));
        }