Skip to Content
0

update existing data inside “InfoCube” not Delete & Insert

Dec 13, 2016 at 07:44 AM

29

avatar image
Former Member

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,

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Shwetha Bangera Jul 31, 2017 at 08:47 AM
0

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/

Share
10 |10000 characters needed characters left characters exceeded