Unlock 30% off on Manual Testing Annual Plans this Holiday Season.

Copied to Clipboard!

How to use TabularStructureDiscoveryFactory method of NBi.Core.Structure.Tabular.TabularStructureDiscoveryFactory class

Best NBi code snippet using NBi.Core.Structure.Tabular.TabularStructureDiscoveryFactory.TabularStructureDiscoveryFactory

TabularStructureDiscoveryFactoryTest.cs

Source:TabularStructureDiscoveryFactoryTest.cs

...9{1011    [TestFixture]12    [Category("Olap")]13    public class TabularStructureDiscoveryFactoryTest14    {1516        [Test]17        public void Execute_TabularDateDimensionWithHeighTeenHierarchies_ListStructureContainingSevenTeenElements()18        {19            var conn = new AdomdConnection(ConnectionStringReader.GetAdomdTabular());20            var factory = new TabularStructureDiscoveryFactory(conn);21            var cmd = factory.Instantiate(Target.Hierarchies, TargetType.Object,22                new CaptionFilter[] {23                    new CaptionFilter(Target.Perspectives, "Internet Operation"),24                    new CaptionFilter(Target.Dimensions, "Date")25                });2627            var structs = cmd.Execute();2829            Assert.That(structs.Count(), Is.EqualTo(17));30        }313233        [Test]34        public void Execute_TabularCalendarHierarchyWithSixLevels_ListStructureContainingSixElements()35        {36            var conn = new AdomdConnection(ConnectionStringReader.GetAdomdTabular());37            var factory = new TabularStructureDiscoveryFactory(conn);38            var cmd = factory.Instantiate(Target.Levels, TargetType.Object,39                new CaptionFilter[] {40                    new CaptionFilter(Target.Perspectives, "Internet Operation"),41                    new CaptionFilter(Target.Dimensions, "Date"),42                    new CaptionFilter(Target.Hierarchies, "Calendar")43                });44            45            var structs = cmd.Execute();4647            Assert.That(structs.Count(), Is.EqualTo(6));48        }495051        [Test]52        public void Execute_TabularMonthLevelWithTwoProperties_ListStructureContainingNoElement()53        {54            var conn = new AdomdConnection(ConnectionStringReader.GetAdomdTabular());55            var factory = new TabularStructureDiscoveryFactory(conn);56            var cmd = factory.Instantiate(Target.Properties, TargetType.Object,57                new CaptionFilter[] {58                    new CaptionFilter(Target.Perspectives,"Adventure Works"),59                    new CaptionFilter(Target.Dimensions,"Date"),60                    new CaptionFilter(Target.Hierarchies,"Calendar"),61                    new CaptionFilter(Target.Levels,"Month")62                });63            64            var structs = cmd.Execute();6566            Assert.That(structs.Count(), Is.EqualTo(0));67        }686970        [Test]71        public void Execute_TabularMeasureGroupsForFinance_ThreeElements()72        {73            var conn = new AdomdConnection(ConnectionStringReader.GetAdomdTabular());74            var factory = new TabularStructureDiscoveryFactory(conn);75            var cmd = factory.Instantiate(Target.MeasureGroups, TargetType.Object,76                new CaptionFilter[] {77                    new CaptionFilter(Target.Perspectives,"Internet Operation"),78                });7980            var structs = cmd.Execute();8182            Assert.That(structs.Count(), Is.EqualTo(3));83        }848586        [Test]87        public void Execute_TabularMeasuresForMeasureGroupInternetSales_SeventeenElements()88        {89            var conn = new AdomdConnection(ConnectionStringReader.GetAdomdTabular());90            var factory = new TabularStructureDiscoveryFactory(conn);91            var cmd = factory.Instantiate(Target.Measures, TargetType.Object,92                new CaptionFilter[] {93                    new CaptionFilter(Target.Perspectives,"Internet Operation"),94                    new CaptionFilter(Target.MeasureGroups,"Internet Sales")95                });9697            var structs = cmd.Execute();9899            Assert.That(structs.Count(), Is.EqualTo(17));100        }101102103        [Test]104        public void Execute_TabularSchemas_FourElements()105        {106            var conn = new AdomdConnection(ConnectionStringReader.GetAdomdTabular());107            var factory = new TabularStructureDiscoveryFactory(conn);108            var cmd = factory.Instantiate(Target.Perspectives, TargetType.Object,109                new CaptionFilter[] {110                });111112            var structs = cmd.Execute();113114            Assert.That(structs.Count(), Is.EqualTo(4));115        }116117        [Test]118        public void Execute_TabularTablesForInternetOperation_FifteenElements()119        {120            var conn = new AdomdConnection(ConnectionStringReader.GetAdomdTabular());121            var factory = new TabularStructureDiscoveryFactory(conn);122            var cmd = factory.Instantiate(Target.Tables, TargetType.Object,123                new CaptionFilter[] {124                    new CaptionFilter(Target.Perspectives,"Internet Operation"),125                });126127            var structs = cmd.Execute();128129            Assert.That(structs.Count(), Is.EqualTo(15));130        }131132        [Test]133        public void Execute_TabularColumnsForInternetSales_TwentySevenElements()134        {135            var conn = new AdomdConnection(ConnectionStringReader.GetAdomdTabular());136            var factory = new TabularStructureDiscoveryFactory(conn);137            var cmd = factory.Instantiate(Target.Columns, TargetType.Object,138                new CaptionFilter[] {139                    new CaptionFilter(Target.Perspectives,"Internet Operation"),140                    new CaptionFilter(Target.Tables,"Internet Sales"),141                });142143            var structs = cmd.Execute();144145            Assert.That(structs.Count(), Is.EqualTo(27));146        }147148        [Test]149        public void Execute_OnSchemaNamedInternetOperation_ListStructureContainingTenTables()150        {151            var conn = new AdomdConnection(ConnectionStringReader.GetAdomdTabular());152            var factory = new TabularStructureDiscoveryFactory(conn);153            var cmd = factory.Instantiate(Target.Tables, TargetType.Object,154                new CaptionFilter[] {155                    new CaptionFilter(Target.Perspectives, "Internet Operation")});156157            var structs = cmd.Execute();158159            Assert.That(structs.Count(), Is.EqualTo(15));160        }161162        [Test]163        public void Execute_OnTableNamedCurrency_ListStructureContainingThreeColumns()164        {165            var conn = new AdomdConnection(ConnectionStringReader.GetAdomdTabular());166            var factory = new TabularStructureDiscoveryFactory(conn);167            var cmd = factory.Instantiate(Target.Columns, TargetType.Object,168                new CaptionFilter[] {169                    new CaptionFilter(Target.Perspectives, "Internet Operation"),170                    new CaptionFilter(Target.Tables, "Currency")171            });172173            var structs = cmd.Execute();174175            Assert.That(structs.Count(), Is.EqualTo(3));176        }177178        //[Test]179        //[Ignore]180        //public void Execute_TabularDateDimensionLinkedToThreeMeasureGroups_ListStructureContainingThreeElements()
...

StructureDiscoveryFactoryProvider.cs

Source:StructureDiscoveryFactoryProvider.cs

...34        protected virtual void Initialize()35        {36            dico.Add(Olap, typeof(OlapStructureDiscoveryFactory));37            dico.Add(Relational, typeof(RelationalStructureDiscoveryFactory));38            dico.Add(Tabular, typeof(TabularStructureDiscoveryFactory));39        }4041        public IStructureDiscoveryFactory Instantiate(string connectionString)42        {43            var sessionFactory = new ClientProvider();44            var connection = sessionFactory.Instantiate(connectionString).CreateNew() as IDbConnection;45            var dbType = MapConnectionTypeToDatabaseType(connection);4647            if (!dico.Keys.Contains(dbType))48                throw new ArgumentException();4950            var factoryType = dico[dbType];51            var ctor = factoryType.GetConstructor(new Type[]{typeof(IDbConnection)});52            var factory = (IStructureDiscoveryFactory)ctor.Invoke(new object[] { connection });
...

TabularStructureDiscoveryFactory.cs

Source:TabularStructureDiscoveryFactory.cs

...12using NBi.Core.Structure.Olap;1314namespace NBi.Core.Structure.Tabular15{16    class TabularStructureDiscoveryFactory : OlapStructureDiscoveryFactory17    {18        public TabularStructureDiscoveryFactory(IDbConnection connection)19            : base(connection)20        {21        }2223        protected override IDiscoveryCommandBuilder InstantiateBuilder(Target target, TargetType type)24        {25            if (type != TargetType.Object)26                throw new ArgumentOutOfRangeException();2728            switch (target)29            {30                case Target.Perspectives:31                    return new PerspectiveDiscoveryCommandBuilder();32                case Target.MeasureGroups:
...