Facing Strange issue

孤云清云

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

酥糖公子

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?

小蚂蚱

Hi declanr,

Thanks for the reply.

As far i know,we didnot restarted the server recently.
We enabled the logging in the below path:
CubesSecurity AssignmentsLogging checkbox enabled.
Still we dont have any clue.

Regards,
Sathish

chenbaolei

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.