Banding qualifications

Banding qualifications allow you to slice a list of attribute elements using the values of a metric. For more information on custom group banding, see the Custom Groups section of the MicroStrategy Developer Help (formerly the MicroStrategy Desktop Help).

All banding qualifications require you to specify a metric by which the custom group values may be banded. You can specify the metric with just its name if it is the only item in the project by that name. If there are two items in the project with the same name, but in different locations, Command Manager will return an ambiguity error message. To correct this error, specify the full path to the metric and enclose it in brackets [ ], such as [Public Objects\Metrics\Sales Metrics\Revenue].

Numbers used in banding qualifications can be either integers or real numbers. If you are using real numbers, you must use the decimal separator specified in your Regional Settings.

MicroStrategy reports support three types of custom group banding qualifications:

• Band Size, which requires a metric, a start value, an end value, and a band size value: Banding(Cost, 1.0, 1000.0, 100.0) breaks the custom group element into ten bands based on Cost, starting from 1-100 and ending with 900-1000.
• Band Count, which requires a start value, an end value, and a number of bands: BandingC(Profit, 1.0, 1000.0, 100.0) breaks the custom group element into one hundred bands based on Profit, starting from 1-10 and ending with 990-1000.
• Banding Points, which require a start value, and ending values for each band: BandingP(Revenue, 1.0, 100.0, 500.0, 1000.0) breaks the custom group into three bands based on Revenue, starting from 1-100 and ending with 500-1000.

By default the custom group element is banded based on the actual values of the metric. Elements can also be banded by rank or by percentage.

To band by metric rank, put the name of the metric in brackets and precede it with the word Rank: Banding(Rank[Public Objects\Metrics\Sales Metrics\Cost], 1.0, 1000.0, 100.0).

To band by metric percentage, put the name of the metric in brackets and precede it with Rank<ByValue=False>: Banding(RankByValue=False[Public Objects\Metrics\Sales Metrics\Cost], 0, 1, 0.1). Note that in this case the percentage values must be converted to a decimal number between zero and one. For instance, twenty percent would be 0.2.

Examples

Banding(Cost, 
 1.0, 1000.0, 100.0)

BandingC(Profit, 
 1.0, 1000.0, 100.0)

BandingP(Revenue, 
 1.0, 100.0, 500.0, 1000.0)

Banding(Rank[Public 
 Objects\Metrics\Sales Metrics\Cost], 1.0, 1000.0, 100.0)

Banding(RankByValue=False[Public 
 Objects\Metrics\Sales Metrics\Cost], 0, 1, 0.1)