 Export Data process

Use the Export Data process to extract data from a model and save it as an external text file, or SQL Server or MySQL database table.

The various options control how data appears in the external file; you can choose to turn the header display on or off, display members with names or keys, reverse signs for debits or credits, and select which dimensions and members appear in rows and in columns.

General tab

• Description: Optional. Up to 250 characters.

• Source: Identify the data source by selecting the cube.

• Target

  • File: Type a file name or, to select a process file A data file used in the various import and export automated processes in Process Manager. A process file contains data or dimensions and is Excel (.xls or .xlsx) or text (.txt or .csv) format., click .

      Tip:  The default file type is .txt; to specify a comma file instead, type a .csv file extension.

      Best Practice:  If your data includes dimension member names that contain commas (,) your target file should be .txt instead of .csv (the latter uses commas as its data delimiter and this will cause data errors). With a .txt file, the Delimiter option appears and you can choose a delimiter other than commas.

Layout tab

• Select the members that you want to export.
• You can drag dimensions between Columns and Rows.

Member Display tab

• Display Option: For each dimension you can choose whether its members appear as keys or names.

• Reverse sign for: Optionally, you can reverse the data signs for debits or credits.

Data tab

• Round to the following decimal place: Optionally, you can specify the precision for exported numeric values:

  • 0: round to the nearest whole number.
  • 1, 2, 3, and so on.: round to that many decimal places.
  • If you do not want rounding, leave the box empty.

• Reverse sign for: Optionally, you can reverse the data signs for debits or credits.