IT Analytics: After processing cubes, some data are not up to date.
Article ID: 165043
Updated On:
Products
IT Analytics
Cause
By Microsoft Analysis Service SSAS design, upon processing a cube, only (Measures Groups) will be processed, unless a linked dimension is marked not processed. Which means, first time of cube processing, linked dimensions will be processed as well, later processing will onlu process cubes's Measures Groups.
Resolution
Microsoft recommends processing dimesnsion on structure or data changes.
To get the data in SSAS DB updates, process the deminesions linked to affected cubes.
Alternatively, you can right-click on SSAS ITA DB, and click process, to process all objects, keep in mind the performance impact.
If you have data which changes periodically, dimesnsions processing can be scheduled via MS SQL Agent, for more information about scheduling SSAS queries reffer to https://docs.microsoft.com/en-us/sql/analysis-services/instances/schedule-ssas-administrative-tasks-with-sql-server-agent
To get the data in SSAS DB updates, process the deminesions linked to affected cubes.
Alternatively, you can right-click on SSAS ITA DB, and click process, to process all objects, keep in mind the performance impact.
If you have data which changes periodically, dimesnsions processing can be scheduled via MS SQL Agent, for more information about scheduling SSAS queries reffer to https://docs.microsoft.com/en-us/sql/analysis-services/instances/schedule-ssas-administrative-tasks-with-sql-server-agent
Feedback
Yes
No
Powered by
