You want to create two reports that rank employees according to the revenue that each employee generates.
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.
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.
Microstrategy Related Interview Questions
|Informatica Interview Questions||IBM Cognos Interview Questions|
|Teradata Interview Questions||Adv Java Interview Questions|
|Cloud Computing Interview Questions||SQL Database Interview Questions|
|OBIEE Interview Questions||Qlik View Interview Questions|
|Tableau Interview Questions||Talend Interview Questions|
|IBM Cognos TM1 Interview Questions||Data modeling Interview Questions|
|Cognos ReportNet (CRN) Interview Questions||Qlik Sense Interview Questions|
Introduction To Advanced Reporting
Creating Freeform Sql Reports
Creating Olap Cube Reports
Data Mining Services
Custom Groups And Consolidations
All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd
Wisdomjobs.com is one of the best job search sites in India.