Forum Discussion

Spurgeon74's avatar
Spurgeon74
Frequent Visitor
2 years ago

Multiple Fact Tables one Calendar/Time Table

Ich möchte zwei Faktentabellen mit jeder Menge Messwerten mit einer Kalender und Zeit Tabelle verbinden. Wie sind hier die Beziehungen zu setzen? Kalender 1:* Fakten funktioniert nur bei der Verbindung zu einer Faktentabelle.

 

I want to connect two fact tables with lots of measured values ​​to a calendar and time table. How should the relationships be set here? Calendar/Time-Tble 1:* to Fact-Table only works when connected to only one fact table.

1 Reply

  • vanessafvg's avatar
    vanessafvg
    Community Champion

    it depends on what you doing, how are you trying to use this.  essentially the calendar table in the middle of all the facts, you need to use the dates in calendar, when you say it only works, against one fact, what does that mean, please give a detailed explanation of the error and what you are expecting to see.  please also screenshot your relationship view so we can seee the relationships set up.