Skip to Content
0

Hierarchy Update - Not Overwrite

Dec 15, 2016 at 01:34 PM

280

avatar image

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?

10 |10000 characters needed characters left characters exceeded

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.

0

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.

0

"No time" to provide ideas!

0

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.

0

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

0

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???

0
Show more comments
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Andrey Leskiv Dec 15, 2016 at 05:39 PM
0

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


Show 1 Share
10 |10000 characters needed characters left characters exceeded

Still tag is not corrected...

And what about your BPC and BW versions and SP?

0
Andrey Leskiv Dec 15, 2016 at 08:34 PM
0

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

Show 10 Share
10 |10000 characters needed characters left characters exceeded

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?

0

Hello,

The BW version is listed above -

BW version is 7.4 (740) SP 12

Is that what you are asking?
0

I am asking not about BW but about BPC SP!

0

My understanding is that it is 740 SP12

Or

810 - I think its 810

0

"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/

0

SP 007 with version 810

0

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

0

It won't let me change the tag,

0

Finally updated the TAG

0
Show more comments
Priyanka Jagtap Dec 16, 2016 at 07:31 AM
0

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

Show 4 Share
10 |10000 characters needed characters left characters exceeded

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

0

Whats your point? Is the document not valid??

0

Do you remember the MBRSEQ in BPC 7.5?

0

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