cancel
Showing results for 
Search instead for 
Did you mean: 

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

0 Kudos

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.

Regards,

Marthinus Viljoen

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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.

Regards,

JP

0 Kudos

Thank you JP

The fact that a DMP cannot download a file to local Computer or Shared Network Location is what I was looking for as an answer (or if it were possible; a how-to sample ).

regards,

Marthinus

William_Yu
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi Marthinus,

  Please understand that, data manager package is triggered and executed on the server side, which does not have any access to any local pc or shared folder.

  If you want to download to your pc you could try to use 'Export to CSV' in the master data maintenance screen on web admin client.

Best regards,  William

Former Member
0 Kudos

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

EPM.DataManagerOpenFileDownloadDialog

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 backend......download 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.

Regards,

JP

Answers (0)