Hi,
Please help me with the following.
Using Example here
I have a virtual cube.
It consists of 2 cubes

Cube A

Dims:
Product
Category
Time
Measures:
sALES
Revenue



Cube B

Dims:
Location
Customer
Time
MEASURES:
Quantity
cust Count

I have created a virtualcube & have used all the dimensions & measures
mentioned above. Now if I drag down product dimension(which is associated
with Cube A) then virtual cube shows all measures with values(SALES,Revenue,
Quantity,cust Count).
However If I am using product dimension then I should only see measures
sALES & Revenue with values populated. But It shows me values populated for
Quantity & cust Count which are not associated with product dimension.

All Category All Location All Customer All Time


sALES Revenue Quantity cust Count

All Product 10000 11000 100 100



If I drill down on product dimension then I get subsequent break down of
SALES &
Revenue. Quantity & cust Count do not show any break down but at the top it
values populated are shown.


All Category All Location All Customer All Time


sALES Revenue Quantity cust Count

All Product 10000 11000 100 100

Product A 200 300

Product B 300 300

Product C 500 500


What do I need to do regarding this issue. I think If I am using Product
dimension I should see only values populated in SALES & Revenue. Quantity &
cust Count should be blank. I should get the following results




All Category All Location All Customer All Time


SALES Revenue Quantity cust Count

All Product 10000 11000

Do I have to change something in properties or ?


Thanks in advance
Steve
--
IT Developer