KPI definition created properly but still shows 'Null Pointer Exception'. What could be the reason?

• Related Articles

• Though I created KPI definition properly, it shows 'Null Pointer Exception'. Why?

  Ensure that the hierarchy names are unique across the dbmodel.

• 'Sales Discount' KPI shows an exception as, 'Invalid KPI'. Why?

  The KPI's definition must have got altered. There will be an issue with the metadata related to the KPI like Measures/Dimensions. You can alternatively check for the KPI validity from Administrator --> KPI Management and verify ...

• Cannot drag newly created dimension while publishing a KPI. What could be the reason?

  One of the possible reasons could be: The dimension might have been created but the dimension wouldn't have been linked to the corresponding aggregate tables. Hence the relevant message pops up. Please ensure that you link the dimension to a required ...

• The KPI is throwing an exception as 'null'. It used to work fine previously.

  There might have been a change in the data model at the backend which might have impacted the KPI configuration (measures and dimensions used). One of the possible causes is as below: When the column name is same across different/same dimension in ...

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