Export a dimension or hierarchy from a modeling workbench

You can export a dimension or hierarchy to a .csv file. The exported file is saved to your local Downloads directory.

To export, right-click the dimension or hierarchy on the modeling workbench Databases tree, then click Export members.

Export members option on the Databases tree

You can also click the Export members icon on the dimension editor to export a dimension.

When you export a dimension or hierarchy, the resulting .csv file includes the following information about each member:

  • name
  • parent/child relationship
  • type
  • weight
  • any defined attribute names and values

    Attribute names are prefixed with either ATTR_N or ATTR_S when they are exported, depending on the attribute type (numeric or string, respectively).