cancel
Showing results for 
Search instead for 
Did you mean: 

Import master data from Mdm to BPC 10.0

0 Kudos
638

Hello!

We have a task to upload master data from Mdm to BPC 10.0 on daily basis.

We are uploading masterdata from MDM to BW Info-object (MDM --> PI --> ABAP Proxy --> Data source --> DSO --> Info Object) and then using standart BPC DataManager package to import master data from info object.

Attributes and texts upload are ok, but we are facing problems with updating hierarchies. As a test we tried to change hierachy of BW info object (this info object was generated automatically by bpc on bw side when we add new dimension).We use fields NODEID, IOBJNM, NODENAME, PARENTID to define hierarchy structure and from the BW side it's kinda of work - parents and children are displaying correctly. But if we check the same dimension via web bpc console - nothing changes in hierarchies.

What extra fields should we provide to change hierarchy from BW side and see the same changes in bpc dimension through bpc web console?

If you know better options how to upload master data in our scenario, please share

Accepted Solutions (1)

Accepted Solutions (1)

Private_Member_141848
Product and Topic Expert
Product and Topic Expert

It seems you are changing the hierarchy of BPC dimension via BW API directly or from BW side, and noticed BPC side is not updating to the same.

If my understanding is correct, then you can try running program UJA_REFRESH_DIM_CACHE on corresponding BPC dimension after hierarchy change on BW side. This should sync the hierarchy data of BW side to BPC table.

However be informed, that BPC has some special restriction to hierarchy comparing to BW hierarchy maintenance. Please make sure your hierarchy change is valid in BPC side.

0 Kudos

Thanks, program UJA_REFRESH_DIM_CACHE helped!

Answers (0)