I have a dimension that contains the Territory Desc and a Territory ID.
I have a crossjoin([Territory].[Territory Desc].Members,[District].[District
Desc].Member)
I need to return the Territory information as
[Territory Desc] + ' ' + [Territory ID]
I try using the Descendants, Drilldown , but they do not work. I need to do
using a mdx, but will happy if I can do it too

thank you
Tomas

Is Territory ID another level or is it a property?

Seeing that you have Territory Desc as a level, I cannot see it making
much sense to have an ID level. Surely ID and Desc are of the same
granularity.

Assuming it is a property, probably the easiest thing to do is to create
a calculated measure like:

Territory.CurrentMember.Name + ' ' + Territory.CurrentMember.Properties
("Territory ID")

....and display that as the first column.

--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell

In article <C2BF2AF8-89E5-47CB-B8D2-30DB803A5B39 (AT) microsoft (DOT) com>,
Tomas (AT) discussions (DOT) microsoft.com says...