Join 3 tables

building semantic layer
1

I am starting to venture into the world of BO design, and have been on the designer base course. I am ready to make an adjustment to an existing universe.

What I am trying to acheive is the following:

Table A = Product Master (ie unique product numbers)
Table B= Recipes (contains Product numbers)

I have joined the two tables and this works fine.

The next thing I wish to do, is add in a table Ccontaining language translations of Table A. Not all Products have a language entry, and can contain multiple languages.

So I have then joined A to table C complete with an outer join

Again, this works fine, with the report showing the same entry for all the different language entries.

What I am trying to acheive is, if language FR exists then include this in the report. So the report will show 10 lines, and say 4 of these will show the FR translation.

The question is, is this something I do at universe level? Or should it be done at report level.

Thanks :slight_smile:

here (BOB member since 2011-07-07)

2

Here,

I assume that you have some sort of outer(self)join on the language-code in table C…
Something like:

C.LANG_CODE(+) = @Prompt('Language', bla bla)

Maybe you can change it to:

C.LANG_CODE(+) = @Prompt('Language', bla bla)
or C.LANG_CODE(+) = 'FR'

Hope this helps,
Johan

JdVries :netherlands: (BOB member since 2006-02-06)