Benefits of using a custom group - Microstrategy

The benefit of a custom group is its ability to group attribute elements in a way that is not defined in the data warehouse. You can create “relationships” between the attribute and the custom group. A custom group can organize attribute elements through:

  • attribute qualification
  • set qualification
  • report
  • filter
  • banding
  • advanced qualification

Banding qualification

Banding qualifiers enable you to create banding custom group elements. Banding is a method of slicing a list, defined by the output level, of attribute elements using the values of a metric. For example, you can slice the list of stores (“Store” attribute elements) using the values of the metric “Total Sales.” Suppose you have created a report that ranks stores according to the revenue generated by each store. You might decide to group the stores by creating one group for the top 10 stores, a second group for stores 11-20, and a third group for stores 21-30.

You can apply different types of banding:

  • Band size: to slice the range of metric values defined by “start at” and “stop at” values into a number of bands, each defined by the parameter “step size.”

    For example, in the following diagram the “start at” value is 10, “stop at” is 50, and “step size” is 10. These settings slice the group into four bands

    Banding qualification
  • Band count: to define the number of equal bands into which the range of metric values is sliced. On the other hand, you use band size to define the size of each band.

    For example, in the preceding diagram, the band count is set to four, which has the same effect as the band size example. If you set the band count to five instead, eight bands are produced.

  • Banding points: to specify the value where a band is placed. This enables you to produce bands of different sizes.

    The engine uses its internal logic to create the bands based on the banding points that you specify.

For example, you want to create a report with two bands, one band showing the top 10 stores and the second band showing stores 11-100. For this, you must use three points—1, 10, and 100—as shown in the following figure.

Benefits of using a custom group

To show a band of the bottom 10 stores and then the remaining, use the same points in reverse order, that is, 100, 10, and 1

All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd Protection Status

Microstrategy Topics