Why does the KPI working fine in Administrator module produce an Invalid error in Analyst module?

• Related Articles

• Why is the KPI not displayed in Analyst, whereas it is visible in the Administrator module under a specific KPI group?

  This problem can occur if the sequence number of more than one KPI groups are same. In this case, the KPI may not get displayed under the correct KPI group in Analyst module. Modify the KPI Group sequence and ensure that it carries a unique number. ...

• Getting Invalid KPI definition error while trying to access KPI.

  This issue can be due to large browser cache. Clear the browser cache and the issue should be fixed. If the problem persists, re-publish the KPI. If you require further help, please contact the support team.

• Parameter not working fine.

  In "admin_db2_warehouse.xml", for the queryid "WWCAL14", we need to change the database name as highlighted below: SELECT (SELECT MONTH_IN_YEAR FROM DIM_DATE WHERE DATE_FLD = ?) - (SELECT MONTH_IN_YEAR FROM DIM_DATE WHERE DATE_FLD = ? ) AS MONTH_DIFF ...

• Why is Aggregate Selection option not available in KPI Publisher while doing KPI modification in Analyst module?

  Force Aggregate table selection is only available from the Administrator module and not in the Analyst module. So, users with administrative privileges can login to Administrator module and make the intended changes to the KPI.

• I cannot disable all modules/KPIs from Analyst module using the KPI Module/Group Security at Role level (Store Manager). How to fix it?

  In order to apply KPI Module/Group level security, ensure that nothing is assigned at the USER level and also at the DEPARTMENT level (If a 3-level security of Department -> Role -> User is implemented).