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 |