If we drill down from 'Year' to 'Week' level in the KPI, it throws an exception. What could be the reason?

• Related Articles

• Error comes when I drill from Year to Week level. Why?

  This problem can occur if the same view is used as a cross tab column. Please try using different dimensions for the cross tab view.

• Why do I get errors if I drill from Year to Week level?

  This problem can occur, if the same view is used as a cross tab column. So use different dimensions for cross tab view.

• KPI produces an error when drilled down from one level to another. What could be the reason?

  Most often, drilling down from one level to another level poses problems due to incorrect data type of the measures used in the KPI. Check for the data type of the measures and correct them accordingly in the 'dbmodel.xml' file.

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

• 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