Skip to Content

EPM Running Allocation Package for specific DIMENSION members

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Nov 27, 2016 at 08:51 PM

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

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 28, 2016 at 08:23 AM

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

    Add comment
    10|10000 characters needed characters exceeded