Hello,

If you could help with this, I would be appreciative.

When I run the following MDX query

select
{[Measures].[Unit Sales]} on columns,
order(except([Promotion Media].[Media
Type].members,{[Promotion Media].[Media Type].[No
Media]}),[Measures].[Unit Sales],DESC) on rows
from Sales

Currently the result set includes the column name "[Promotion
Media].[Media Type].[MEMBER_CAPTION]" and I would like to change this
to simply "Promotion" without using the WITH clause. Is this
possible in MDX?

Thank you!

Tomcat

--
Posted via http://dbforums.com