I have a DIM_A that has 4 members total:
DIM_A:
A-1
A-2
A-3
A-4
That's a shared dimension.

DIM_A is a dimension for CUBE_A only. CUBE_B and CUBE_C are not using DIM_A.

I then built a virture_cube that includes CUBE_A, B and C. DIM_A is a
dimension in the virture_cube. If I am not at the "All DIM_A" level of
DIM_A, for example A-2, all measures from other cubes (B, C etc) turned to 0.
Is there a way to have all measures from other cubes not impacted by the
drill down of DIM_A?

In AS 2005, this is handled by default, but since you are likely using
AS 2000, wrap the measures with ValidMeasure():

http://msdn.microsoft.com/library/de.../en-us/olapdma
d/agmdxfunctions_76cl.asp
Returns a valid measure in a virtual cube by forcing inapplicable
dimensions to their top level.

Syntax
ValidMeasure(«Tuple»)

Returns a valid measure from a tuple in a virtual cube specified in
«Tuple».

Remarks
When computing values in a virtual cube, measure cells only contain
values at the (All) level for dimensions that are not common between the
underlying cubes. The ValidMeasure function returns the measure value
from the cell at the (All) level coordinates for the dimensions that are
not common.
...

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***