Left join merged dimensions (not working)

[williampeck1958]

I don’t do merged dimensions much, but I have the mechanics working but I’m not getting a left join.

I have 744 records in Query A with 742 matches in Query B. But I want to see the blanks for the 2 missing records. Right now it’s only doing an INNER JOIN so only 742 display.

In table properties, I’ve checked “Show rows with empty dimension values”, but it’s not doing that.

Here’s the data. I’ve got merged dimensions and also “detail” objects associated with the merged dimension.

Here’s the merged dimensions setup …

[N8AKTIV]

pay attention to the correct merged-object you use in your table!

e.g:
“Merged Award Number” will give you the inner-join
"BBR Award Number … " from Query 1 or 2 will result in a left- or right-outer join

[williampeck1958]

Hmmm, that makes sense but it’s still not working. I’m definitely using the ~“BBR Award Number-1” and it’s still not giving me what I expect. I’ve tried it multiple ways.

[williampeck1958]

Ahhh, I got it worked out … I had to create details under the merged objects … works great!