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

How to use HierarchyDiscoveryCommandBuilder class of NBi.Core.Structure.Olap.Builders package

Best NBi code snippet using NBi.Core.Structure.Olap.Builders.HierarchyDiscoveryCommandBuilder

HierarchyDiscoveryCommandBuilderTest.cs

Source:HierarchyDiscoveryCommandBuilderTest.cs

...4using NBi.Core.Structure.Olap.Builders;5namespace NBi.Testing.Core.Structure.Olap.Builders6{7    [TestFixture]8    public class HierarchyDiscoveryCommandBuilderTest9    {10        [Test]11        public void GetCommandText_FiltersContainDisplayFolder_DisplayFolderIsNotInCommandFilter()12        {13            var filters  = new CaptionFilter[]14            {15                new CaptionFilter(Target.Perspectives, "my perspective")16                , new CaptionFilter(Target.Dimensions, "my dimension")17                , new CaptionFilter(Target.DisplayFolders, "my display-folder")18                , new CaptionFilter(Target.Hierarchies, "my hierarchy")19            };20            var builder = new HierarchyDiscoveryCommandBuilder();21            builder.Build(filters);22            var commandText = builder.GetCommandText();23            Assert.That(commandText, Does.Not.Contain("Display").And.Not.Contain("Folder"));24        }25        [Test]26        public void GetCommandText_FiltersContainDisplayFolder_CommandFiltersDoesNotContainDoubleAnd()27        {28            var filters  = new CaptionFilter[]29            {30                new CaptionFilter(Target.Perspectives, "my perspective")31                , new CaptionFilter(Target.Dimensions, "my dimension")32                , new CaptionFilter(Target.DisplayFolders, "my display-folder")33                , new CaptionFilter(Target.Hierarchies, "my hierarchy")34            };35            var builder = new HierarchyDiscoveryCommandBuilder();36            builder.Build(filters);37            var commandText = builder.GetCommandText();38            Assert.That(commandText.Replace(" ","").ToLower(), Does.Not.Contain("andand"));39        }40        [Test]41        public void Build_FiltersContainDisplayFolder_PostCommandFilterIsNotEmpty()42        {43            var filters  = new CaptionFilter[]44            {45                new CaptionFilter(Target.Perspectives, "my perspective")46                , new CaptionFilter(Target.Dimensions, "my dimension")47                , new CaptionFilter(Target.DisplayFolders, "my display-folder")48                , new CaptionFilter(Target.Hierarchies, "my hierarchy")49            };50            var builder = new HierarchyDiscoveryCommandBuilder();51            builder.Build(filters);52            var postFilters = builder.GetPostFilters();53            Assert.That(postFilters, Is.Not.Null.And.Not.Empty);54        }55    }56}...

TabularStructureDiscoveryFactory.cs

Source:TabularStructureDiscoveryFactory.cs

...35                    return new MeasureDiscoveryCommandBuilder();36                case Target.Dimensions:37                    return new DimensionDiscoveryCommandBuilder();38                case Target.Hierarchies:39                    return new HierarchyDiscoveryCommandBuilder();40                case Target.Levels:41                    return new LevelDiscoveryCommandBuilder();42                case Target.Properties:43                    return new PropertyDiscoveryCommandBuilder();44                case Target.Tables:45                    return new TableDiscoveryCommandBuilder();46                case Target.Columns:47                    return new ColumnDiscoveryCommandBuilder();48                case Target.Sets:49                    return new SetDiscoveryCommandBuilder();50                default:51                    throw new ArgumentOutOfRangeException();52            }53        }
...

HierarchyDiscoveryCommandBuilder.cs

Source:HierarchyDiscoveryCommandBuilder.cs

...7using System.Threading.Tasks;89namespace NBi.Core.Structure.Olap.Builders10{11    class HierarchyDiscoveryCommandBuilder : MultidimensionalDiscoveryCommandBuilder12    {13        public HierarchyDiscoveryCommandBuilder()14        {15            CaptionName = "hierarchy";16            DisplayFolderName = "hierarchy";17            TableName = "hierarchies";18            VisibleName = "hierarchy";19        }2021        protected override IEnumerable<IFilter> BuildCaptionFilters(IEnumerable<CaptionFilter> filters)22        {23            yield return new CommandFilter(string.Format("[cube_name]='{0}'"24                                                           , filters.Single(f => f.Target == Target.Perspectives).Caption25                                                           ));2627            yield return new CommandFilter(string.Format("[dimension_unique_name]='[{0}]'"
...