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

• Related Articles

• Unexpected results from "weekly film dataviewer" 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.

• 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 is Sales and Productivity KPI getting data from a Gregorian aggregate?

  When a KPI is analyzed, the aggregate table is picked up based on the least sequence number defined in the dbmodel.xml. For the KPI "Sales and Prdocutivity"; it is hitting to AGG_MLY_STR_AREA_GRE_DC Aggregate table instead of AGG_MLY_STR_AREA_DC_SC ...

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

• Why do I get the error "For Input String 'COR'" while analyzing KPI data from one among the three views? I get KPI data results properly with the other two views.

  The reason could be a mismatch between the data types of the measure defined and the column to which it is pointing to, in the data model.