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

• Related Articles

• I am not getting desired results using the SQL KPI. Please help.

  We suggest you to create an auto KPI instead of SQL KPI to get the desired results. SQL KPI is limited and expected to produce results for simple queries and complex queries are bound to not fetch any results

• Why am I getting unexpected results from weekly firm data viewer KPI?

  The Issue here is the column_name with which the measure 'C4182' was created is not mapped to any of the levels in the db2_dbmodel.xml file. This is a pre-requisite for any measure to function properly. Map the column_name to the appropriate level in ...

• Why cannot I change Department Code, Division Code, Class Code measure data types?

  This problem can occur due to the presence of duplicate measures. As there are identical measure names of same data type, you are unable to alter the data type. Please either rename or remove the duplicate measures and you should be able to alter the ...

• 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

  When you are under Department sub-view and if you are selecting any values among the filters (for e.g. sub-class) then, the resultant KPI grid displays sub-class as well as the exported Excel report shows the same. On the other hand, if you are under ...

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