February 23, 2009 at 9:45 am
Hi,
I have been searching for an answer to this question for some time now but can't seem to locate a definitive solution or very straight answer. There seems to be some controversy on the topic and I am hoping that someone here can give me a straight forward response.
I am pretty new to MDX so pardon my lack of knowledge if the question seems a bit ridiculous, but can you create column aliases within MDX?
I have to port some record sets from MDX over to SQL. I am using the openRowSet command to pass in an MDX query which returns my recordset. The problem is that the way SQL translates the column names make it virtually useless to me if I were to SELECT the data INTO a table.
But if I could create a column alias for the each column in the MDX query it would make life Sooo much easier.
So the question is, Is this possible or is MDX not flexible enough to do this??? :unsure:
Any comments or suggestions are most appreciated.
Thx
February 23, 2009 at 2:59 pm
Nope, but you could create a temp table and load the data into that to work with. Take a look at the example I have towards the bottom of this posting - Using Reporting Services (SSRS) with SSAS data.
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply