Export Master Data to a File Stored in File Service

You can define a Data Manager package to export master data (dimension members) from a dimension into a file stored on the File Service using the /CPMB/EXPORT_MD_TO_FILE process chain.

Activities

Create a Data Manager package by using the corresponding process chains (see Package Usage).
Run the Data Manager package as follows:
1. Log on to the Planning and Consolidation Office module.
2. On the action pane, choose Manage data Run a package .
3. Choose the package created in step 1 and choose Run.
4. Select the measures.
5. Select the source dimension.
6. Select the members.
7. Choose the transformation file.
8. Create the output file, then choose Next.
9. Choose Yes if other application data will be added, then choose Next.
  
  Note
  
  Other application information includes application set, application, user name, and time stamp.
  End of the note.
10. Choose Next.
11. Choose one of the following options:
  - Run now
  - Schedule
  - Run now & schedule
12. Choose Finish.

You can change the default package instructions (see Modifying the Dynamic Script of a Package).

Dynamic script task parameters

Task	Parameter	Default Value	Description
/CPMB/APPL_MD_SOURCE	SELECTION		Dimension members
/CPMB/APPL_MD_SOURCE	SPACKAGE_SIZE	40.000	Package size
/CPMB/EXPORT_MD_CONVERT	SAPP	%APP%	Application name
/CPMB/EXPORT_MD_CONVERT	SAPPSET	%APPSET%	Application set name
/CPMB/EXPORT_MD_CONVERT	SPACKAGE_SIZE	40.000	Package size
/CPMB/EXPORT_MD_CONVERT	SUSER	%USER%	User name
/CPMB/EXPORT_MD_CONVERT	TRANSFORMATIONFILEPATH		Transformation file
/CPMB/FILE_TARGET	ADDITIONALINFO		Additional information that is passed to the export file: 1 = YES 0 = NO
/CPMB/FILE_TARGET	FULLFILENAME		Full file name
/CPMB/FILE_TARGET	OUTPUTHEADER		Include header information 1 = YES 2 = NO
/CPMB/FILE_TARGET	SPACKAGE_SIZE	40.000	Package size

Example Example

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

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

PROMPT(OUTFILE,,"Please enter an output file",Data files (*.txt)|*.txt|All files(*.*)|*.*)

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

INFO(%TEMPNO1%,%INCREASENO%)

INFO(%TEMPNO2%,%INCREASENO%)

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

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/FILE_TARGET,INPUTNO,%TEMPNO2%) TASK(/CPMB/FILE_TARGET,FULLFILENAME,%FILE%) TASK(/CPMB/FILE_TARGET,ADDITIONALINFO,%ADDITIONINFO%)

End of the example.

Any software coding and/or code lines / strings ("Code") included in this documentation are only examples and are not intended to be used in a productive system environment. The Code is only intended to better explain and visualize the syntax and phrasing rules of certain coding. SAP does not warrant the correctness and completeness of the Code given herein, and SAP shall not be liable for errors or damages caused by the usage of the Code, except if such damages were caused by SAP intentionally or by its gross negligence.