KPI : Item Price Variance - exception : Error ocurred while creating the report - please retry

• Related Articles

• KPI log shows the error 'java.lang.Exception: Query Execution Failed ! :Ambiguous column name'. Why?

  KPI query returns ambiguos column error, when a particular measure is present in both the Aggregate table (Example, AGG_WLY_STR_DEPT_Details) and DIM table (example, DIM_STORE). You have to change the column name in any one of the table, for the KPI ...

• How can the error Index out of bound exception be solved for a view in the KPI?

  This problem can occur if level name and attribute name are same. Please check if same column is used across the DB model and provide unique name for level name and attribute in the DB model. This should solve the issue.

• The KPI doesnot execute and throws the error - 'java.lang.Exception: Query Execution Failed ! :Ambiguous column name' in the log

  If a particular measure is present in both Aggregate table(E.g. AGG_WLY_STR_DEPT_Details) as well as DIM table (E.g. DIM_STORE), then the KPI query returns ambiguous column error. In such cases, change the column name either in DIM table or in the ...

• Why do I get an error while exporting a KPI report to Excel with large number of values selected in a filter?

  When a KPI involving large number of values selected in a filter is exported to Excel, the excel file is will not be generated as desired. The reason being: A single cell in MS Excel accepts upto 32,767 characters and within a single cell, it will ...

• The KPI does not execute and throws the error - 'java.lang.Exception: Query Execution Failed! : Ambiguous column name' in the log. How can the issue be solved?

  If a particular measure is present in Aggregate table (E.g. AGG_WLY_STR_DEPT_Details) as well as DIM table (E.g. DIM_STORE), then the KPI query returns ambiguous column error. In such cases, change the column name either in DIM table or in the ...