Skip to Content
author's profile photo Former Member
Former Member

Query Designing Problem ???

Hi Experts,

I am stuck up this unique kind of a requirement.

I have 2 ODS, one has the service ticket details and the other ODS has the relavent Defect details related to the service ticket.The report needs to be shown in the following format.

TicketId. Date CreatedBy Country

1001 6-11-2005 Sam US

DefectID Title Owner Details O/S Version

1 T1 O1 D1 S1 V1

2 T2 O2 D1 S2 V2

1002 7-11-2005 John US

DefectID Title Owner Details O/S Version

3 T3 O3 D3 S3 V3

4 T4 O4 D4 S4 V4

5 T5 O5 D5 S5 V5

The two ODS have Service Ticket ID as a common infoobject. Any suggestions as to how this can be achieved.

Thanks

RB

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Dec 07, 2005 at 06:27 PM

    Try creating a Multiprovider and build a query.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 07, 2005 at 06:32 PM

    Hi ,

    try create a multi provider and select the 2 ODS's in it which u require . select the relevant fields in the multi provider according to ur requirement . now create a query on the multi provider and drag and drop the required fields in rows and columns , u will definetly achieve it .....

    regards

    Santosh Utla

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 07, 2005 at 07:00 PM

    Rajat, I am assuming that the defect ODS has the TicketId column in it. In that case first create a InfoSet by joining the 2 ODS's and create a query using this InfoSet.

    MultiProvider will UNION the 2 ODS's and may not provide what you need or will require additional setting on Bex to achieve what you are looking for.

    -Vinod Swarnapuri

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.