how to correct incorrect data records in my DSO and Infocube

[Former Member]

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

[adamjab1]

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

[Former Member]

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

[Former Member]

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

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

[Former Member]

Hi colleagues,

To enlarge point 6, you should looking for method "SET_STATUS_VAL" and varible "C_CODE".

Have a nice day,

Luis

[Former Member]

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

[Former Member]

Hi krishna,

if the data volume is low try to initialize again by deleting all data......

else if you know the selection criteria on which this data is coming wrong...then delete data based on that criteria.....

go with full repair request(on the same selection which u deleted data from providers)...

hope this will help you...........

Thanks,

Vijay.

[Former Member]

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.

[former_member182470]

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

[Former Member]

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.