Forum Discussion

JWE's avatar
JWE
Icon for Helper I rankHelper I
9 years ago
Solved

relationship between multiple fact tables with date

Hi all

 

I have multiple fact tables whit individual date columns.

Fact table: 'Aktionen', 'Artikelposten' and 'Ressourcenposten'

Each fact table has his own date column - see red lines.

 

 

I have build a date dimension table 'Kalender' for dice and slice.

 

But I have also a table 'Debitor' which I want to connect to each fact table.
I want to use the column 'Debitor-Nr' which appears in each fact table - see the blue lines.

 

I can build one relationsship to one fact table, but the other ones are inactive.

What can I do?

 

Thanks Jorg

 

Need Help
  • JWE's avatar
    JWE
    9 years ago

    Hi Imke

     

    thanks for the hint, now it works,

    For all, here my solution after edit the relationship.

     

    Reagrds Jorg

     

5 Replies

  • PavelR's avatar
    PavelR
    Icon for Solution Specialist rankSolution Specialist
    9 years ago

    Hi JWE

     

    you can change the Cross filter direction from Both  to Single in Relationships pane - Edit relationship.

     

    Regards.

    Pavel

     

     

    • JWE's avatar
      JWE
      Icon for Helper I rankHelper I
      9 years ago

      Hi Pavel

       

      OK that´s possible, but still inactive !?

       

      Jorg

      • ImkeF's avatar
        ImkeF
        Icon for Community Champion rankCommunity Champion
        9 years ago

        You need to change the bidirectional filters from your fact tables to the calendar/date-table as well. Effectively, make sure that you don't create a filter-circuit between your fact-tables.