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

Copied to Clipboard!

How to use MeasureDiscoveryCommandBuilder method of NBi.Core.Structure.Olap.Builders.MeasureDiscoveryCommandBuilder class

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

MeasureDiscoveryCommandBuilderTest.cs

Source:MeasureDiscoveryCommandBuilderTest.cs

...7using System.Text;8using System.Threading.Tasks;9namespace NBi.Testing.Core.Structure.Olap.Builders10{11    public class MeasureDiscoveryCommandBuilderTest12    {13        [Test]14        public void GetCommandText_CubeFilter_CorrectStatement()15        {16            var filters = new CaptionFilter[]17            {18                new CaptionFilter(Target.Perspectives, "cubeName")19            };20            var builder = new MeasureDiscoveryCommandBuilder();21            builder.Build(filters);22            var commandText = builder.GetCommandText();23            Assert.That(commandText.Replace(" ","").ToLower(), Does.Contain("[cube_name]='cubeName'".ToLower()));24            Assert.That(commandText.Replace(" ", "").ToLower(), Does.Not.Contain("[measuregroup_name]=".ToLower()));25        }26        [Test]27        public void GetCommandText_CubeFilterAndMeasureGroupFilter_CorrectStatement()28        {29            var filters = new CaptionFilter[]30            {31                new CaptionFilter(Target.Perspectives, "cubeName")32                , new CaptionFilter(Target.MeasureGroups, "measureGroupName")33            };34            var builder = new MeasureDiscoveryCommandBuilder();35            builder.Build(filters);36            var commandText = builder.GetCommandText();37            Assert.That(commandText.Replace(" ", "").ToLower(), Does.Contain("[cube_name]='cubeName'".ToLower()));38            Assert.That(commandText.Replace(" ", "").ToLower(), Does.Contain("[measuregroup_name]='measureGroupName'".ToLower()));39        }40        [Test]41        public void GetCommandText_CubeFilterMeasureGroupAndMeasureFilter_CorrectStatement()42        {43            var filters = new CaptionFilter[]44            {45                new CaptionFilter(Target.Perspectives, "cubeName")46                , new CaptionFilter(Target.MeasureGroups, "measureGroupName")47                , new CaptionFilter(Target.Measures, "measureName")48            };49            var builder = new MeasureDiscoveryCommandBuilder();50            builder.Build(filters);51            var commandText = builder.GetCommandText();52            Assert.That(commandText.Replace(" ", "").ToLower(), Does.Contain("[cube_name]='cubeName'".ToLower()));53            Assert.That(commandText.Replace(" ", "").ToLower(), Does.Contain("[measuregroup_name]='measureGroupName'".ToLower()));54            Assert.That(commandText.Replace(" ", "").ToLower(), Does.Contain("[measure_caption]='measureName'".ToLower()));55        }56        [Test]57        public void GetCommandText_CubeFilterMeasureGroupAndMeasureAndDisplayFolderFilter_CorrectStatement()58        {59            var filters = new CaptionFilter[]60            {61                new CaptionFilter(Target.Perspectives, "cubeName")62                , new CaptionFilter(Target.MeasureGroups, "measureGroupName")63                , new CaptionFilter(Target.Measures, "measureName")64                , new CaptionFilter(Target.DisplayFolders, "displayFolderName")65            };66            var builder = new MeasureDiscoveryCommandBuilder();67            builder.Build(filters);68            var commandText = builder.GetCommandText();69            Assert.That(commandText.Replace(" ", "").ToLower(), Does.Contain("[cube_name]='cubeName'".ToLower()));70            Assert.That(commandText.Replace(" ", "").ToLower(), Does.Contain("[measuregroup_name]='measureGroupName'".ToLower()));71            Assert.That(commandText.Replace(" ", "").ToLower(), Does.Contain("[measure_caption]='measureName'".ToLower()));72            Assert.That(commandText.Replace(" ", "").ToLower(), Does.Not.Contain("displayFolderName".ToLower()));73        }74        [Test]75        public void GetCommandText_CubeFilterMeasureGroupAndMeasureAndDisplayFolderFilter_CorrectPostFilter()76        {77            var filters = new CaptionFilter[]78            {79                new CaptionFilter(Target.Perspectives, "cubeName")80                , new CaptionFilter(Target.MeasureGroups, "measureGroupName")81                , new CaptionFilter(Target.Measures, "measureName")82                , new CaptionFilter(Target.DisplayFolders, "displayFolderName")83            };84            var builder = new MeasureDiscoveryCommandBuilder();85            builder.Build(filters);86            var postFilters = builder.GetPostFilters();87            Assert.That(postFilters.Count(), Is.EqualTo(1));88        }89    }90}...

TabularStructureDiscoveryFactory.cs

Source:TabularStructureDiscoveryFactory.cs

...31                    return new PerspectiveDiscoveryCommandBuilder();32                case Target.MeasureGroups:33                    return new MeasureGroupDiscoveryCommandBuilder();34                case Target.Measures: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();
...

MeasureDiscoveryCommandBuilder.cs

Source:MeasureDiscoveryCommandBuilder.cs

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