How can I add a 'WHERE' clause in a manual KPI?

• Related Articles

• The new filter for manual KPI is not working

  The default value for the filter must have been 'ALL' instead of number. So, change the default value to number in 'ADMIN_FILTER_DEFINITION' table in the admin database.

• Unable to add Measures while publishing the KPI. Why?

  The measures you are trying to add might have no corresponding dimensions existing in the application. Please add the dimensions for those measures & then try to add measures from the front end.

• The KPI isn't producing results 'ordering by'. It also does not append the 'order by clause' to the KPI query

  Include 'orderBy="asc" condition in the dimension level if you want to order by the default column specified for the level. If you want to order by any other column apart from the default column then, include both ''orderBy="asc" and 'orderByDes' = ...

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

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

  Use the column names without spaces in the inner query. For example, ('Monthly Target' should be Monthly_Target and 'Extd Price LY' should be Extd_Price_LY).