Help---Virtual Cube -
08-04-2005
, 08:10 PM
Hi,
Please help me with the following.
Using Example here
I have a virtual cube.
It consists of 2 cubes
Cube A
Dims:
Product
Sales
Measures:
sALES
Revenue
Cube B
Dims:
Location
Customer
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. 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.
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
Thanks in advance
Steve
--
IT Developer |