cancel
Showing results for 
Search instead for 
Did you mean: 

Hierarchy Update - Not Overwrite

Former Member
0 Kudos

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
Active Contributor
0 Kudos

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
0 Kudos

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
Active Contributor
0 Kudos

"No time" to provide ideas!

Former Member
0 Kudos

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
0 Kudos

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

former_member186338
Active Contributor
0 Kudos

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
0 Kudos

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
Active Contributor
0 Kudos

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

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

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
Active Contributor
0 Kudos

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

Former Member
0 Kudos

Whats your point? Is the document not valid??

former_member186338
Active Contributor
0 Kudos

Do you remember the MBRSEQ in BPC 7.5?

Former Member
0 Kudos

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.

0 Kudos

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
Active Contributor
0 Kudos

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

Former Member
0 Kudos

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
Active Contributor
0 Kudos

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
0 Kudos

Hello,

The BW version is listed above -

BW version is 7.4 (740) SP 12

Is that what you are asking?
former_member186338
Active Contributor
0 Kudos

I am asking not about BW but about BPC SP!

Former Member
0 Kudos

My understanding is that it is 740 SP12

Or

810 - I think its 810

former_member186338
Active Contributor
0 Kudos

"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
Active Contributor
0 Kudos

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

Former Member
0 Kudos

It won't let me change the tag,

Former Member
0 Kudos

SP 007 with version 810

Former Member
0 Kudos

Finally updated the TAG

former_member186338
Active Contributor
0 Kudos

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

Is it a bad joke?

Former Member
0 Kudos

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
Active Contributor
0 Kudos

Still tag is not corrected...

And what about your BPC and BW versions and SP?