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

Delta load to InfoCube in sap bi

Hi Friends,

We have developed a legacy to SAP BI system in which we are getting data into SAP BI, PSA -> DSO -> InfoCube -> Business Objects Reports.

Now, we are getting Delta into PSA through a logic then in DSO and then Info Cube.

Delta is working fine till DSO because in DSO we are getting overwritten data but in Infocube the data is getting added as Infocube works.

Now, due to overwrited data reports are getting wrong.

Kindly suggest some solution/strategy for the same.

Thanks & Regards

Saurabh Verma

Add a comment
10|10000 characters needed characters exceeded

Related questions

6 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Oct 20, 2012 at 07:07 PM

    Hi,

    Please check whether the reason for the wrong data is because of your analysis of the overwrite functionality of the DSO.

    Is the solution you are doing in development in prod system?

    Please provide more information so that there can be better comments.

    Regards,

    Vishnu

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 21, 2012 at 04:36 AM

    Hi

    Have you checked the output. because whenever u load the data from the dso to the infocube the data from the changelog table will move to the infocube.

    Let me explain with an example:

    first u have loaded the data

    M1 100

    now the records is loaded to the dso and then to the infocube.

    Active table :

    ---------------

    M1 100

    change log table :

    ----------------------------

    M1 100

    and in the infocube

    ---------------------------

    M1 100.

    now the records is changed to the

    M1 200 .

    now in the changelog table the records wil be in the form of

    M1 100

    M1 -100 (X)

    M1 200 ( )

    Now if u run the DTP , then M1 -100 and M1 200 wil move to the infocube , as a result you will get the correct result.

    Hope you got it,

    Regards,
    RC

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 22, 2012 at 08:44 AM

    Hi Saurabh,

    In Infocube every characheristic acts as key. For an entry all the characteristic values are same then only the additive proper wil apply for keyfigures of that row.

    In case of your example :

    M1 100 PBX

    M2 111 AUC

    M1 200 XAZ

    If you want to replace the first M1 entry with Second M1 entry. whatever the characteristics objects(for the above example in your point of view) should have the same value.

    My Example:

    Material_Group Salesperson_ID Salesman_Name Price

    M1 100 PBX 100.00

    M2 111 AUC 150.00

    These are the two entries contains in the cube. Now if you want to add a new salesman entry for the existance material.

    Material_Group Salesperson_ID Salesman_Name Price

    M1 121 PUG 200.00

    Now if you want to increase the price of the materail 'M1' for salesperson_ID '100' with Rs.50/-.

    Material_Group Salesperson_ID Salesman_Name Price

    M1 100 PBX 50.00

    Now the Infocube content is :

    Material_Group Salesperson_ID Salesman_Name Price

    M2 111 AUC 150.00

    M1 121 PUG 200.00

    M1 100 PBX 150.00

    Please Correct me if i am wrong!

    Suggest points if it helpfull for you. 😊 ℹī¸

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Lakshmi,

      Trying to correct my concept.Dont you think instead of adding 50 to 100 it will replace 100 and will ahve 50 as final record instead as in change log entries will be

      Material_Group Salesperson_ID Salesman_Name Price 0RecordMode

      M1 100 PBX -100.00 X(Before Image Dsc)

      M1 100 PBX 50.00 " "(After Image)

      Correct me if m wrong 😊

      Thanks,
      Deepak Machal

  • Posted on Oct 22, 2012 at 04:54 AM

    Hi Verma,

    Can you plz check what is the type of keyfigure in DSO and cube.

    thanks,

    Mallik

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 22, 2012 at 07:43 AM

    Hi Saurabh,

    Can you please check from DSO --> InfoCube this DTP is full or Delta?

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 30, 2012 at 09:11 AM

    Hi Saurabh,

    Can you please check the DTP (from PSA to DSO), in the DTP setting check howmany Characteristics are selecting in 'Semantic Groups'. I thought that you are using 2 characteristics in 'Semantic Groups'. If this is the case remove any one characteristic from Semantic Groups and try.

    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.