Forum Discussion

beno's avatar
beno
Frequent Visitor
10 years ago
Solved

Two Fact tables with different granularity

Hello,   I have two "fact" tables reflecting tow different subjects: the invoices and projects. I need to compare results Budget vs Expences. This is the hierarchy in each of these tables: Table I...
Need Help
  • v-sihou-msft's avatar
    v-sihou-msft
    10 years ago

    beno

     

    In this secnario, if you want both tables can be sliced by all dimensions, you need to combine these two tables together. Since you have "Invoice Date" and "Client" columns in both tables, you can crossjoin these two tables into one table based on those columns.

     

    Regards, 

v-sihou-msft's avatar
v-sihou-msft
Microsoft Employee
10 years ago

beno

 

In this secnario, if you want both tables can be sliced by all dimensions, you need to combine these two tables together. Since you have "Invoice Date" and "Client" columns in both tables, you can crossjoin these two tables into one table based on those columns.

 

Regards, 

beno's avatar
beno
Frequent Visitor
10 years ago

Thanks. combining the two fact tables in one, reduced modeling efforts.

  • Xinhui04's avatar
    Xinhui04
    Regular Visitor
    7 years ago
    I am facing similar issue and having 2 fact tables with different granularity. Can you share how to cross join and how would the table looks like after merging?