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

Register | Login 

Follow BOB on Twitter! 
Follow BOB on Twitter! (Opens a new window)  

General Notice: No events within the next 45 days.

How to select one occurance of record from multiples


 
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
khess
Forum Member
Forum Member



Joined: 20 Jul 2006

Posts: 1



PostPosted: Wed Nov 07, 2007 3:33 pm 
Post subject: How to select one occurance of record from multiples

I am hoping that someone can point me in the right direction as I am green in using designer. I am designing a universe for BO XI and the database is on TerraData server.
I have table of transaction records that contain a provider id. I have to supply the vendor name that the provider is employed with and that vendor number is stored in the contract table which contains multiple contracts for each provider. I am not sure how to link the transaction table to the contract table to the vendor table as to avoid duplicating the transactions for providers with multiple contracts.


I hope I explained this well enough.

Thanks
Back to top
eye_candy
Principal Member
Principal Member



Joined: 18 Mar 2005

Posts: 419


flag
PostPosted: Wed Nov 07, 2007 4:40 pm 
Post subject: Re: How to select one occurance of record from multiples

You need to create a sub query.
Back to top
richmona
Principal Member
Principal Member



Joined: 15 Apr 2003

Posts: 348
Location: Melbourne


flag
PostPosted: Thu Nov 08, 2007 6:59 am 
Post subject: Re: How to select one occurance of record from multiples

Hi...
it sounds like there is no relationship between the transaction and the contract. Is there a table that contains only the unique vendors and not the contracts that happen to have vendor info ?
Back to top
audew
Forum Member
Forum Member



Joined: 08 Nov 2007

Posts: 2



PostPosted: Thu Nov 08, 2007 5:28 pm 
Post subject: Re: How to select one occurance of record from multiples

You can create a derived table that will eliminate the multiple records of the provider. Then you join that derived table to the transaction table.
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.0356 seconds using 18 queries. (SQL 0.0113 Parse 0.0009 Other 0.0234)
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