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

Best NBi code snippet using NBi.Core.Structure.Olap.Builders.MeasureGroupDiscoveryCommandBuilder.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
...