on 12-31-2014 4:23 AM
Hi Folks,
I have 2 info cubes in Info set, I need to mark the join as Left outer join.
I have read some blogs where is says that it cant be joined, but one of my colleagues has made left outer join using two cubes.
I want to replicate the same thing into my design.
If i normally connect one IO to another cubes same IO- its a normal join- its not written as left outer join. I want to see left outer join written on my link.
I tried global setting but no use.
Am I missing some setting,
Hi Vivek,
Select the Info cube and right click on it and select JOIN type --> Left Outer join.
This is how you can get the Left outer join and which is written on the join.
Regards
KP
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Vivek,
Please have a look at SAP Note 577953 - @0S@ InfoSets (BW): Left outer joins.
The answer on question "3. How do I define a left outer join in InfoSet maintenance?" describes how you should proceed.
Best regards,
Sander
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
10 | |
9 | |
8 | |
6 | |
6 | |
6 | |
5 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.