Page 1 of 1
Can't view cube data during executeprocess?
Posted: Thu Jan 10, 2013 11:37 am
by macsir
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?
Re: Can't view cube data during executeprocess?
Posted: Thu Jan 10, 2013 2:48 pm
by jim wood
If you are updating and dimension or subset then the service will lock as you are making meta data changes.
Re: Can't view cube data during executeprocess?
Posted: Thu Jan 10, 2013 9:59 pm
by macsir
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.
Re: Can't view cube data during executeprocess?
Posted: Thu Jan 10, 2013 10:24 pm
by jim wood
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.
Re: Can't view cube data during executeprocess?
Posted: Thu Jan 10, 2013 10:29 pm
by macsir
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.
Re: Can't view cube data during executeprocess?
Posted: Thu Jan 10, 2013 10:35 pm
by macsir
It looks like the data will be commited to all cubes until the whole Process A finishes instead of just one child process.
Re: Can't view cube data during executeprocess?
Posted: Fri Jan 11, 2013 12:53 am
by macsir
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.

Re: Can't view cube data during executeprocess?
Posted: Fri Jan 11, 2013 12:55 am
by macsir
So it is not relevant to metadata changes for this case.