Wednesday, March 7, 2012

Automate Cube Processing

Hello,
Can some one tell me how i could automatically
refresh the cube when the DW is updated, I know its
possible through DTS, can someone refer me to a site which
gives step by step details on how i could accompalish this?
Regards
ImranYou need to have analysis services installed on the machine that you will
run the DTS package from, there is a task called process cube that you can
then schedule
Ray Higdon MCSE, MCDBA, CCNA
--
"Imran" <anonymous@.discussions.microsoft.com> wrote in message
news:c78a01c40fcc$c8bef7c0$a001280a@.phx.gbl...
> Hello,
> Can some one tell me how i could automatically
> refresh the cube when the DW is updated, I know its
> possible through DTS, can someone refer me to a site which
> gives step by step details on how i could accompalish this?
> Regards
> Imran

No comments:

Post a Comment