This content has been marked as final. Show 4 replies
This question was answered back in October.1 person found this helpful
Changing cost-based precompute % programatically
Whatever you do in AWM, just find the xml tags for it and use it in DBMS_CUBE.IMPORT_XML command.
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)