Changing cost-based precompute % programatically
Hi Experts,
I'm trying to do some tests on how the OLAP cubes scale in size. I have a fact table with 7 days of data ( 20.87M rows) and two dimensions: time and location.
My plan is to get statistics from 7 and 14 days and 2 different aggregation levels by:
1.- Build the cube with precompute 20% (on both top and bottom)
2.- Check LOB sizes both in USER_SEGMENTS and the AW$XXX_AW table
3.- Change precompute to 40%
4.- Cube Complete refresh
5.- (2)
6.- Add 7 more days of data to the fact table
7.- (4)
8.- (2)
9.- Change precompute to 20%
11.- (4)
12.- (2)
The main problem is that this process will take a very long time, so I'd like to leave it running overnight (and not having to change the aggregation level manually using the AWM). To do this I need a way to change the cost-based aggregation precompute level within a SQL or PL/SQL script. Is this possible?
Thank you,
Joan