Forum Discussion

JWE's avatar
JWE
Helper 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.   ...
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

     

PavelR's avatar
PavelR
Solution 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
    Helper I
    9 years ago

    Hi Pavel

     

    OK that´s possible, but still inactive !?

     

    Jorg

    • ImkeF's avatar
      ImkeF
      Community 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.

      • JWE's avatar
        JWE
        Helper I
        9 years ago

        Hi Imke

         

        thanks for the hint, now it works,

        For all, here my solution after edit the relationship.

         

        Reagrds Jorg