Hi,

How does ADOMD and ADOMD.NET Cellset DrilledDown property work ?
When I execute the following query:
SELECT { Measures.[unit sales] } on 0,
{ ( Customers.Canada, Gender.[All Gender] ), (Customers.USA, Gender.[All
Gender]), (Customers.USA, Gender.F), (Customers.USA, Gender.M),
(Customers.Mexico, Gender.[All Gender]) } on 1
FROM [Sales]

I get the following result for DrilledDown member Property on members of
dimension Gender:
(line1) Customers.Canada | Gender.[All Gender] (DrilledDown =
True)
(line2) Customers.USA | Gender.[All Gender] (DrilledDown =
True)
(line3) Customers.USA | Gender.[F] (DrilledDown =
False)
(line4) Customers.USA | Gender.[M] (DrilledDown = False)
(line5) Customers.Mexico | Gender.[All Gender] (DrilledDown =
False)

I expected line 1 to be different: it should be DrilledDown= False, as well
as line 5.

Am I wrong, is there a way to get correct Drilled status when using
crossjoin ?

Regards,

Davy Ramirez