Macro for exporting data to a BPC Data File

[Former Member]

Hi,

My requirement is if in an Input Schedule, I can write a macro on a button click that takes the data from the input schedule cell range and exports it to a Data file at the BPC Data File path. Please note, while exporting, the data is to be overwritten and not appended, i.e. every time I export the Data file should be replaced with new data.

Does anyone have sample code for writing such a macro ?

Environment: SAP BPC 7.5 NW

Cheers,

Nitin

[former_member186338]

Hi Nitin,

In BPC NW 7.5 you have only MNU_eDATA_DATAUPLOAD, that will show the dialog box for the user to upload file...

But you can evaluate chain /CPMB/IMPORT_USING_FTP to import data from some FTP location. In this case you will be able to create button in Excel to generate text file and put it on this FTP server...

Vadim

[Former Member]

Hi Vladim,

The requirement is to allow the user to enter Account Type and Rate Type property values for certain nodes in the Dimension.

Since these values are not coming from BW, we need to maintain in conversion files while uploading the master data.

However, we need to do away with the manual maintenance of the conversion files and find a way to update these properties directly.

One way I thought was to create an Input Schedule (IS), the user enters the account no and rate/account type and clicks a button. This button

1. Exports this data to a Data File, and then a

2. Data manager package is called to import the data file.

Point 2 is doable, but im trying to figure out the step 1.

Since we do not have an FTP location hence won't be able to utilise your method.

Cheers,

Nitin

[former_member186338]

Hi Nitin,

Ups, you are talking about master data import (Input schedule term was confusing in this case). Unfortunately import from FTP is only for transactional data.

You can't automate step 1, the user will have manually select the created by VBA macro text file and upload it to server. MNU_eDATA_DATAUPLOAD will show standard dialog to upload the file.

May be you can use this document: http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/f08895ab-f152-2e10-7d8b-950a8e5eb...

Vadim

[Former Member]

Is there something like MNU_eDATA_DATAUPLOAD  which can help me ?

Cheers,

Nitin

[former_member186338]

Not helpful - user have to select file!