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

• Related Articles

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

• Kpi Help is not showing in Test uer

  The KPI Tool Tip can be enabled by Normal User by following the below steps: 1. Log into Application with Normal User Credentials 2. Click on Visual Personalization 3. In the pop-up window; go to Visual Tab 4. Check the Show Measure Details Tool-tip ...

• Getting Invalid KPI definition error while trying to access KPI.

  This issue can be due to large browser cache. Clear the browser cache and the issue should be fixed. If the problem persists, re-publish the KPI. If you require further help, please contact the support team.

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