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

• Related Articles

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

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

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

• For Store Hierarchy filter, dimension tree is not shown for highest level. How can I fix this?

  This problem can occur if there are Null values in the DIM_STORE. Eliminate the Null values to resolve the issue.

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

  1. Create a manual KPI without 'WHERE' clause. 2. Go to the XML file of the corresponding manual KPI and add the 'WHERE' clause. For example, --