Hi there!

I have a problem with creating a local cube
from a virtual cube in Microsoft Analysis Services.
The virtual cube is derived from two cubes Distribution an Visit.
The Distribution contains the dimensions Time,
Geography, Employee, and Brand, and the measure
Facing In. The Visit Cube contains the dimensions
Time, Geography, Employee, and the measure
Facing Total In. So Brand dimension is not
common between those two cubes. I also
created a calculed member named 'Share of Space In'
with statment:

'[Measures].[Facing In]/ValidMeasure([Measures].[Facing Total In])*100'

It works fine if I edit the virtual cube in Analysis Menager but
when I create and popolate the local cube with data from the
virtual cube, the calculed member 'Share of Space In' shows
no values for the Brand dimension.
Is this the limitation of local cubes? Can anyone help me with that?

Marcin