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

[jhhhjiolhioopi]

Hi Everyone, While the provided solution tend to work for the presented case.
I am struggling with almost similar case:
i have 4-5 fact tables (Sap Sales order (sap_fact_sos), Sap Delivery Notes(sap_fact_dns), Sat Delivery Notes(sat_fact_dns), Sat Delivery Items(sat_fact_ditems). and Dim Date.

All these tables have different dates,  from when order came in - saes order date, when orders is processed to deliveries (Delivery Doc Date), to when DNs synched to Sales Force Automation syste (SAT - third party system for doing deliveries) , to actual deliveries_time (sat_fact_ditems[delivery_time]).

I want to do model it such that i have active relationship between Fact tables and Dim Dates and also active relationship flow from Sales Order-to- sap Deliveries table - to sat_delivery table -to sat_delivery_items tables.
How can I go about  this?