dbTalk Databases Forums  

Cross joins

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


Discuss Cross joins in the microsoft.public.sqlserver.olap forum.



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

Default Cross joins - 09-04-2005 , 09:10 AM






In several business cases we have a need for combining values in one
separate dimension with values in another separate dimension
when controlling what to show the user.

This would be a hierachical dimension but the user still see's this as 2
separate dimensions.

We then in the relational environement in some cases made a crossjoin
dimension between these two and present this to the user - this can result
in the same child name for different parents but that's preciously the need.

Is this type of combining 2 dimensions something that is supported by Yukon
AS without having to do something more in the relational environment ?

/Michael V.



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.