Skip to Content

Data Manager Package to download multiple master-data files without prompts

Hi Gurus

SAP NetWeaver 7.40

SAP BPC 10.1

EPM Add-in for Office 10.0 SP25

I have a customer that wishes to have a Data Manager Package which would allow him to download a set selection of master-data TXT files to a fixed location on his computer or shared network location.

Is it possible to write a set of Data Manager Packages and then link them together with a data manager package link to allow the user to submit one package-link to obtain 20 (possibly) files and store it in a pre-determined location?

If so can you provide me with a sample Data Manager Package that does this?

Thanking you in advance.


Marthinus Viljoen

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Sep 02, 2016 at 10:28 AM

    Hi Marthinus,

    I am confused as to what you require exactly.....whether you want to know the data manager package through which we can download data or the downloading of master data directly to local desktop......

    For downloading master data you can use DMP /CPMB/EXPORT_MD_TO_FILE which will download the master data as per selections to flat file on BPC server. Then from BPC server you can download it to your local desktop or shared network location. The downloading to local desktop cant be done through DMP. You can then create DMP Link with this package and set the prompts for 20 different packages as different tasks.



    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Marthinus Viljoen

      Hi Marthinus,

      Standard functionality cant help to download directly to local desktop! But there are several options by which you can achieve the same. For e.g

      1.) Write a macro code for button to download and execute 2 steps: DMP to download on server and then from server to local desktop.But ask the user to keep a gap of 1-2mins before downloading it to local desktop in case you have a very big volume of master data. Below is working code:

      Option Explicit

      Dim EPM As New FPMXLClient.EPMAddInAutomation

      Sub Button1_Click()

      EPM.DataManagerRunPackage "Export Master Data", "Data Management", ""

      ' To download the file to local desktop


      End Sub

      2.) You can create Master data reports! Using EPM create reports to show the master data of a dimension. Create a report first and then Use EPMMemberProperty function. This way, user can just open the report Refresh it and the "Save As" on the local desktop!

      3.) From BW the master data from BPC infoobjects. But this will be valid only if user has knowledge of BW.

      4.) As William suggested, Export to CSV option from Admin of dimensions. But in this the user will have to select the dimensions of only that particular model and then proceed further.



Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.