SAP BPC 10.1 NW - Export Master Data

[Former Member]

Hello,

I have a requirement to export the Master Data to Application Server for which I had used standard Data Manager Package "EXPORT_MD_TO_APPL"

But the prompts have to be made hardcoded and I tried all ways but unable to hardcode.

Can you please help on below Data Manager Package

Dimension - MAR_ACCOUNT

Members - <all>

Output application file path - \usr\BPC\MAR_ACCOUNT.csv

PROMPT(DIMENSIONMEMBER, %DIMENSIONMEMBERS%, "Please select dimension", "Please select members", %DIMS%,0) PROMPT(TRANSFORMATION,%TRANSFORMATION%,"Transformation file:",,,Import.xls) PROMPT(TEXT,%FILE%,"Please enter an output application file",) PROMPT(RADIOBUTTON,%ADDITIONINFO%,"Add other information(Environment,Model,User,Time)?",1,{"Yes","No"},{"1","0"}) INFO(%TEMPNO1%,%INCREASENO%) INFO(%TEMPNO2%,%INCREASENO%) INFO(%DIMENSIONMEMBERS_DATEFROM%,) INFO(%DIMENSIONMEMBERS_KEYDATE%,) TASK(/CPMB/APPL_MD_SOURCE,SELECTION,%DIMENSIONMEMBERS%) TASK(/CPMB/APPL_MD_SOURCE,OUTPUTNO,%TEMPNO1%) TASK(/CPMB/APPL_MD_SOURCE,DATEFROM,%DIMENSIONMEMBERS_DATEFROM%) TASK(/CPMB/APPL_MD_SOURCE,KEYDATE,%DIMENSIONMEMBERS_KEYDATE%) TASK(/CPMB/EXPORT_MD_CONVERT,INPUTNO,%TEMPNO1%) TASK(/CPMB/EXPORT_MD_CONVERT,TRANSFORMATIONFILEPATH,%TRANSFORMATION%) TASK(/CPMB/EXPORT_MD_CONVERT,SUSER,%USER%) TASK(/CPMB/EXPORT_MD_CONVERT,SAPPSET,%APPSET%) TASK(/CPMB/EXPORT_MD_CONVERT,SAPP,%APP%) TASK(/CPMB/EXPORT_MD_CONVERT,OUTPUTNO,%TEMPNO2%) TASK(/CPMB/EXPORT_MD_CONVERT,KEYDATE,%DIMENSIONMEMBERS_KEYDATE%) TASK(/CPMB/APPL_SERVER_TARGET,INPUTNO,%TEMPNO2%) TASK(/CPMB/APPL_SERVER_TARGET,FULLFILENAME,%FILE%)) TASK(/CPMB/APPL_SERVER_TARGET,ADDITIONALINFO,%ADDITIONINFO%))

[former_member186338]

If you want an answer, please spend some time to properly format your question - preserving line breaks. Use code button to publish script code.

[Former Member]

Hello Vadim,

Sorry for that. Below is the logic I tried but it fails stating "Task name MASTER DATA SOURCE:Invalidate selection condition". Even putting the master data name in double quotes I tried but same issue. Can you please guide on this to make the code static

'PROMPT(DIMENSIONMEMBER, %DIMENSIONMEMBERS%, "Please select dimension", "Please select members", %DIMS%,0)

PROMPT(TRANSFORMATION,%TRANSFORMATION%,"Transformation file:",,,Import.xls)

PROMPT(TEXT,%FILE%,"Please enter an output application file",)

PROMPT(RADIOBUTTON,%ADDITIONINFO%,"Add other information(Environment,Model,User,Time)?",1,{"Yes","No"},{"1","0"})

INFO(%TEMPNO1%,%INCREASENO%)

INFO(%TEMPNO2%,%INCREASENO%)

INFO(%DIMENSIONMEMBERS%,MAR_ACCOUNT)

INFO(%DIMENSIONMEMBERS_DATEFROM%,)

INFO(%DIMENSIONMEMBERS_KEYDATE%,)

TASK(/CPMB/APPL_MD_SOURCE,SELECTION,%DIMENSIONMEMBERS%)

