Your question, your audience. Choose who sees your identity—and your question—with question security.
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:
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.
Join & Write a Comment Already a member? Login.
Featured Post
Tackle projects and never again get stuck behind a technical roadblock.
Join Now
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.