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

Copied to Clipboard!

Automation Advisor
NBi
NBi.Core.Structure.Olap.Builders
MeasureGroupDiscoveryCommandBuilder

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

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

OlapStructureDiscoveryFactory.cs

Source:OlapStructureDiscoveryFactory.cs

...57                    {58                        case Target.Perspectives:59                            return new PerspectiveDiscoveryCommandBuilder();60                        case Target.MeasureGroups:61                            return new MeasureGroupDiscoveryCommandBuilder();62                        case Target.Measures:63                            return new MeasureDiscoveryCommandBuilder();64                        case Target.Dimensions:65                            return new DimensionDiscoveryCommandBuilder();66                        case Target.Hierarchies:67                            return new HierarchyDiscoveryCommandBuilder();68                        case Target.Levels:69                            return new LevelDiscoveryCommandBuilder();70                        case Target.Properties:71                            return new PropertyDiscoveryCommandBuilder();72                        case Target.Sets:73                            return new SetDiscoveryCommandBuilder();74                        default:75                            throw new ArgumentOutOfRangeException();
...

TabularStructureDiscoveryFactory.cs

Source:TabularStructureDiscoveryFactory.cs

...29            {30                case Target.Perspectives: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();
...

MeasureGroupDiscoveryCommandBuilder.cs

Source:MeasureGroupDiscoveryCommandBuilder.cs

...6using System.Threading.Tasks;78namespace NBi.Core.Structure.Olap.Builders9{10    class MeasureGroupDiscoveryCommandBuilder : MultidimensionalDiscoveryCommandBuilder11    {12        protected override string BasicCommandText13        {14            get { return "select {0}_name, {1} from [$system].mdschema_{2} where left(cube_name,1)<>'$'{3}"; }15        }1617        public MeasureGroupDiscoveryCommandBuilder()18        {19            CaptionName = "measuregroup";20            TableName = "measures";21            VisibleName = "measure";22        }2324        protected override IEnumerable<IFilter> BuildCaptionFilters(IEnumerable<CaptionFilter> filters)25        {26            yield return new CommandFilter("len(measuregroup_name)>0");27            28            yield return new CommandFilter(string.Format("[cube_name]='{0}'"29                                    , filters.Single(f => f.Target == Target.Perspectives).Caption30                                    ));31
...