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

Copied to Clipboard!

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

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

TabularStructureDiscoveryFactory.cs

Source:TabularStructureDiscoveryFactory.cs

...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();50                default:51                    throw new ArgumentOutOfRangeException();
...

DimensionDiscoveryCommandBuilderTest.cs

Source:DimensionDiscoveryCommandBuilderTest.cs

...7using System.Text;8using System.Threading.Tasks;9namespace NBi.Testing.Core.Structure.Olap.Builders10{11    public class DimensionDiscoveryCommandBuilderTest12    {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 DimensionDiscoveryCommandBuilder();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("[dimension_caption]=".ToLower()));25        }26        [Test]27        public void GetCommandText_CubeFilterAndDimensionFilter_CorrectStatement()28        {29            var filters = new CaptionFilter[]30            {31                new CaptionFilter(Target.Perspectives, "cubeName")32                , new CaptionFilter(Target.Dimensions, "dimensionName")33            };34            var builder = new DimensionDiscoveryCommandBuilder();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("[dimension_caption]='dimensionName'".ToLower()));39        }40    }41}...

DimensionDiscoveryCommandBuilder.cs

Source:DimensionDiscoveryCommandBuilder.cs

...7using System.Threading.Tasks;89namespace NBi.Core.Structure.Olap.Builders10{11    class DimensionDiscoveryCommandBuilder : MultidimensionalDiscoveryCommandBuilder12    {13        protected override string BasicCommandText14        {15            get { return "select {0}_caption, {1}, dimension_type from [$system].mdschema_{2} where left(cube_name,1)<>'$'{3}"; }16        }1718        public DimensionDiscoveryCommandBuilder()19        {20            CaptionName = "dimension";21            TableName = "dimensions";22            VisibleName = "dimension";23        }2425        protected override IEnumerable<IFilter> BuildCaptionFilters(IEnumerable<CaptionFilter> filters)26        {27            yield return new CommandFilter(string.Format("[cube_name]='{0}'"28                                                            , filters.Single(f => f.Target == Target.Perspectives).Caption29                                                            ));3031            yield return new DimensionType();32
...