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.
Related Articles
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 ...
The KPI doesnot execute when drilled-down from 'Quarter' to 'Month'. It throws the error - 'java.lang.Exception: Query Execution Failed! : Invalid column name '#DATE_KEY#' in the log. How can the issue be solved?
If the 'orderByDes' column for MONTH and WEEK level in TIME Dimension in 'dbmodel.xml' file is specified as 'orderByDes="#DATE_KEY#" then, the KPI will fail. In such cases, ensure that the 'orderByDes' column of the individual levels are specified as ...
Can a non-admin user view the exception highlight set for a KPI by an admin?
Yes, but conditions apply: 1. If a non-admin user has not set any exception highlights for a KPI, he can view the one set by admin for that particular KPI. 2. If a non-admin user has set an exception highlight for a KPI, he can view only that as it ...
KPI : Item Price Variance - exception : Error ocurred while creating the report - please retry
BCM Configuration related issues are out of scope for ARC Support. This should be reported to Deployment Team.
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 ...