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

how to correct incorrect data records in my DSO and Infocube

hi all

We have an issue with incorrect data .

Our PROCESS CHAIN IS LIKE

1. START

2. IP ( DELTA)

3.FROM HERE it loads to my info cube and DSO in paralllel.

dso : start-> ip(delta)-> dtp (load to dso)

IC: Start -> IP( delta)-> DELETE ALL REQUESTS IN CUBE-> DTP (to cube).

SO , whats happening is every day the process will delete all the requests on cube and does a full load.

when it comes to our DSO it is just a delta everyday.

Here we had a problem with the data records.

The problem is that in 6 of the records which have been extracted to our Data targets , when reporting we found that instead of E00106,E00107....so on ...,these particular fields are showing up as F00106,F00107......

But when we tried to debug the issue , we came to know that these values were entered wrong in the source system (CRM) itself.

so those guys told that they will be correcting these values at the source system . But the problem is now how do we change those particular data records in our DSO and Infocube.

2 questions arise here

1. how to reflect the changes in DSO.

2. how to reflect the changes in INFOCUBE. ( NOTE : here everytime we are deleting all the cube requests before loading data and loading all the requests from PSA.)

thanks all

Add a comment
10|10000 characters needed characters exceeded

Related questions

6 Answers

  • author's profile photo Former Member
    Former Member
    Posted on May 23, 2011 at 03:05 AM

    HI,

    For temporarily you edit those records in the data targets itself, follow the procedure which is mentioned below.

    1) Go to SE11 -->got to Database table (F fact table for IC and then Active table for DSO) --> Contents --> Select the records which you want to EDIT

    2) Now enter /h in the transaction bar

    3) Now select the records which you want to EDIT and double click on it

    4) Itu2019ll take you to ABAP debugger screen, Hit F7

    5) You will see this code u201C if code = 'SHOW' u201C

    6) Double click on the CODE , now you can see this in Field names and also Show in field contents

    7) Now Remove show and replace it with EDIT (only in caps) and then click on Pencil Symbol (Change) and hit F8

    8) Now you can Edit the records. Finally save them and then check the records in the target.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 21, 2011 at 08:19 PM

    Hi,

    If the data volume is not high, then clear off all the data in BI and re initialize the delta, using option of delta with data transfer.

    The simplest option possible but may be time consuming depending on the data volume.

    The new deltas will any ways bring the new correct data, so getting the correct data is not the problem at all. Just that the error data needs to be removed from the info providers.

    For the DSO, just doing a selective deletion for the erroraneous data will solve the issue.

    The problem is the cube, since it a full update from the PSA. For this you can try deleting these entries manually from the PSA table. This should resolve the issue.

    Regards,

    Shyam.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 22, 2011 at 06:44 AM

    Hi,

    Please run Repair Full request to your DSO & Cube. Before doing repair full in cube, plz delete those records from cube. But fot DSO deletion is not required because DSO has overwriting functionality.

    Assign me points if it helps you. If you have nay cooncerns, pls get back to me.

    Regards,

    Suman

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 22, 2011 at 08:35 AM

    the data volume is low , can you provide me the steps of how to setup a delta with data transfer.

    also

    1.can you provide me the steps of how to do selective deletion from DSO or Infocube.

    2. steps of how to change / delete PSA data.

    thanks

    Add a comment
    10|10000 characters needed characters exceeded

    • If they 6 records only, search them in PSA, correct and save. Should not be much effort.

      Problem is with cube - as it is full, it will load everything from PSA always. So you will have to correct the records in PSA.

      For DSO, if the field is in Data fields, correct values will automatically overwrite in next delta. If it is key field, then you can do selective deletion.

  • author's profile photo Former Member
    Former Member
    Posted on May 23, 2011 at 07:02 AM

    Hi ,

    1. how to reflect the changes in DSO.

    To reflect the changes in the DSO, correct the data in the PSA and load them.

    You can run a full repair for those 6 records only and then correct them in the PSA before loading.

    2. how to reflect the changes in INFOCUBE

    First delete the incorrect records form the cube and then run a full repair request from the DSO only for those 6 records. Select the data accordingly and then load.

    Regards,

    Rahul

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Apr 01, 2015 at 10:08 AM

    Hi,

    If you care about system sanity you should first check if correction made by CRM guys will be reflected in your datasource before implementing all the above suggested gimmicks. You should presume you will have the required changed in the next delta. If this is not the case ie changes on these fields do not trigger delta in the source system than you can try to edit cube tables, active dso tables etc. Consider also serial flow from DSO to Infocube with option "Get only delta once" to assure data inegrity between DSO and infocube.

    Regards

    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.