Export data from a cube or view on a modeling workbench

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

To export data from a cube, right-click the cube on the modeling workbench Databases tree, then click Export data.

To export data from a view, right-click the view on the modeling workbench Databases tree, then click Import/Export > Export data.

Export data option for a view

When you export data, you can set options that determine:

  • which set and/or members to include in the export
  • a range of numeric or string values to include in the export
  • whether consolidated, rule-derived, or zero value are included in the export