Why are the defined column names not considered in the inner query when I create a manual KPI?

• Related Articles

• How can I create an additional hierarchy for tree view manual KPI?

  Perform the following steps to create an additional hierarchy for Tree View Manual KPI: 1. Create a new hierarchy in 'ADMIN_TREE_HIERARCHY' table 2. Create hierarchy levels for the newly created hierarchy in 'ADMIN_TREE_HIERARCHY_LEVELS' table 3. ...

• One of the column names in the KPI grid is incorrect? It is not the column Name being displayed?

  One of the possible scenarios: ------------------------------------------ All the measures must be mapped to the same db column. The measures are picked up based upon the first created measure ID.

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

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

• How can I create a Private KPI?

  KPIs can be made private or public while creating them. Perform the following steps to make the KPI as Private/Public: 1. Login to Analyst Module. 2. Navigate to KPI Publisher module to create a KPI. 3. While publishing the KPI, for Visibility ...