Solved

How to use stored procedure in OLAP-cube

Posted on 2013-01-24
2
828 Views
Last Modified: 2016-02-10
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 ?
0
Comment
Question by:team2005
2 Comments
 
LVL 39

Accepted Solution

by:
lcohan earned 500 total points
ID: 38814838
<<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.
0
 
LVL 2

Author Closing Comment

by:team2005
ID: 38818216
Thanks
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
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…
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question