Skip to Content
avatar image
Former Member

update existing data inside “InfoCube” not Delete & Insert

Dears,

I have a case which I need to update existing data inside “InfoCube”

Ex:

I have a cube with 10 rows and an “infoobject” “ZResponsiblePerson”.

The first 5 rows the “ZResponsiblePerson” = “Ramzy”

The second 5 rows the “ZResponsiblePerson” = “Hani”

Now this infoobject is updated due to master data update and “Hani” was changed to “Sherif”

Now I want to update the existing 5 rows for “Hani” to be “Sherif”.

If reality they are around 40 Million rows so I cannot delete & reload again.

Thanks,

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jul 31, 2017 at 08:47 AM

    Remodeling might help wherein you can add a new charecteristic which will be updated with the new values but even then you will first have to copy data to a backup cube. https://blogs.sap.com/2013/07/30/remodeling-process-in-bi/

    Add comment
    10|10000 characters needed characters exceeded