Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mivey4
Yak Posting Veteran
66 Posts |
 Posted - 2009-02-23 : 11:57:44
|
| 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??? Any comments or suggestions are most appreciated.Thx |
|
|
|
|
|
MDX Column Aliases Possible?