on 09-01-2016 9:35 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.