team2005
asked on
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 ?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER