Why is Sales and Productivity KPI getting data from a Gregorian aggregate?
When a KPI is analyzed, the aggregate table is picked up based on the least sequence number defined in the dbmodel.xml. For the KPI "Sales and Prdocutivity"; it is hitting to AGG_MLY_STR_AREA_GRE_DC Aggregate table instead of AGG_MLY_STR_AREA_DC_SC because of the Dimension Usage for both the Aggregate tables defined are same. Also the sequence number given for AGG_MLY_STR_AREA_GRE_DC is least than AGG_MLY_STR_AREA_DC_SC. Hence in order to hit the right Aggregate Table; provide the unique Dimension Usage across the Aggregates in dbmodel. If you require further help, contact the support team.
Related Articles
Why am I getting unexpected results from weekly firm data viewer KPI?
The Issue here is the column_name with which the measure 'C4182' was created is not mapped to any of the levels in the db2_dbmodel.xml file. This is a pre-requisite for any measure to function properly. Map the column_name to the appropriate level in ...
In a KPI sy sales returns by store dashboard, why does the tabular format data does not get refreshed after we change the filter?
this may be due to improper IE settings at the client side 1) Changed the cache setting. In internet explorer, the following setting has to be done: Internet Options -->General Tab --> Settings (Browsing History) --> Every Time I Visit the web page. ...
After Publishing the KPI with Calendar(Business/Gregorian) its not referring the correct Aggregates. How to fix this?
This issue occurs if the Graph linked to the KPI does not have calendar filter. So even if the KPI with Calendar Filter hits to proper respective Calendar Aggregate Table, after analyzing KPI, its hits the Standard Aggregate Table. To fix this issue, ...
Which are the data getting migrated when ARC is upgraded?
The list of tables given below are migrated when ARC is upgraded: ADMIN_CHART_COMP, ADMIN_COLDETAILTABLE, ADMIN_DATASET, ADMIN_FILTER_COMBINATION, ADMIN_FILTER_DBCOLUMNSET, ADMIN_FILTER_DEFINITION, ADMIN_FILTER_GROUPS, ADMIN_GROUP_COLUMN, ...
'Sales Discount' KPI shows an exception as, 'Invalid KPI'. Why?
The KPI's definition must have got altered. There will be an issue with the metadata related to the KPI like Measures/Dimensions. You can alternatively check for the KPI validity from Administrator --> KPI Management and verify ...