Struggling with connecting two fact tables to two dimension tables

[dnl_kln]

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

[anat]

can u try using "unqualify" like

unqualify Kategorien;

[dnl_kln]

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

(see attached files)

[marcus_sommer]

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