topic Struggling with connecting two fact tables to two dimension tables in Connectivity & Data Prep

Struggling with connecting two fact tables to two dimension tables

dnl_kln — Fri, 04 Mar 2022 10:48:03 GMT

Hello folks,

I am really struggling with getting the connection between two fact tables and two dimension tables together.

The Fact Tables are:

- Angebote

- Aufträge

Both with the field "Kategorie"

the dimension tables are:

- Mastercalendar

- Kategorien

I Would like to connect "Angebote" and "Aufträge" with the "Kategorien" tables, due to the fact that the Data in these fields is the same. I don't want to concatenate "Angebote" and "Aufträge", because i will then have to reorganize my set analysis in the App.

Building a "KategoryKey" in the Tables "Angebote" and "Aufträge" led to SynthKey. Building two keys led to a loop.

I will attach a screenshot of the Data-Model.

Thanks a lot in advance for any help.

Daniel

Re: Struggling with connecting two fact tables to two dimension tables

anat — Fri, 04 Mar 2022 10:56:02 GMT

can u try using "unqualify" like

unqualify Kategorien;

Re: Struggling with connecting two fact tables to two dimension tables

dnl_kln — Thu, 10 Mar 2022 17:04:58 GMT

well, I die, and it again led to synth-key.... ($Syn 1 = KeyKalender+Kategoriekey) - and Table "Kategorie" dissappeared....

(see attached files)

Re: Struggling with connecting two fact tables to two dimension tables

marcus_sommer — Fri, 11 Mar 2022 13:44:11 GMT

The simplest solutions is really to concatenate both fact-tables even if it means that you need some adjusting within the UI. To develop a link-table between your fact-tables and the dimension-tables will cost more efforts - now and also in the long-term.

- Marcus