TASK(/CPMB/APPL_MD_SOURCE,OUTPUTNO,%TEMPNO1%)

TASK(/CPMB/APPL_MD_SOURCE,DATEFROM,%DIMENSIONMEMBERS_DATEFROM%)

TASK(/CPMB/APPL_MD_SOURCE,KEYDATE,%DIMENSIONMEMBERS_KEYDATE%)

TASK(/CPMB/EXPORT_MD_CONVERT,INPUTNO,%TEMPNO1%)

TASK(/CPMB/EXPORT_MD_CONVERT,TRANSFORMATIONFILEPATH,%TRANSFORMATION%)

TASK(/CPMB/EXPORT_MD_CONVERT,SUSER,%USER%)

TASK(/CPMB/EXPORT_MD_CONVERT,SAPPSET,%APPSET%)

TASK(/CPMB/EXPORT_MD_CONVERT,SAPP,%APP%)

TASK(/CPMB/EXPORT_MD_CONVERT,OUTPUTNO,%TEMPNO2%)

TASK(/CPMB/EXPORT_MD_CONVERT,KEYDATE,%DIMENSIONMEMBERS_KEYDATE%)

TASK(/CPMB/APPL_SERVER_TARGET,INPUTNO,%TEMPNO2%)

TASK(/CPMB/APPL_SERVER_TARGET,FULLFILENAME,%FILE%))

TASK(/CPMB/APPL_SERVER_TARGET,ADDITIONALINFO,%ADDITIONINFO%))

[former_member186338 · Accepted solution]

You have to use special syntax for: %DIMENSIONMEMBERS%. Look on the log!

The correct script will be:

INFO(%DIMENSIONMEMBERS%,/%APPSET%/%APP%/PRIVATEPUBLICATIONS/%USER%/TempFiles/FROM.TMP@@@SAVE@@@@@@EXPAND@@@|DIMENSION:MAR_ACCOUNT|)
INFO(%DIMENSIONMEMBERS_DATEFROM%,)
INFO(%DIMENSIONMEMBERS_KEYDATE%,)
INFO(%TRANSFORMATION%,\ROOT\WEBFOLDERS\%APPSET%\%APP%\DATAMANAGER\TRANSFORMATIONFILES\TransformFileName.xls)
INFO(%FILE%,\usr\BPC\MAR_ACCOUNT.csv)
INFO(%ADDITIONINFO%,0)
INFO(%TEMPNO1%,%INCREASENO%)
INFO(%TEMPNO2%,%INCREASENO%)
TASK(/CPMB/APPL_MD_SOURCE,SELECTION,%DIMENSIONMEMBERS%)
TASK(/CPMB/APPL_MD_SOURCE,OUTPUTNO,%TEMPNO1%)
TASK(/CPMB/APPL_MD_SOURCE,DATEFROM,%DIMENSIONMEMBERS_DATEFROM%)
TASK(/CPMB/APPL_MD_SOURCE,KEYDATE,%DIMENSIONMEMBERS_KEYDATE%)
TASK(/CPMB/EXPORT_MD_CONVERT,INPUTNO,%TEMPNO1%)
TASK(/CPMB/EXPORT_MD_CONVERT,TRANSFORMATIONFILEPATH,%TRANSFORMATION%)
TASK(/CPMB/EXPORT_MD_CONVERT,SUSER,%USER%)
TASK(/CPMB/EXPORT_MD_CONVERT,SAPPSET,%APPSET%)
TASK(/CPMB/EXPORT_MD_CONVERT,SAPP,%APP%)
TASK(/CPMB/EXPORT_MD_CONVERT,OUTPUTNO,%TEMPNO2%)
TASK(/CPMB/EXPORT_MD_CONVERT,KEYDATE,%DIMENSIONMEMBERS_KEYDATE%)
TASK(/CPMB/APPL_SERVER_TARGET,INPUTNO,%TEMPNO2%)
TASK(/CPMB/APPL_SERVER_TARGET,FULLFILENAME,%FILE%)
TASK(/CPMB/APPL_SERVER_TARGET,ADDITIONALINFO,%ADDITIONINFO%)

Replace TransformFileName with the name of your transformation file!

[Former Member]

Thanks Vadim it worked