Forum Discussion

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. ...

JWE
9 years ago
Hi Imke

thanks for the hint, now it works,
For all, here my solution after edit the relationship.

Reagrds Jorg

Helper I

9 years ago

Hi Pavel

OK that´s possible, but still inactive !?

Jorg

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
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
- jhhhjiolhioopi
  New Member
  9 months ago
  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?

Related content