Page 1 of 1

Facing Strange issue

Posted: Mon Aug 13, 2012 10:57 am
by sathishh.mk
Hi All,

we are facing strange issue.

we have Data quarterwise in the cube, as my time dimension has Quarters like 2012 Q1,2012 Q2.
we are loading successfully data into the cube respective quarters and locking down.
when we checked after some days data is not available in the cube for respective Quarters.
Wa are unbale to trace the problem.
We are not scheduled anything like "viewzeroout or cubecleardata" etc..

Please suggest wat might be the reason behind this and how we can trace the issue?

Thanks in Adavance !!

Regards,
Sathish

Re: Facing Strange issue

Posted: Mon Aug 13, 2012 11:13 am
by declanr
Have you ran a transaction log to see if anyone is changing data (if you have logging enabled)?

Also has the server been restarted? And If so do you have a SaveDataAll scheduled?

Re: Facing Strange issue

Posted: Mon Aug 13, 2012 11:18 am
by sathishh.mk
Hi declanr,

Thanks for the reply.

As far i know,we didnot restarted the server recently.
We enabled the logging in the below path:
Cubes\Security Assignments\Logging checkbox enabled.
Still we dont have any clue.

Regards,
Sathish

Re: Facing Strange issue

Posted: Tue Aug 14, 2012 1:58 am
by Christopher Kernahan
You would do well to explore the suggestions made by declanr.

Confirm that the data is being saved to disk
Confirm whether or not the server is being restarted before this occurs
Check the system log to confirm whether any other processes are running which may affect this cube
Check the transaction logs to see what is modifying this data.

Until you can give confidence you've completed through these steps there's not much more anyone can offer you.