Is there a way to DrilldownMember a specific member in a
cross join. Take the MDX query

SELECT {CROSSJOIN({[Customers].[All Customers].children},
{[Product].[All Products].children})} on 0 from [Sales]

I would like to DrilldownMember on [Drink] under [USA]
is this possible?

Tom

Is this what you mean...?

SELECT
Crossjoin(
[Customers].[All Customers].children ,
{ [Product Family].Members, Drink.Children }
) on 0
FROM Sales

(not sytax checked)

tom @ the domain below
www.tomchester.net


"Tom George" <thenasian (AT) yahoo (DOT) com> wrote

Sorry for not being more clear. I want only the Drink
under USA to be drilleddown, not drink under Mexico or
Canada. What I want is something like this


Canada Drink
Canada Food
Canada Non-Consumable
Mexico Drink
Mexico Food
Mexico Non-Consumable
USA Drink
USA Alcoholic Beverage
USA Beverages
USA Diary
USA Food
USA Non-Consumable

The output of this (gnarly) query matches what you want:

Hierarchize(DrillDownMember(Filter(CROSSJOIN([Customers].[All
Customers].children,
[Product].[All Products].children),Customers.CurrentMember is
[Customers].[All Customers].[USA]),
{[Product].[All Products].[Drink]})+Filter(CROSSJOIN([Customers].[All
Customers].children,
[Product].[All Products].children),not Customers.CurrentMember is
[Customers].[All Customers].[USA])) on 1
from [Sales]
- Deepak

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

There's more than one way to do this.
Here is one:

SELECT
hierarchize( { { CROSSJOIN({[Customers].[All
Customers].children},{[Product].[All
Products].children}) } + { {[customers].usa} *
{drink.children} } })
on 0 from [Sales]

+ stands for UNION and * stands for CROSSJOIN

HTH,
Brian
www.geocities.com/brianaltmann/olap.html