Marcus Aurelius
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...?
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.