Exporting a Model to a File

You can export a model to a CSV file once or on a recurring schedule.

Context

Note
Both Planning and Analytics models can be exported to a flat CSV file. However, you cannot export an Analytics model based on a HANA view.
Note
Only data imported to SAP Analytics Cloud can be exported to a CSV file. When using live data, such as from a HANA source, the live data is not exported.

Procedure

  1. Select Start of the navigation path (Main Menu) Next navigation step  Browse Next navigation step  FilesEnd of the navigation path.
  2. Open the model you want to export.
  3. Switch to the Data Management screen.
  4. Select Start of the navigation path Next navigation step Export Model As File Next navigation step Create New ScheduleEnd of the navigation path.

    The Export Model As File dialog is displayed.

    Note
    If data export has been restricted for this model, you won't be able to proceed. For details, see Exporting Data.
  5. Choose whether you want to export data to a file on your local system, or to a file server, and then select a folder location to save the exported model to.

    If you don't see the option to export data to a file server, see Allowing Data Import and Model Export with a File Server.

  6. Set the maximum number of rows per file.
    If the number of rows in your model exceeds the maximum number per file, the data will be split into multiple files during the export process.
  7. If you want Excel to ignore the regional CSV separator setting, and use the separators within the exported CSV file, select the Add separator information for use in Excel check box.
    Excel uses regional settings to determine which separator it recognizes for CSV files. For example, in regions where a comma is used as a decimal separator, the CSV separator is typically a semicolon. If you're exporting your model to a CSV file that might be used in different regions with different standard CSV separators, you should select this check box to ensure that Excel will recognize the separators within the CSV file.
  8. If you want to export only leaf members, select the Export leaf account members only check box.
  9. If you want to export only booked data, so that you don't have to delete empty rows, select the Export booked data only check box.
  10. In the Select Data section, select the dimensions to export.
    Note
    For Fact Data Only export, you can reorder the CSV output columns by clearing the Dimensions check box, and then selecting columns in the order you want.
    1. Optional: Choose to filter on a dimension. This allows you to reduce the number of returned records.
      By default, dimension members you select are the ones included in the results. Choose Exclude selected members to filter out selected members. For example, assume there are four quarters Q1, Q2, Q3, and Q4 in your Date dimension for a particular year, and you select Q1 and Q2 in the filter:
      • By default, Q1 and Q2 are included, whereas Q3 and Q4 are excluded.
      • Choosing Exclude selected members will exclude Q1 and Q2, and include Q3 and Q4.

      Date dimensions allow you to Filter by Member or Filter by Range. You can add multiple ranges to your filter to specify the exact time periods you want to include. Note that Month is the lowest level of a Date dimension that can be exported. A time line visualizes the complete range of your filters.

    2. Optional: Choose (Columns) to select individual columns you want included.
      You can rename dimensions, and the dimension name is concatenated to the name of the column heading after exporting. Models are exported as a flat file, with each selected dimension column listed one after another. For example, a dimension named Product with columns named ID, ParentID, and Description is exported as follows:
      ProductID ProductParentID ProductDescription
      PRD001 HPRD0001 Athletic Shirts
      PRD002 HPRD0002 Tennis Shoes
    3. Optional: Select Use hierarchy levels from, and then choose a dimension whose hierarchy information you want to see in the exported results.
      A column is exported that includes the parent ID and shows the parent-child relationships between members of that dimension.
  11. In the Scheduling section, choose when you want to export your model.
    • Choose Export Now if you want to export only once now.
    • Choose Scheduling Recurrence to define a recurring export schedule.
    When setting up a recurrence, create a name for your schedule and determine how frequently you want the export to occur.
  12. Choose Schedule to save your export schedule or Export if you chose to export now.

Results

View all your export schedules by choosing Start of the navigation path Next navigation step Export Model As File Next navigation step Manage Existing SchedulesEnd of the navigation path. From the Scheduled Exports dialog, you can see the time and status of the last scheduled export, as well as delete existing schedules you no longer need:

Note
If you share a model with other users, those users can access your export jobs and schedules. If you share the model with View access, other users can view, but not edit or run the export jobs and schedules. If you share the model with Full Control access, other users can edit and run the export jobs and schedules.

Successfully exported models are found in the Files area under the folder you specified. From the () Main Menu, select Start of the navigation path Browse Next navigation step  FilesEnd of the navigation path.

Next Steps

The export limit depends on the type of data being exported. If calculations aren't included in the export job, the default export limit is 6 million rows.

If account calculations are included, the default limit is 1 million rows, but think of this as 1 million rows of calculation input.

Tip

For example, if your export consists entirely of calculations, with each output cell being the sum of four other cells, the maximum number of rows that could be exported would be 1 million divided by 4, which is 250,000 rows.

Or, if your query is divided into months (or years), and you selected five months (or years), the maximum number of rows that could be exported would be 200,000 rows.

The actual result can vary depending on the model and filter complexity.

If you think your export will be bigger than this, try filtering out some data before you begin. The export can take a long time, but you can use other SAP Analytics Cloud features while you're waiting.