Hierarchy Update - Not Overwrite

[Former Member]

In BPC 10.1 we have our data manager package for company and account hierarchy update based on what the backend system shows as the hierarchy. Also, our business users like to update the hierarchy on the frontend (in BPC 10.1 web interface) on how they want to see the members displayed. They move some of the members around in the hierarchy based on how they want to see it. However, the next month they import master data, the data manager package overwrites the changes they made even though the package is configured to 'Update' and not 'Overwrite'.

In BPC 7.5 the system did not overwrite any changes to the member hierarchy that the users made on the frontend.

We are looking to see if BPC 10.1 treats 'Update' differently from BPC 7.5? If so, how can we configure BPC 10.1 to 'Update' and not overwrite even with the update option selected?

[former_member186338]

First - incorrect primary tag!

Has to be: SAP BusinessObjects Planning and Consolidation, version for SAP NetWeaver

or Microsoft... The question is not about EPM Add-In for Excel

Second - please provide full information about package including screenshots.

[Former Member]

Not minding that I can't get the correct TAG (not a joke - no time for that). However, any ideas around my issue? Tested out against BPC 10.1 EPM SP27 and still got the same result.

[former_member186338]

"No time" to provide ideas!

[Former Member]

Tried to fix tag and got an internal error.

Vadim,

If you are unable to answer my question please inform me of that since I no longer wish to waste both of our time discussing a TAG that I cannot change.

[Former Member]

It seems that you would rather spend time pursing the TAG instead of providing insight into my initial question.

[former_member186338]

Sorry, if some person is writing that he has no time to correct the question assigning the meaningful tag or unable to do it, why I have to spend time to explain you what is the difference between BPC 7.5 with special property for sorting and BPC 10/10.1 where hierarchy sorting is done by hierarchy ID's???

[Former Member]

The comment about 'no time' is about not having the timing for jokes since you were asking if the incorrect tag was some sort of a joke. It is def not a joke and upon trying to fix the tag SAP gave me an internal error.

[former_member186338]

Everybody can correct the tag in the question! Try another browser or ask question in "Using SAP.com" It's absolutely trivial thing.

[Former Member]

Hi Andrey,

As per this document PG.NO. 17.

http://www.sap.com/documents/2015/08/26ef2552-557c-0010-82c7-eda71af511fa.html

Section BPC Data Manager – Run Package

In contrast to the BW master data package which can be run in update or overwrite mode, the BW hierarchy import package always works in overwrite mode. Be advised it also clears any other existing hierarchies which are not specified in the Data Manager package Set Selection filter and Conversion File mapping. So if you need to import more than one BW hierarchy from the same source InfoObject into BPC, it is necessary to transfer these in the same Data Manager package execution step rather than in separate execution runs to avoid clearing the other hierarchies.

Workarounds are suggested in the documents. I guess this behaviour might not have been changed in 10 & 10.1.

Regards,

JP

[former_member186338]

It's just opposite to the statement of topic author that for BPC 7.5 the member order was preserved with update

[Former Member]

Whats your point? Is the document not valid??

[former_member186338]

Do you remember the MBRSEQ in BPC 7.5?

[Former Member]

Hello,

My issue is that BPC is not updating the hierarchy but overwriting even if I moved some members around on the frontend in BPC. My DM package I put in 'update' but it still overwrites what I have completed on the frontend.

[Former Member]

Anyone found solution to this problem yet? We are facing the same issue, the BW hierarchy load is overwriting sort order changed through BPC frontend. We tried adding parameter DM_KEEP_SRC_SEQ=Y at global, environment and model levels (through SPRO), but didn't help retain the hierarchy sort order.

Our version: BW 7.5 SP07 on HANA 2.0, BPC 10.1, EPM 30

The link shared by member JP above doesn't work either.

Thanks!

[former_member186338]

I do not answer in the closed questions! Please open a new one!

[Former Member]

Unfortunately it won't allow me to change the tag - unless you know of a way...?

BW version is 7.4 (740) SP 12

EPM is SP 23.2

[former_member186338]

What about core BPC SP?

"Unfortunately it won't allow me to change the tag - unless you know of a way...?" Just press action button on the right of your question, select edit and change the primary tag to "SAP BusinessObjects Planning and Consolidation, version for SAP NetWeaver" What's the issue?

[Former Member]

Hello,

The BW version is listed above -

BW version is 7.4 (740) SP 12

Is that what you are asking?

[former_member186338]

I am asking not about BW but about BPC SP!

[Former Member]

My understanding is that it is 740 SP12

Or

810 - I think its 810

[former_member186338]

"My understanding is that it is 740 SP12" - incorrect understanding...

"810 - I think its 810" - it's a version, but not SP!

Please look here how to find BPC version and SP:

https://blogs.sap.com/2014/01/31/how-to-ask-questions-about-script-logic-issues/

[former_member186338]

And the tag is still not changed! Is it so hard?

[Former Member]

It won't let me change the tag,

[Former Member]

SP 007 with version 810

[Former Member]

Finally updated the TAG

[former_member186338]

To:SAP BusinessObjects Planning and Consolidation for Public Sector, option for SAP NetWeaver

Is it a bad joke?

[Former Member]

dm-package-selection.png

Vadim,

I was having a hard time with this new web interface from SAP - thanks for providing correct tag.

In the screenshot you can see the selection I have made to only 'update' my hierarchy and not overwrite the changes made to the hierarchy on the frontend in BPC 10.1. Unfortunately, this package continues to overwrite even with the 'update' selection. hierarchy-selection.pngtransformation-file.png

[former_member186338]

Still tag is not corrected...

And what about your BPC and BW versions and SP?