New feature! Upgrade and increase expert visibility of your issues with Priority Questions.
Solved
How to use stored procedure in OLAP-cube
Posted on 2013-01-24
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 ?
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
2 Comments
<<I am using SSIS for populate (insert) data to my dimention tables.
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.
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.
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
A couple of weeks ago, my client requested me to implement a SSIS package that allows them to download their files from a FTP server and archives them. Microsoft SSIS is the powerful tool which allows us to proceed multiple files at same time even w…
When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability.
Flipping Coins in Excel: Enter =RAND() into cell A2:
Recalculate the random variable…
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables.
Make a table:
Update a specific column given a specific row using the UPDATE statement:
Remove a set of values using the DELETE s…
Suggested Courses
Course of the Month6 days, 18 hours left to enroll
705 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.