BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Want to sponsor BOB? 
Want to sponsor BOB? (Opens a new window)  

General Notice: BOB is going to retire...please see details here.
General Notice: No events within the next 45 days.

Information design tool


 
Search this topic... | Search Semantic Layer / Universe Designer... | Search Box
Register or Login to Post    Forum Index -> Semantic Layer / Universe Designer  Previous TopicPrint TopicNext Topic
Author Message
tantetruus
Principal Member
Principal Member



Joined: 11 Nov 2008

Posts: 358



PostPosted: Wed May 22, 2019 5:06 am 
Post subject: Information design tool

Is there a simple maual for a newby for working with the join editor in IDT? If i check cardinality i get
1,n=1,1

I understand the concept but dont understand how to set the join in the editor.

Options are 2 outerjoin boxes, one join quick link box and close to that, a pulldown menu with sql symbols =, >,< >=, <= .

Can someone point me to a (graphic) manual or explain how it works?
Back to top
BarkyBaloo
Principal Member
Principal Member



Joined: 04 Jul 2007

Posts: 171



PostPosted: Wed May 22, 2019 7:04 am 
Post subject: Re: Information design tool

https://www.tutorialspoint.com/sap_idt/sap_idt_joins_in_data_foundation.htm



hope this helps

_________________
BarkyBaloo

Your work is going to fill a large part of your life
And the only way to be truly satisfied is to do what you believe is great work.
And the only way to do great work is to love what you do.
If you haven't found it yet, keep looking.
Don't settle.
As with all matters of the heart
You'll know when you find it.
Back to top
tantetruus
Principal Member
Principal Member



Joined: 11 Nov 2008

Posts: 358



PostPosted: Wed May 22, 2019 7:25 am 
Post subject: Re: Information design tool

Nice one!

Still miss some detail though.

In my (test)case i have one (main)table with 54393 rows and a "secundairy" one with 7721 rows.

If i use an outer join the result gives 54605 rows.

That can't be right, can it?
Back to top
dtolley
Senior Member
Senior Member



Joined: 14 Jul 2006

Posts: 85



PostPosted: Wed May 22, 2019 4:56 pm 
Post subject: Re: Information design tool

That could be right. It depends on how you configured the join (left outer, right outer, or full outer) and on the actual data and the relationship between the tables.... is it one to one, one to many, or many to many?
Back to top
tantetruus
Principal Member
Principal Member



Joined: 11 Nov 2008

Posts: 358



PostPosted: Thu May 23, 2019 1:04 am 
Post subject: Re: Information design tool

it's left an outer join
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Semantic Layer / Universe Designer  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0305 seconds using 17 queries. (SQL 0.0031 Parse 0.0009 Other 0.0265)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo