Shiva_V28


1. Created CUBE using SSAS 2005 (Analysis services)

2. Deployed and processed the CUBE which is working fine, the data is browsed and the measure values are coming fine.

3. Suddently after a while (after some HRS) the Data for the measure values are coming as NULL.

4. The new CUBE built out of same Datasource (.ds) and structure (.dsv) getting the data and working fine.

Any help to resolve this of great help.




Re: Data not displayed in CUBE

Darren Gosbell


At a guess I would say that there are one or more of the dimensions that are common to both cubes and that you have done a full process on one of them. Full processing a dimension will cause all dependant cubes to become unprocessed. Doing a process update on the dimension will not invalidate dependant objects.







Re: Data not displayed in CUBE

Shiva_V28

The scenario here is different, we have only one CUBE, which is working fine till a certain time and goes off after that. We not even processed the CUBE, even then the issue comes.






Re: Data not displayed in CUBE

AkshayBM

Shiva_V28 wrote:

The scenario here is different, we have only one CUBE, which is working fine till a certain time and goes off after that. We not even processed the CUBE, even then the issue comes.

Could it perhaps be the mode that the Cube is set in MOLAP, ROLAP, etc. I believe you can set it to auto-requery after a set amount of time and it's possible that this is unprocessing your cube Just a guess here.

The only other thing that's unprocessed my cubes is when you do a Process Full on any dimension that's linked to the Cube in question.