After processing cubes, some data are not up to date, when comparing the data in the source DB with the once in reports or cubes browser.
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.
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
Subscribing will provide email updates when this Article is updated. Login is required.