joining fact tables

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Joe H - 21 May 2008 19:55 GMT

I have two fact tables, ContractFact and FundFact.

In my DSV, I created a relationship to join them on a field that is in both,
called ContractID.

I'm having trouble figuring what to do to get the measures from both fact
tables to line up using the Dimension Usage Tab.

I would have guessed it to be a Regular relationship - however there is no
attributes that show that make sense. I was suspecting I would just use
Regualar and line up with ContractID.

Reply to this Message

Marco Russo - 22 May 2008 08:30 GMT

> I have two fact tables, ContractFact and FundFact.
>
[quoted text clipped - 7 lines]
> attributes that show that make sense. I was suspecting I would just use
> Regualar and line up with ContractID.

Two ways:
1) Create two measure groups in the same cube (one for each fact
table)
2) If tables have the same cardinality, create a view that joins the
two fact tables and see the result as a single fact table from SSAS

Marco Russo
http://www.sqlbi.eu
http://sqlblog.com/blogs/marco_russo

Reply to this Message