This content has been marked as final. Show 4 replies
I think we can do that directly from AWM. I already did it but just wanted to make sure it would not cause any issues with already precomputed data when I change the parameter.
When I change the parameter will it invalidate any other objects? Do I need to recompute all the data again?
AWM Version: 126.96.36.199.0A
Changing the precompute level modifies the AGGMAP, and this in turn requires the data in the cube to be re-aggregated. You don't have to reload anything and other objects shouldn't need to be touched. This should do the trick (with suitable changes for MY_CUBE and X).
exec dbms_cube.build('MY_CUBE USING (CLEAR AGGREGATES, SOLVE)', parallelism=>X, add_dimensions=>false)