Example: banding points - Microstrategy

Report requirements

You want to create two reports that rank employees according to the revenue that each employee generates.

  1. Based on their revenue, the first report should segregate the employees into the following three groups; Top for the top 10%, Next for the next 40%, and Lowest for the lowest 50%.
  2. Based on their revenue, the second report should segregate the employees into the following three groups; Lowest for the lowest 10%, Next for the next 40%, and Top for the top 50%.

Solution

To create the first report, create a custom group called Employee Revenue and specify the banding points as 0, 10, 50, and 100. Create a report that uses this custom group. A sample report is shown in the following figure.

Report requirements

The engine considers 0 as the highest banding point and 100 as the lowest banding point; hence, based on the revenue, it places the highest 10% of employees in the first band and so on.

To create the second report, create a custom group called Employee Revenue and specify the banding points in reverse order, that is, specify the banding points as 100, 90, 50, and 0.

Again, the engine applies the same logic. It considers 0 as the highest banding point and 100 as the lowest banding point. Based on the revenue, it places the lowest 10% of employees in the first band, the next 40% of employees in the second band, and the highest 50% of employees in the third band as shown in the following figure.

employees in the third band


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

Microstrategy Topics