Showing results for 
Search instead for 
Did you mean: 

Multiple Referential Joins on Fact table (Analytic View)

Former Member
0 Kudos

Hi community,

I joined two Attribute Views on my fact table within an Analytic View via referential join. The referential join is used to include the date beside an skey due to slowely changing dimensions. Anyways, my problem is that I´m only getting the data that is found in both joined Attribute Views and I´m losing the data which is just in one of both Attribute Views.

Any ideas how to inlcude the rest also?

Best regards, Christoph

Accepted Solutions (0)

Answers (1)

Answers (1)

Active Contributor
0 Kudos

Hi Christoph,

Something sounds funky indeed.  Are both attribute views directly joined to the data foundation?  Can you post a screenshot perhaps?


Former Member
0 Kudos

Hi Patrick, thanks for the response!

no, they are joined within the Logical Join layer. and both look like the screenshot attached.

The result is like a combined inner join of both ATVs.

Regards, Christoph.