Hello!

Is it possible to automaticly process the cube with new data available? Can
I schedule this somewhere, where to look for this?
At this time, I would have to make the full-process of Cube and all the
shared dimensions, later I will do only update-process. Any hints on where
to look for this, if it is possible.

Thank you and kind regards,
Dejan

have you looked at the new proactive caching features available with AS
2005? Depending on the settings, a cube can automatically incorporate
new data as it arrives:

http://www.microsoft.com/technet/pro.../rtbissas.mspx
Real-time Business Intelligence Using Analysis Services

Published: April 1, 2005
By Paul Sanders

This paper covers features in SQL Server 2005 Analysis Services that
overcome many of the barriers to gathering and analyzing real-time
business intelligence data faced by companies today.
...
• Updating the Analysis Services cube incrementally. As in Analysis
Services 2000, it is possible to reduce the time required to refresh the
Analysis Services cube through the use of partitions, where the impact
of updates can be limited so that only a small part of the cube is
actually affected. In addition, it is possible to process a cube
incrementally so that new fact rows can be added to the existing cache.
Analysis Services 2005 builds on this by also allowing the incremental
update of dimensions, catering for the case where new dimensions records
are only added, and never updated.

• Defining caching policies. Analysis Services 2005 introduces the
ability to define how the cube should be refreshed to reflect changes to
the source data. These proactive caching policies allow the business
demands for up-to-date data to be balanced against the need for high
performance.
...

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***

In article <eb4Smu1yFHA.3812 (AT) TK2MSFTNGP09 (DOT) phx.gbl>,
deepak_puri (AT) progressive (DOT) com says...
You can also do incremental processing on an AS2k cube, but you have to
do more manual steps to help the cube identify new data. Looking up
incremental processing in BOL should point you in the right direction.

But if you can wait for AS 2005 it would be worth it, the proactive
caching feature rocks!

--
Regards
Darren Gosbell [MCSD]
<dgosbell_at_yahoo_dot_com>
Blog: http://www.geekswithblogs.net/darrengosbell