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?
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)