I have a cube for which I have defined pre-compute percent as 50(for bottom partition). I loaded data into a partition. Now I want to change pre-compute percent to 35 and load data into another partition. Can I do that without dropping and recreating the cube? . Can I change this parameter dynamically at any point?
Olap Version: 184.108.40.206.4
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: 220.127.116.11.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)