Skip to Content
0
Mar 26, 2009 at 09:26 AM

Creating aggregate based on plan cube

27 Views

Hi,

For the standard baisc cube, we can use the aggregate to improve the query performacne.

and when the new request comes, it will be ready for reading only after this request is rolled up to aggregate.

Now I create a aggregate and do the initialzation fill-up for this aggregate, all the requests with green status have been rolled up to the aggregate. There is no any problem.

but I get one quesion here, for the most updated request, it is usally with yellow status because this cube is ready for input. and this yellow request can not be rolled up to aggregate until it is turned to green. But from our testing, the query can read the required data from both the aggregate and this yellow request. that's to say, it seems the query based on this plan cube can summarize the data from both the aggregate and this yellow request.

Is there anyone can confirm our testing is correct and it is the specific property of the plan cube?

Many Thanks

Jonathan