Data dissapers in SSAS Cube Dimension

Category: sql server analysisservices


Aryedu on Thu, 20 Oct 2016 11:09:55


I have a cube with a role in which users have access to the values of a dimension with mdx are assigned. The point is that works well for all users, but at a certain time (failed to establish a time sequence or facts) the dimension data disappear and you have to reprocess the cube. With process it from the server is ok, no-touch design for nothing



Simon_Hou on Sun, 23 Oct 2016 17:14:16

Hi Aryedu,

In this scenario, since this data disappearance only occurs at a certain time, I guess the issue is caused by some processing command executed on this cube which makes the dimension data can't be queried. I suggest you check the Last Process Time of this Cube. If this time is later than when "data disappearance" occurred, please check if some Agent Job or XMLA scripts executed at that time.


Aryedu on Mon, 24 Oct 2016 07:26:12

Hi Simon, thanks for the answer.
The fault occurs several times a day, process the cube from the server and an undetermined time after the dimension data to one or more users (not all) will disappear. I go back to process and already appear. By the middle of these two processes the cube is not touched. Any other ideas ???


Darren Gosbell on Tue, 25 Oct 2016 02:13:33

What version/build of SSAS are you using?

I have not seen this exact issue, but I may have seen something similar in SSAS 2012 SP1. In our case it was caused by a bad cache hit. One side effect of re-processing is that any caches will get flushed. To test if this is an issue, the next time you see the data dissappear try just running a clear cache command (see If that fixes the issue you should see if you can update to the latest cumulative update (this fixed our issue) or contact Microsoft Support.

Simon_Hou on Tue, 25 Oct 2016 06:42:41

Hi Aryedu,

You may enable FlightRecorder trace or directly use SQL Profiler to monitor the executed command on SSAS server.

You can check it under log folder, (e.g.C:\Program Files\Microsoft SQL Server\MSAS10.MSSQLSERVER\OLAP\Log)


Aryedu on Wed, 26 Oct 2016 14:37:06

Thanks for the response

I'm using SSAS 2008