I am querying a cube in t-sql with an mdx statement inside of a openquery function. Using the insert into statement I am inserting the result set into a temp table. I need to alias the the column names. I can alias the messures ( [XXXXX].[XXXXX]) but not the dimminsions ([XXXXXX].[XXXXXX].[XXXXXX]). Can anyone help?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How can I alias a MDX dimmission in T-sql
- Thread starter sduryee
- Start date
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question