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?