Export data from a cube or view

You can export data from a cube or view to a .csv file. The exported file is saved to your local Downloads directory.

About this task

You can initiate a data export from several places on the modeling workbench Databases tree:

Database
Right-click a database, then click Import/Export > Export data.
Cubes node for a database
Right-click the Cubes node for a database, then click Export data.
Cube
Right-click a specific cube, then click Import/Export > Export data.
View
Right-click a specific view, then click Export data.

Procedure

  1. Start the data export from one of the available locations on the modeling workbench Databases tree.
  2. If necessary, select the Cube from which you want to export data. This is required only if you initiate an export from a database or from the Cubes node on a database.
  3. By default, the name for the exported .csv file is the same as the source cube. If you want to use a different name, enter it in the File name box. You do not need to include a file extension.
  4. Choose whether you want to export all cube/view data or want to refine the scope of the data that is exported.
    • Click Export to export all cube or view data, exclusive of consolidated values, rules-derived values, and zero/blank values.

      If you initiated data export from a database, Cubes node, or individual cube, all data from the source cube is exported.

      If you initiated data export from an individual view, only the data included in the source view is exported.

    • Click Next to set options that define the data that is exported.
  5. Optionally, select a View as the basis for the export.
    When you select a view, the Dimension elements grid updates to reflect the view configuration.
  6. Use any combination of the Hierarchy, Set, and Member menus to further define the scope of data to export for each dimension.
    For example, you can:
    • specify only a hierarchy to include all members of the hierarchy in the data export.
    • specify a hierarchy and set to include all members of the set in the data export.
    • specify a hierarchy, set, and single member to include only the selected member in the data export.
  7. If you want to filter the numeric values that are included in the export, click the Numeric values operator menu and select an expression. Enter the values that are required to evaluate the expression.
  8. If you want to filter the string values that are included in the export, click the String values operator menu and select an expression. Enter the values that are required to evaluate the expression.
  9. By default, an export does not include consolidated values, rules-derived values, or zero/blank values. If you want to include any of these types of values in an export, clear the check box next to the appropriate Skip option.
  10. Click Export.

    The exported data is saved in a .csv file in your browser's Downloads directory, using the name specified in step 3.