10 Replies Latest reply: Mar 19, 2010 9:13 AM by Siva Sujan Kumar RSS

added records and transferred records

Karthik A
Currently Being Moderated

What is the difference between "transferred records" and "added records" in Infocube-> manage->requests ??

 

Karthik

  • Re: added records and transferred records
    Ravi Ramasamy
    Currently Being Moderated

    Records transferred: - Read from source system.

    Records added: - Actually updated into the info-provider.

     

    Regards,

    R.Ravi

  • Re: added records and transferred records
    Vishvesh Bahirat
    Currently Being Moderated

    transferred records are the number of records transferred or sent from the source system to BW(PSA) in that data request.

     

    added records are the number of records added to the infocube in that data request.added records can be less or even more than the number of transferred records.

     

    cheers,

    Vishvesh

  • Re: added records and transferred records
    Sergio Locatelli
    Currently Being Moderated

    First:

    how many records are trasferred from Datasource.

     

    Second:

    how many records are in effect updated in DataTarget

    Note that for the update rules you can aggregate defferent records in one.

     

    Regards,

    Sergio

  • Re: added records and transferred records
    Karthik A
    Currently Being Moderated

    Thanks friends,

     

    My purpose will be solved once I understand, how can added records be more or less than the transferred number of records.

     

    Sergio has given one example,.. I need some more examples.. pls.

    • Re: added records and transferred records
      Sergio Locatelli
      Currently Being Moderated

      Another common case is when in the update rules you skip a record.

       

      With RECORDMODE <> 0 in a single routine or with the direct deletion of the records in DATA_PACKAGE during the start routine.

    • Re: added records and transferred records
      suman dara
      Currently Being Moderated

      Hi Karthik,

       

      You may have 2 records in the source data with same characteristic values. Then these two will be sumarized and added as a single record.

      say suppose:

       

      C01   M01   100   200

      C01   M02   200   400

       

      Now only one record is added to Infocube

      C01   M01   300   600

       

      -> When there are multiple records with in a same request with same characteristic combinations, They will be summarized while updated to Cube.

      In the above case: No. transferred records = 2

      No. Records Added = 1  

      In this kind of scenarios... Always No. transferred records will be more or equal to Added records.

       

      Some scenarios like where You split records into multiple records using Time distribution or return table... Example: You have monthly revenues in a flat file. But you want to split them into weekly records(based on averege model) and load to Cube. In this kind of scenarios the Added records will be more that Transferred records.

       

      So-> Dont expect the added records = Transferred records always.

       

      Hope this helps.

       

      Suman

       

       

      Message was edited by: suman kumar

       

       

      Message was edited by: suman kumar

       

  • Re: added records and transferred records
    Siva Sujan Kumar
    Currently Being Moderated

    Hi Karhik,

     

    If there any Routines included in Transformation always thers is chance of having difference in count of Transferred and Added records.

    Also based on DSO Design (Key fields) we can have the difference in count.

     

    lets take an example : im bringing two Purchase orders from EKBE (R/3) to BI.

     

    PO        Po Item    Mat doc   

    P1         10              M1  

                                   M2

     

    I have included below fields as key fields in DSO

     

    Pur Order   PO Item 

    P1                 10       

    In this case Transferred wpuld be 1 and added also 1.

    So as per Key field design Im going to get on Record.  now lets change design key field design ......Incuded Material document too in key fields..

     

    PO           PO ITEM      Mat DOC 

    P1            10               M1

    P1             10              M2

     

    In this case transferredwould be 1 and added would be 2.           

     

    Hope it helps

     

    Regards

    Sujan

Actions