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

     

JWE's avatar
JWE
Icon for Helper I rankHelper 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's avatar
jhhhjiolhioopi
New Member
10 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?