Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Relationship between these two fact tables?

Hi,   ich have on one side a wager. That is my first fact_wagers. It has attributes like: wager_id first_product_id second_product_id   One the other hand I have a fact for the winnings: fac...
cube
Power BI Report Server
  • Icey's avatar
    Icey
    5 years ago

    Hi Anonymous ,

     

    Please check if the attachment could meet your requirements:

     

    There are some transformations in Power Query Editor.

     

     

    Best Regards,

    Icey

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

HashamNiaz's avatar
HashamNiaz
Icon for Solution Sage rankSolution Sage
5 years ago

Hi Anonymous !

 

I would model this slightly different;

 

Dimesnion:
DimWager (Unique WagerID)

DimProduct (Unique ProductID)

 

Fact: (Bridging Table)

FactWagerProductWins (WagerID, ProductID, WinAmount) - Wager can have multiple ProductID, you don't need to create separate column for each ProductID

 

Relatiionships:

1 - Many between DimWager - FactWagerProductWins (based on WagerID)
1 - Many between DimProduct - FactWagerProductWins (based on ProductID)

 

This will remove the of separate FactWager (which has only WagerID & ProductID mappings)

 

Regards,

Hasham

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    That is interessting. In which cases you are able to design a fact_table as a dimension_table? 

     

    I mean a wager is in this context a business event, which a customer produces. I never thought about to design this a dimension. Is it allowed to insert a lot of entries to a dim_table?