March 31, 2011 at 2:49 am
Please help me
How to run Cube from storeProcedure...?
Thx
March 31, 2011 at 3:44 am
What do you mean with run? Do you mean processing the cube?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 31, 2011 at 3:47 am
Yes, I mean processing the cube with Store Procedure..?
pls help..
March 31, 2011 at 3:57 am
redi_netsis (3/31/2011)
Yes, I mean processing the cube with Store Procedure..?pls help..
Well look at that, the first result from a Google search with the keywords ssas process cube from stored procedure:
http://weblogs.sqlteam.com/jeffs/archive/2008/10/27/process-olap-cube-with-t-sql.aspx
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 31, 2011 at 4:20 am
I find the easiest way is to create a ssis job to do the processing and then call this job from a stored proc.
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply