How to see the join type of a model made up of two data sources in SAC?

[YanGerzon]

Hi,
If there is a created model in SAC made out of two merged data sources and a story was created for it.
How do i now see what type of merging was chosen for the two data sources and based on what dimensions the two data sources were merged?
I cant seem to find where to get this info.
there is an option to see the query, meaning the chosen dimensions to take from each data source but not the above.

Thanks.

[N1kh1l · Accepted solution]

101ger

101gerOnce the model is created there is no way to know what join condition was used. If the settings were not changed during wrangling, the default is All primary Data (Left Outer Join).

Nikhil

[YanGerzon · Accepted solution]

Thats bad news.
Thanks.

[N1kh1l]

101ger

When you merge data during wrangling its left outer join by default (all primary data) but you can change it to intersecting data only (inner join). All primary data simply means All data in your first source and all matching data from the second source on a common dimension and only intersecting data means only matching records from both sides on the common dimension. This common dimension would have been mapped by you during data wrangling. see an example below.

Please upvote/Accept if this helps.

Nikhil

[YanGerzon]

Hi,

Thanks for the reply but I meant how do I check the join type for an existing model and based on what dimensions the data sources were joint.