Skip to Content
avatar image
Former Member

Button to run DM script

Dear SAP BPC experts,

I would like to add a press button to the data entry layout which starts certain script in the data manager. The script does not have to be able to read the parameters of the context. My questions are the followings:

The excel sheet has to be ready for allowing macros and this has to be defined as macro friendly excel sheet as we save the excel sheet / template?

Which VBA function has to be used that can start reading the macro?

This had been VBA function MNU_eDATA_SELECTPACKAGE in SAP BPC 7.5 what is the relevant VBA function for this in SAP BPC 10.1?

Thanks for your help,

Tamas

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Apr 19, 2017 at 01:34 PM
    Add comment
    10|10000 characters needed characters exceeded

    • Sorry, but what you are doing???

      epm.DataManagerRunPackage "packageId", "groupId", "teamId"

      packageId= Name of the package

      groupId=Name of the package group like: "Data Management"

      teamId=For Company - empty!

      Don't forget to add FPMXLClient in the VBA->Tools->References Menu!

  • avatar image
    Former Member
    Apr 28, 2017 at 11:00 AM

    Yes this has worked fine thanks for this Vadim.

    Add comment
    10|10000 characters needed characters exceeded