HI,
1. If I turn all level in a dimension to no, then what is the default member
?
2. If I create a virtual cube in which there are 2 dimensions which are
common in 2 underlying cubes and 1 dimension belonging to only 1 cube.
e.g
Dimensions --> Product , Time and Scenario
Now 2 cubes are
a) Sales (Measure = Sales Units) Dimensions (Product,Time)
b) Sales Forecast (Measure = Forecast Units) Dimensions
(Product,Time,Scenario)
When in Analysis Manager , I try to browse data for virtual cube based
on 2 above cubes and I use Scenario dimension on rows and Product on Columns
(Time as slicer dimension)
I still get values for measure Sales Units which comes from Sales cube
which does not have Scenario dimension. should'nt the cells be blank b'cos
there
should be no values at intersection of Scenario and product dimension .
What am I missing here ?
Regards,
Akshay