how to process a cube from T-SQL

[vanoordt]

Hello!

I wonder how I can process an OLAP cube from T-SQL. You would expect there to be either some predefined (extended) stored procedures, or at least command line calls that can be used within xp_cmdshell. I can find neither in BOL. Anybody knows how to do this?

Currently I am calling dtsrun from xp_cmdshell, but I would like to skip the DTS packages and do everything with a single generic procedure.

Thanks for your comments! regards,
Paul

 

[astra1]

Hi,

I am not sure I understood you currently. What are the kind of OLAP tool you are using? If it is Cognos then I may help you out.

Vish

 

[vanoordt]

Microsoft Analysis Services

regards,
Paul

 

[IMAGINAX]

Not really an answer but maybe a workaround...

There's an add-in for VB6 that allows you to write an app that processes your cubes. You could customise this to process whatever cube is specified in the command line and then call it in the same manner.

Of course if you're having to do this then you might as well use DTS... ah well.

Mike

 

[vanoordt]

This might be an answer... If it can be done from VB, it can probably be done from other languages as well. Still it will be a lot more complicated that the few-parameter call I had in mind.
Thanks.

regards,
Paul