Explain us the KPI Grid Behaviour for the following business scenerios: (1) under Department sub-view and if you are selecting any values among the filters (2) under Department sub-view and not selecting any values among the filters

• Related Articles

• Sub view Dept is analysed but in the grid Class code data is appearing

  If you have selected the sub class then the product data gets appeared on the grid. It works according to the drill down functionality.

• Why are the KPI results not getting sorted by 'Department Code', when I view the KPI under Merchandise View and Department Subview?

  The KPI may not give the desired results due to any of the following reasons: - If there is 'Department_Code' levels defined under different dimensions with the same parameter name, then while constructing the query only the minimum level dimension ...

• The sequence of Q1...Q4 quarter filters appearing in the KPI Grid is not in order

  Ensure that the 'Quarter level' in 'DIM_DATE' in the 'dbmodel.xml' file contains the 'orderBy' condition. If not, please add the 'orderBy' condition to the Quarter level in DIM_DATE in the 'dbmodel.xml' file and re-cache changes for the applied ...

• The order of Q1-Q4 filters is not shown properly in KPI Grid. Why?

  The 'Quarter Level' of 'DIM_DATE' in the dbmodel.xml file should have 'OrderBy' condition. If not, do the following: 1. Add 'OrderBy' condition to the 'Quarter Level' in 'DIM_DATE of the dbmodel.xml file 2. 'Re-Cache Changes', to activate the ...

• In the KPI Grid Utility - SQL View, does the computed measures show as "SQL Generated from KPI"?

  They are computed measures and will not be displayed in the query as it is calculated by the application itself.