How to model this scenario

[Former Member]

Dear Experts,

I have requirement where in certain data is in infoset and need to join one DSO to that and the only common data will be one characterstics Zdoctor, how to model this

Below is the model data i am giving along with desired output.

Infoset

giving the below characterstics and output

Zdoctor, Zsalesman, Zdate, zjoint, zjointremarks, zL1, Zl2,

100 Daniel 10-01-2009 Yes Ok 14 15----this row is connecting to the ods-1's two rows

101 Daniel 11-01-2009 no cancel 14 15

102 Daniel 12-01-2009 no Probability 14 15

ODS-1

Zdoctor, Zsalesman, Zdate, zcategory, zcat_remarks, zbrand,

100 john 09-01-2009 12 Yes SPL

100 Sam 09-01-2009 13 No SPL

Need to add the below ODS-1 data to the above infoset side by side only thing

common between these two will be zdoctor characterstic.

The output should be

Zdoctor, Zsalesman, Zdate, zjoint, zjointremarks, zL1, Zl2, Zsalesman, Zdate, zcategory, zcat_remarks, zbrand,

100 Daniel 10-01-2009-yes- Ok--

---

14 15 john 09-01-2009 12 Yes SPL

100 Daniel 10-01-2009 Yes Ok 14 15 Sam 09-01-2009 13 No SPL

Thanks and Regards

Neel

[Former Member · Accepted solution]

Hi,

Change the Infoset and include the new ODS(ODS-1) into the infoset. What is the existing infoset built on. Master data / ODS / Cube.

Link the doctor field from infoprovider of existing infoset and to the new ODS-1. This will fetch output as per you need.

But one thing you need to be sure that data is present in all the infoprovider since infoset fetches data based on table join.

Hope this helps

Regards,

Akhan

[Former Member · Accepted solution]

Dear Akhan,

Thanks for the info.

Actually the infoset is based on two ODS and two master data objects and the joins is like that one ods is being connected by all other objects in left outer join. So shall i connect the new ods also with left outer join.

Okay as i gave in the example if the infoset is having one record this ods might have three records for that one record.

Than how this will show.

Thanks and Regards

Neelkamal

[Former Member · Accepted solution]

Hi,

Yes you can join the ODS to the infoset same way as you have mapped the two DSO and two master data object.

If you have three records in new ods for same doctor as in your example then in infoset output you will get three records.

Based on the join condition each records will be fetched.

For example,

ODS 1

Zdoctor, Zsalesman, Zdate, zjoint, zjointremarks, zL1, Zl2,

100 Daniel 10-01-2009 Yes Ok 14 15

101 Daniel 11-01-2009 no cancel 14 15

102 Daniel 12-01-2009 no Probability 14 15

ODS 2

Zdoctor, Zsalesman, Zdate, zcategory, zcat_remarks, zbrand,

100 john 09-01-2009 12 Yes SPL

100 Sam 09-01-2009 13 No SPL

If you join these two ODS in infoset with doctor as join condition, you will get output as follows

Zdoctor, Zsalesman, Zdate, zjoint, zjointremarks, zL1, Zl2, Zsalesman, Zdate, zcategory, zcat_remarks, zbrand,

100 Daniel 10-01-2009 Yes Ok 14 15 john 09-01-2009 12 Yes SPL

100 Daniel 10-01-2009 Yes Ok 14 15 Sam 09-01-2009 13 No SPL

Hope this gives you an idea.

Regards,

Akhan