I have a question:
i Street dimension with 3 levels:
*state
**city
***StreetName

on the last level (street) i have member property StreetID.
hoe can i show the street name on row and is member property in col?
this stuff wil not work:
SELECT
non empty {[Street].[StreetName].members} on rows,
non empty {[Street].[StreetName].MEMBERS DIMENSION PROPERTIES
[Street].[StreetName].[StreetID]} on columns
From [adv]

thanks

You will need to create virtual dimension based on StreetID property.

--
==============================*=================== =
Mosha Pasumansky - http://www.mosha.com/msolap
Analysis Services blog at http://www.sqljunkies.com/WebL*og/mosha
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==============================*=================== =
"Ruby Nadler" <RubyNadler (AT) discussions (DOT) microsoft.com> wrote