we have a aggregated ASO cube and i want to do partial clear and then load data to the same intersection. This cube is aggregated cube.
i Have below questions regarding it
partial clear will take more time?
do i need to clear all aggregation and then perform the partial clear?
How to aggregate only the updated intersection if i can do partial clear on aggregated cube and then load data to it?
What is the use of Query Hints in ASO aggregation?
Partial clear takes more time than full clear.
You do not have to clear agg views but Partial Clear takes time if aggregate views are present.
You can try slices but I am not sure if it works that nicely performance wise specially when agg views are present.
Query hints are used for building aggregate views.
You can refer to dbag to get more idea about loading to slices and Query hints.
Thanks for the reply..
my main motive is to reload same refreshed data for same intersection with less downtime..
if i will clear aggregation then do partial clear followed by data load and aggregation then it will be take more time(not sure ..i am assuming it as aggregation take more time)
just want to clear data set with aggregated view and load data to that intersection and aggregate that slice...
looking for best approach or if any one as actually did tried that
Lets say Jan->FY12->Actual->ITdepartment needs to cleared and reloaded with new set of data in cube which has aggregated view.
i am thinking this can be done without clearing aggregation but i dont know if i can reaggregate the new slice of data
step 1) physical partial clear without clearing aggregation
step 2) reload new refresh data for same intersection with aggregation
step 3) how to reaggregate the new slice of data?
is it the right approach ?
will this be faster than clearing aggregation and then loading the slice of data?