How to schedule AS2005 Cube process

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

fefe78 - 26 Jun 2008 08:52 GMT

Hi,

How can I schedule an automatic process of a cube? Is there a way using
Microsoft Management Studio or Business Intelligence?

Someone could give me a link of how to run a cube process from code
(asp.net)?

Thanks.

Bye

Reply to this Message

ChrisHarrington - 01 Jul 2008 04:45 GMT

My solution is to use ascmd and SQL scheduled job. No custom code needed.

> Hi,
>
[quoted text clipped - 7 lines]
>
> Bye

Reply to this Message

Julian Kooiker - 02 Jul 2008 08:58 GMT

It's very easy to do, because you start the processing you want is
sqlmanagement studio, change the settings to how you want it to
process and then there is a button in the window (I forgot the name)
to see the XML code that is executed to the analysis services when you
want to process the cube.
Copy this code to the clipboard (CTRL-C)

Then create a new job in the sql agent (Also in management studio).
Create a step of type Analysis Services Command. Paste the code (CTRL-
V) of the clipboard. Fill in the rest of the job, like when to run
etc.

Sorry I can't be more specific, but I don't have an application open
right now. But this should help you.

Julian Kooiker
Business Intelligence Solution Architect @ HGH.nl

On Jul 1, 5:45 am, "ChrisHarrington" <charrington-at-
activeinterface.com> wrote:

> My solution is to use ascmd and SQL scheduled job. No custom code needed.
>
[quoted text clipped - 11 lines]
>
> - Show quoted text -

Reply to this Message