How to use stored procedure in OLAP-cube
Hi!
Have a Fact table in a OLAP-cube.
I am using MIcrosoft viusal studio to make my cube
But the problem is:
I must use a stored procedure to populate data to fact table.
I am using SSIS for populate (insert) data to my dimention tables.
But my fact table must be updated from a stored procedure.
How can i do this ?
Have a Fact table in a OLAP-cube.
I am using MIcrosoft viusal studio to make my cube
But the problem is:
I must use a stored procedure to populate data to fact table.
I am using SSIS for populate (insert) data to my dimention tables.
But my fact table must be updated from a stored procedure.
How can i do this ?
Asked:
Who is Participating?
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
All Courses
From novice to tech pro — start learning today.
But my fact table must be updated from a stored procedure.>>
Do you have the SP that should update your fact table? You can call that in a SSIS sql step like EXEC dbname.schemaname.spname
On another hand if you have the stored proc created and it returns record set that needs to be inserted into the fact table you could also do that in a SSIS sql step.