Link to home
Start Free TrialLog in
Avatar of Marcus Aurelius
Marcus AureliusFlag for United States of America

asked on

Can SSAS MDX Query be used in a: 1. Stored Procedure 2. Function (Table?)

Experts,

We have a section of our company (National) that creates MDX Queries using SSAS. We are a separate region but would like to take their MDX logic that is created on a National level and use this MDX Query in our local Regional Stored Procedures and Functions.

Is this possible?k

I think the main question is: Can MDX be used to access data withing Stored Procedures and/or Functions... to produce "datasets" for further use in pulling in data using T-SQL...?
ASKER CERTIFIED SOLUTION
Avatar of ValentinoV
ValentinoV
Flag of Belgium image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial