Skip to Content
author's profile photo Former Member
Former Member

Multiple Referential Joins on Fact table (Analytic View)

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on Aug 18, 2015 at 07:31 PM

    Hi Christoph,

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

    -Patrick

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.