Symptom
When Auto Refresh is turned on in Data Analyzer, data entered via a story based on a planning model is not automatically displayed in Data Analyzer.
Environment
- SAC Data Analyzer
Reproducing the Issue
- Create an input story based on a planning model and set the context to a particular data region.
- In a different browser window or browser tab create a dashboard in Data Analyzer and set the context to same data region configured in the story created at the previous step.
- Turn on Auto Refresh in the Data Analyzer dashboard created above.
- Input data in the story created above.
- Switch to the browser tab containing the Data Analyzer dashboard.
- Notice the data that was just entered in the story is not displayed the Data Analyzer dashboard even though the Auto Refresh is turned on.
- Refresh the Data Analyzer via the browser Refresh button or via the F5 key.
- Notice the data that was entered in the story is now displayed the Data Analyzer dashboard.
Cause
With Auto Refresh turned on for Data Analyzer it means every data related action in Data Analyzer will result in a request for data to the backend to get an updated result set for the Table in Data Analyzer.
If Auto Refresh is turned off then data related actions in Data Analyzer (like adding a dimension to rows or columns or removing a measure that was previously selected) will not trigger requests to be sent to the backend and the table is not updated.
The reason for this is because Data Analyzer is an ad-hoc analysis tool where an end user might initially be adding a number of measures/dimensions to the table and do not want requests fired off. They add all the dimensions/measures they want and then turn back on "Auto Refresh" to get a new resultset for the table with all measures/dimensions they have selected.
Resolution
This works as intended.
The Auto Refresh functionality of the Data Analyzer does not automatically monitor the data changes in the backend.
Therefore, data changes in the back end will not be automatically displayed in the Data Analyzer unless the user manually refreshes the page in the browser.
Keywords
KBA , LOD-ANA-DAN , SAC Data Analyzer , Problem