Process a cube through command?

Question

Post reply

Process a cube through command?

Del Piero

SSCrazy

Points: 2265
More actions
July 21, 2005 at 12:31 am

#110339

Hi all,
Is it possible to re-process a cube (refresh mode) using command line instead of using Analysis Manager?
What I want to do is to use a T-SQL stored procedure to query the cube, but before querying I would like to re-process the cube to make the underlying fact table updated. The underlying fact table is dynamically loaded with data according to some parameters used ar arguments in the stored procedure.
Thanks,
delpiero

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Jonathan Stokes SSCrazy Eights Points: 9861 More actions · Answer 1

Why not use the functionality in dts. You can call that from t/sql via xp_cmdshell

------------------------------
The Users are always right - when I'm not wrong!

Del Piero SSCrazy Points: 2265 More actions · Answer 2

Do u mean refresh the cube through DTS and then call the DTS package through xp_cmdshell? But can you tell me how to refresh the cube through DTS?

Thanks,

delpiero

Del Piero SSCrazy Points: 2265 More actions · Answer 3

I can use DTS Export/Import wizard to choose a SQL Server table as source, and an OLAP Analysis Services cube as destination, but it does not allow me to export the data, saying something like "No such interface supported" .......

delpiero

Tiago Rente Default port Points: 1403 More actions · Answer 4

You need to use the "Analysis Services Processing Task" (is the cube icon on the task section).

For more information search "Analysis Services Processing Task" in Books Online.

Tiago Rente Default port Points: 1403 More actions · Answer 5

The only task you need in the DTS is the one to re-process the cube in "refresh mode", because everything else must be done in the SP. I.e., in the SP before quering the cube use the xp_cmdshell to execute the DTS.

Del Piero SSCrazy Points: 2265 More actions · Answer 6

Thanks Jonathan and Tiago, I have got the solution from your advice.

Just one more issue, I granted execute privilege of my T-SQL stored proc to the APP_USER database user who is the user by which the application connects. This user has no execute privilege on the xp_cmdshell extended stored procedure.

How can I grant the execute privilege of xp_cmdshell (which is in the master database) to a database user ( or database role ) which belongs to the user database?

Thanks,

delpiero