simultaneous read and write to a cube - critical issue

[Former Member]

Hello xperts,

I am facing a critical issue.

I have Cube A which has loads of data in it. I need to take the data of CubeA to a new CubeB as a backup purpose.This activity will take a lot of time.

Concern1 - In the night we have the master data job which runs including the attribute change run job. Will this have any effect on the load happening from Cube A to Cube B.

Concern 2 - After master data job finishes in the system , we then run the transaction data jobs which would update Cube A with the delta data. Now the issue is can this delta load happen to Cube A while there is data load going on from Cube A to Cube B??

Please help me out with this ASAP.

Thanks & Regards

Rohit

[former_member184494 · Accepted solution]

Rohit,

Attribute change runs will get affected only when you drop or rebuild the indices - this activity locks the cube - any activity that locks the cube will affect attribute change run - reads on a cube will not lock the cube.

However when you are loading data into your new cube - you cannot load data into the cube - for the very fact that when you load data into the cube - you will drop indices - this will affect the data load into the new cube.

Arun