Query Designing Problem ???

[Former Member]

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

[Former Member]

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

[Former Member]

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

[former_member755961]

Try creating a Multiprovider and build a query.