Can't view cube data during executeprocess?

kangbei

e.g. Process A is using excuteprocess to invoke some other child processes, such as p1 will refresh cube1, p2 will refresh cube2 and p3 will refresh cube3.
When p1 finishes executing and Process A is still executing p3, can I view the data in cube1? It looks like the data has NOT been commited to cube1 and cube1 is still empty.
Anyone has any opinion?

sysease

If you are updating and dimension or subset then the service will lock as you are making meta data changes.

碧·染

Yes, P3 will update dim or refresh data in the cube3. But Since cube1 is already done with any updating, I assume I can check the data in cube1 before the whole Proccess A finishes? BTW, I can open the cube1 in another machine while Process A is running P3.

bxmsw

Any meta data change locks the service not a cube. So yes you can change data before the process runs but not once it has started. When running a chore the service is locked until the chore finishes so you can't check any cube.

tianya369

thanks for quick reply.
Actually, Process A is just a parent process instead of a chore. In fact, the cube1 is still empty when the process A is running P3, while P1 has already been finished. That's why I have this question.

315196952

It looks like the data will be commited to all cubes until the whole Process A finishes instead of just one child process.

itoto

Glad to post some testing results here.

Parent P process has two child processes p1 and p2. And p1 is just refreshing data in cube1 and p2 is just refreshing data in cube2. They don't update any metadata in both cubes.
Untill the P process finishes, I can see the data changes in cube1. That means by using executeprocess method, the data for all cubes would be committed until the parent process finishes. You can't view any changes in the child cubes while parent process is still running even if you can open those cubes from another machine. That is my conclusion.

juese72

So it is not relevant to metadata changes for this case.