dbTalk Databases Forums  

Dimensions, dependent on two different dimensions

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


Discuss Dimensions, dependent on two different dimensions in the microsoft.public.sqlserver.olap forum.



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

Default Dimensions, dependent on two different dimensions - 09-08-2003 , 07:58 AM







Hi All!



I've got a question as follows:



I have a cube with dimensions Goods, Countries and Time and
measure Sale.

Goods have their properties like Name, Package and some others. But it
should be some properties dependent on Goods and Countries at the same
time (Registration for example).



How should I make this?



As I see one of the possible solutions is to make another cube with
dimensions Countries and Goods and measure Registration. And make a
virtual cube containing both cubes. So I can create a calculated member
Registration. Is this right approach?

I wish to have a dimension, not a measure.



Thanks for your help


--
Posted via http://dbforums.com

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.