We have got 3 source cubes with the private dimensions.
(Even though all the 3 cubes refers to the same dimension
table, they have been associated with the cube as private
We tried to build a virtual cube with the 3 source cubes.
When we tried to define dimensions to the virtual cube, we
could find that the list of available dimensions shows the
dimension names 3 times followed by the cube name in the
bracket. We included all the dimensions of a particular
cube and built the cube.
While browsing the data (with some filters on), the data
of all the cubes except the Cube whose dimension had been
included while defining the dimensions of the virtual cube
are not shown.
Is it that when I create a private dimension in a cube,
that dimension cannot be used across other cubes inside
the Virtual Cube.
Thanks for your time.