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

WITH
MEMBER Measures.StreetID AS 'Street.CurrentMember.Properties("StreetID")
SELECT
{Measures.StreetID} ON COLUMNS,
[Street].[StreetName].Members ON ROWS
FROM [Adv]

Ohjoo Kwon

"Ruby Nadler" <RubyNadler (AT) discussions (DOT) microsoft.com> wrote

Thanks a lot

"Ohjoo Kwon" wrote:

When I am adding WHERE condition to the query i want the result to show me in
the rows only the streets answering to the condition:

WITH
MEMBER Measures.StreetID AS 'Street.CurrentMember.Properties("StreetID")'
SELECT
{Measures.StreetID} ON COLUMNS,
NON EMPTY [Street].[StreetName].Members ON ROWS
FROM [Adv]
WHERE [Advertiser].[All Advertiser].[Peace]

it shows me all the streets and their StreetID not only the ones that answer
the where condition . why?
thanks again



"Ohjoo Kwon" wrote:

I'm sorry I don't understand your question.

WHERE clause plays the role of slicing. It does not affect on the row axis
directly. Is there any available condition between Street and Advertiser to
filter the members on the row axis?

For example,

Filter([Street].[StreetName].Members, What Condition?)


Ohjoo

"Ruby Nadler" <RubyNadler (AT) discussions (DOT) microsoft.com> wrote

Every street has an Advertiser and i want to display only the streets that
their Advertiser is 'Peace'. it wark fine if i dont show the Properties
("StreetID") in the cols but if i add the property i get all the streets no
matter what is the Advertiser.
thanks

"Ohjoo Kwon" wrote:

If then, add Advertiser as a member property to StreetName level and try
next.

Filter([Street].[StreetName].Members,
[Street].CurrentMember.Properties("Advertiser") ="Peace" )

Ohjoo


"Ruby Nadler" <RubyNadler (AT) discussions (DOT) microsoft.com> wrote