I am building a cube that will display

CustKey ItemKey GrossPrice Incentives Rebates NetPrice

My Gross Price and Incentives come from a static list, and are not time
sensitive. I created a cube for these values with just the Customer and
Item dimensions. When I create a Virtual cube that does contain my Time
Dimension, the Gross Price and Incentive values only appear at the Year
Level (which is the top level).

I need these values to appear at the month level. How can I force them
to appear at the month level, when they do not link into the Time
Dimension?

Maureen Adams

You can wrap GrossPrice and Incentives in 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 ***