dbTalk Databases Forums  

Cube design for self referencing table

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


Discuss Cube design for self referencing table in the microsoft.public.sqlserver.olap forum.



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

Default Cube design for self referencing table - 07-24-2006 , 04:07 PM






A portfolio and a benchmark have the same structure. Every portfolio
has a related benchmark to which it is compared. Many securities are
shared between the portfolio and the benchmark. When you look at the
portfolio from various dimension combinations the user wants to see
what the corresponding benchmark looks like from the exact same
dimensions.

My DimPortfolioBenchmark table is linked to my FactPosition table. A
portfolio is compared to a benchmark so each portfolio has a
PortfolioBenchmark key indicating the benchmark it is compared to.
When I pull up a measure for the portfolio I want to see the
corresponding measure for the benchmark (or at least for certain
selected ones). I was trying to do this in a calculated field. What
would be the best way to do this? Is this the right structure?

What would the MDX for the calculated field look like?

Thanks in advance


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.