I have a virtual cube that consolidates 4 base cubes. Most of the shared
dimensions are in each of the cubes. However, there is one cube that doesn't
contain a few key dimensions, but it houses a measure that needs to brought
into those dimensions anyway and used for calculations when the cube is
sliced by those dimensions it doesn't have. How can I bring that measure into
slices that it's cube doesn't use?

Typically you would employ ValidMeasure() to do this:

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 ***
Don't just participate in USENET...get rewarded for it!

Thank you. That worked.

Wayne

"Deepak Puri" wrote: