Skip to Content
0

EPM Running Allocation Package for specific DIMENSION members

Nov 27, 2016 at 03:25 PM

104

avatar image
Former Member

Hello experts,

I have an allocation package in EPM excel file for calculation . In my excel files i am filtering some of my COSTCENTER members according to their properties (such as i have created DEPARTMENT_INFO property in my COSTCENTER dimension and the members will be divided in my excel files according to their DEPARTMENT_INFO properties.)

I have been wondering if there is a way to run allocation package for only determined COSTCENTER members which are listed inside my excel file.

By the way...SELECTINPUT function isn't working for my case in my allocation package , because calculation will be running for a lot of COSTCENTER members for each time. I have added screenshots to explain better what i'm trying to attain...

picture3.png

picture2.png

Regards

Selin

picture2.png (38.2 kB)
picture3.png (43.2 kB)
10 |10000 characters needed characters left characters exceeded

Your question primary tag has to be SAP BusinessObjects Planning and Consolidation, version for SAP NetWeaver

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

2 Answers

Vadim Kalinin Nov 27, 2016 at 08:51 PM
0

Sorry, but your explanation is absolutely not clear! Try to explain once again!

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

Vadim,

I have edited my question , tried to explain better..

Regards

Selin

0
Vadim Kalinin Nov 28, 2016 at 08:23 AM
0

"I have been wondering if there is a way to run allocation package for only determined COSTCENTER members which are listed inside my excel file." - Still not 100% clear, but if you want to pass some members from Excel sheet to DM package you can use VBA: https://blogs.sap.com/2013/01/10/how-to-deal-with-bpc-data-manager-packages-programmatically/

Better article is lost: https://archive.sap.com/documents/docs/DOC-32636

You can ask moderators to recover it...

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