All sales report should have "last x filter". How do I change the configuration of the KPI?
To enable the 'Last x Period' filter for the KPIs, the user should be entitled (privilege granted as part of user security) to use 'Modify Analysis' feature through which the last x period filter can be chosen and KPI can be re-published.
Related Articles
How do I enable Last x filter for a KPI?
To enable Last x filter for a KPI, select the KPI form its respective module and select Modify Analysis from the KPI utilities. KPI publisher screen will be displayed. In the Filters Applied section of the screen, select the Time filter drop down ...
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. ...
Last X period filter is not working properly. How can I rectify it?
Verify and alter the LASTX WEEKS,LASTX MONTHS,LASTX QUARTERS & LASTXDAYS queries in the 'admin_oracle_warehouse.xml' accordingly to rectify the problem. For example: wdifT = (eWeekNoTY - sWeekNoTY) + 1. Where: sWeekNoTY = ("WEEK_NUMBER_THIS_YEAR")); ...
Store filter selction shows 50 records but after analyzing the KPI, the report generates only 36 records
The KPI usually shows up only active stores and the missing stores might be inactive stores. Hence, these donot show up while analyzing the KPI. The KPI query can be cross-verified by executing the query in the db
Why can't I export a KPI report to Excel when large number of values are selected in a filter?
Excel file will not be generated as desired and an error message may get displayed when a KPI with large data is exported to a excel file. This is due to a limitation in MS Excel. A single cell in MS Excel accepts upto 32,767 characters, which are ...