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...?
Why is this different from all of the other step by step guides? Because I make a living as a DBA and not as a writer and I lived through this experience.
Defining the name:
When I talk to people they say different names on this subject stuff l…
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple. The final solution for this task involved creating a custom text parser and then reading…