Hello,

when I parameter the
storage of a cube, I
say I want a 35% of
performance. I do
it once .
My question is :
how does AS to
manage this storage
when I process the
cube
with new data. Does
it add new
agreagation during
the processing phase
?
Or do I need to
re-parameter the
storage manually ?

Thanks
eko

Hi eko,

Thanks for your posting!

From your descriptions, I understood that you would like to know whether
aggregation will be recaculated when new data was inserted. Have I
understood you? Correct me if I was wrong.

Based on my scope, it depends on whether you make full process after the
data was inserted. If so, the aggregation will definitely recaculated,
otherwise, it won't.

Thank you for your patience and corporation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!


Sincerely yours,

Michael Cheng

Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---------------------------------------------------------------
Get Secure! - http://www.microsoft.com/security

This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!

Ok thank you.
It means that if I process the cube incrementaly,
I will need to re-create the storage of agregatations ?
If it is, does it exist a way to automatize this process ?

Thanks
eko

Hi eko,

Thanks for the prompt updates.

First of all, let me clarify my previous psot, assuming there are 7,000
records now and the aggregation is set to 35% so that 2450 records will be
calculated. Newly inserted 5000 records will also be calculate as 5000 *
35% = 1750 records, HOWEVER, it won't be calculating (7000 + 5000) *35%.
Newly inserted ones will be calculated separately instead of as calculating
the whole data.

Secondly, this behavior is handled by SQL Server internal so that we are
not able to make it recalculating when process incrementally. In my view, I
don't think it is necessary for you to recalculate it yourself, which will
only make a little improvement. Just trust SQL Server itself handle this
performance issue.

Thank you for your patience and corporation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!


Sincerely yours,

Michael Cheng

Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---------------------------------------------------------------
Get Secure! - http://www.microsoft.com/security

This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!