Forum Discussion

krimyr's avatar
krimyr
Frequent Visitor
2 years ago

How to count multiple dims away?

Hi,   I have a Fact table. This is connected to a DimDate with the Date field, working great.. ... and also connected to a lot of other Dim tables, working great..   I have connected my Fact to...
Need Help
parry2k's avatar
parry2k
Super User
2 years ago

krimyr your presentation seems confusing, I guess dim tables doesn't have a relationship with each other?

 

Which table has the type column?

  • krimyr's avatar
    krimyr
    Frequent Visitor
    2 years ago

    I am sorry! I thought it was clear.

     

    Fact has a relationship to DimTable1. (1 to many)
    DimTable1 has a relationship to DimTable2 (1 to many)
    DimTable2 has a relationship to DimTable3 (1 to many)

    DimTable3 has a relationship to DimTable4 (1 to many)


    DimTable4 has Type which I want to count based on Type=1,2,3 etc.