Export a dimension or hierarchy

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 in a book Databases tree, then click Export members.

Export members option on the Databases tree

You can also click the Export members icon in 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
  • 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).