MS SQL Server OLAP - Process cube when a new data is entered?

Author

Process cube when a new data is entered?

necati@cbksoft

2006-03-30, 3:26 am

Hi,
As a newbie of analysis services, i am trying to go through Analysis
Services Tutorials in AS 2000. It is said that we can refresh the values in
our cubes by DTS by scheduling it to any time.

However, i am curious if i can process my cubes just after a new data is
entered. By this way, i can reach the instant values. I know thats not so
logical but i might try to apply it to small cubes especially. Do you have
any idea?

Thanks
Necati
--
Necati Sekkeli
CBKSoft
Junior Software Developer

Talheedin

2006-03-30, 7:32 am

Hi Necati,

You could try using the DTSRun utility in the trigger of the updated
SQL table. This will run your DTS package whenever the trigger
conditions are met. Look up DTSRun Utility in Transact SQL Help.
However be very careful with this as if the table is updated too often
you will find that your cube is contsantly building and it may cause
problems if the trigger is trying to rebuild a cube while it is already
being rebuilt.

Let me know how you get on

Talheedin

Sponsored Links