I have an analytical workspace where i have modelled a set of conformed dimensions and some dimensions specific to specific subject areas. There will be multiple cubes (Partitioned and some non partitioned) in this analytical workspace.
Would like to know if these cubes can be refreshed in parallel. I have tried using DBMS_CUBE provided parallelism parameter and kicked off 2 cubes refresh but when i check the cube_build_log, the slave process is always 0 and the execution seems to have happened in serial.
Please suggest how these cubes can be refreshed in parallel.
Thanks Nazar for your reply.
I used the sample cube based MV related app provided by oracle on my local machine. Here is what i executed as my latest attempt and it finally failed.
'S', -- solve
true, -- refresh after errors
10, -- parallelism
false, -- atomic refresh
true, -- automatic order
true, -- add dimensions
'IncrMyCBMV'-- identify job
I am not able to attach the CUBE_BUILD_LOG here for this run. Is there an alternate way I can upload it.