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

• Related Articles

• Sales Discount is showing invalid.

  Re-Define the dimension 'Cluster' in the db model 'db2_dbmodel.xml'

• When drilled down from 'Quarter' to 'Month', KPI shows the error - 'java.lang.Exception: Query Execution Failed ! :Invalid column name #DATE_KEY#'. Why?

  It happens when the 'OrderByDes' column for MONTH and WEEK levels of TIME dimension is specified as 'OrderByDes="#DATE_KEY#", in the dbmodel.xml file. Modify that to 'OrderByDes="DATE_KEY". Note: This is advanced configuration and affect whole ...

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

  Ensure that the hierarchy names are unique across the dbmodel.

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

  One of the possible reasons for this is hierarchy names of the particular dimension used in the KPI might be same. Also, get the KPI's meta data reviewed by the ARC Administrator. For further information, contact Product Support 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 ...