Import master data from Mdm to BPC 10.0

[former_member414993]

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

[Private_Member_141848 · Accepted solution]

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.

[former_member414993 · Accepted solution]

Thanks, program UJA_REFRESH_DIM_CACHE helped!