Skip to Content
avatar image
Former Member

how to merge FI & MM data

Hi all

may be similiar threads are also present in sdn, but my question is very specific ,hence i hv posted it again

my requirement is to merge the data from MM & its corresponding FI data into a single record to display in the report.

eg.

FI doc PO CC CO PC MAT MG AMT INV

510000000 45000000 0030 4000 40001 # # 10000

510000000 45000000 # # # 100 200 10000

but i want to see this as

FI doc PO CC CO PC MAT MG AMT INV

510000000 45000000 0030 4000 40001 100 200 10000 100000

that is in a one single record & avoid the # .I did a lot of r&d , & tried a lot of stuffs , but none gave results yet.

i tried using an infoset over the 2 DSO's using join over FI doc no , FY & CC . here it was not picking up the few values, where my FI doc is not present (some rare cases ).

I tried infoset with outer join - here the results are same as above

I tried an DSO over this infoset , with FI doc, Inv no, PO , item no all in key fields. still results are same.

With multiprovider also , same results.

Is there any better way to do this. ?

or if change my key fields or the join conditions , do u think it can achieved ? (can u pls be specific with some eg fields)

Thanks

Ramesh

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Oct 01, 2008 at 06:41 AM

    How about trying the below :

    Say ODS1 has FI data ODS2 has MM data.

    Create a new ODS3 which has both FI fields and MM fields.

    Load from ODS1 or ODS2 to ODS3.Let me assume ODS1 to ODS3.

    While loading to ODS3 in the update rules/transformation make a look up to ODS2 and populate your MM fields.

    Now you ODS3 is combination of MM and FI data.This you can further load to cube and report on it.

    Hope this helpls

    Add comment
    10|10000 characters needed characters exceeded

    • Not sure if you got what I tried to tell.

      Why will you have 2 DTPS ??

      Loading is like this :

      ODS1 <--- FI (one DTP)

      ODS2 <---- MM (one DTP)

      ODS3 <--- ODS2 (one DTP) (in transformation here you write look up logic)

      record 1 - FI -


      >ODS1

      record 2 - MM -


      >ODS2

      record 3- merged record . -


      >ODS3

      Since you want record 3 you got it in ODS3.

  • avatar image
    Former Member
    Oct 03, 2008 at 05:46 PM

    Integrate FI & MM data on FI doc and PO fields in an ODS, then do what ever you want..

    If you still don't get how to do, let me know..

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi,

      I am also trying to do the same thing. merging FI & MM data based on FI doc no to another DSO.

      but it is still not giving not me the desired results.

      can u help me out, pls.

      Thanks

      Ramesh