relationship between multiple fact tables with date

[JWE]

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

[PavelR]

Hi @JWE

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

Regards.

Pavel

[JWE]

Hi Pavel

OK that´s possible, but still inactive !?

Jorg

[ImkeF]

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 · Accepted solution]

Hi Imke

thanks for the hint, now it works,

For all, here my solution after edit the relationship.

Reagrds Jorg