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:
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:
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
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.
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.
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
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.