dbTalk Databases Forums  

Help---Virtual Cube

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Help---Virtual Cube in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Steve
 
Posts: n/a

Default 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

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.