Hi group!

How can I add more filters ( [Store Type] and [Promotion Media] ) in this
MDX query:


WITH
SET [LastMonth] AS ' Tail(Filter([Time].[Month].Members, Not
IsEmpty([Time].CurrentMember)), 1) '
SET [Last7Months] AS ' [LastMonth].item(0).item(0).Lag(6) :
[LastMonth].item(0).item(0) '

SELECT
[Last7Months] ON COLUMNS,
{[Measures].[Unit Sales]} ON ROWS
FROM
Sales
WHERE
([Store].[All Stores].[USA].[WA])

-- AND [Store Type].[All Store Type].[Supermarket]
-- AND [Promotion Media].[All Media].[Radio]

I know I can't put more than one condition after WHERE, but what is the
solution ?

Thanks.

VK

Hi,

yes you can... You can't use a reference to more than one member from the
same hierarchy.

cheers,
Matthias


WITH
SET [LastMonth] AS ' Tail(Filter([Time].[Month].Members, Not
IsEmpty([Time].CurrentMember)), 1) '
SET [Last7Months] AS ' [LastMonth].item(0).item(0).Lag(6) :
[LastMonth].item(0).item(0) '

SELECT
[Last7Months] ON COLUMNS,
{[Measures].[Unit Sales]} ON ROWS
FROM
Sales
WHERE
([Store].[All Stores].[USA].[WA],
[Store Type].[All Store Type].[Supermarket],
[Promotion Media].[All Media].[Radio])


"VK" <vkaligari (AT) tis (DOT) hr> schrieb im Newsbeitrag
news:OZvgehI0EHA.1300 (AT) TK2MSFTNGP14 (DOT) phx.gbl...

Thank you for quick replay!
Can I ask you one more question:
What if I need total sum from last 7 months (ONLY ONE number)
something like that is not working:


WITH
SET [LastMonth] AS ' Tail(Filter([Time].[Month].Members, Not
IsEmpty([Time].CurrentMember)), 1) '
SET [Last7Months] AS ' [LastMonth].item(0).item(0).Lag(6) :
[LastMonth].item(0).item(0) '

SELECT
{SUM([Last7Months],[Measures].[Unit Sales]} ON COLUMNS
FROM
Sales
WHERE
([Store].[All Stores].[USA].[WA],
[Store Type].[All Store Type].[Supermarket],
[Promotion Media].[All Media].[Radio])

what should I change ?
Thanks again.


"VK" <vkaligari (AT) tis (DOT) hr> wrote

You should put the sum-calculation in a calculated member, then it works.

regards,
Matthias


WITH
SET [LastMonth] AS ' Tail(Filter([Time].[Month].Members, Not
IsEmpty([Time].CurrentMember)), 1) '
SET [Last7Months] AS ' [LastMonth].item(0).item(0).Lag(6) :
[LastMonth].item(0).item(0) '

MEMBER [Time].[Sum] as
'SUM([Last7Months],[Measures].[Unit Sales])'

SELECT
{[Last7Months], [Time].[Sum]} ON COLUMNS
FROM
Sales
WHERE
([Store].[All Stores].[USA].[WA],
[Store Type].[All Store Type].[Supermarket],
[Promotion Media].[All Media].[Radio])


"VK" <vkaligari (AT) tis (DOT) hr> schrieb im Newsbeitrag
news:%23pgyDLJ0EHA.2012 (AT) TK2MSFTNGP15 (DOT) phx.gbl...