MicroStrategy ONE

Import Hierarchical Attributes

To use hierarchy reporting, you must import a cube with hierarchical attributes. Each hierarchical attribute represents an entire hierarchy and all its levels. When importing data, the option to import a hierarchy as a hierarchical attribute is visible if you select MDX connections against the supported database. You can import a standalone cube or a local cube within a dashboard that has hierarchical attributes.

  1. Open a new or existing dashboard.
  2. Choose Add Data > New Data to import data. The Data Sources dialog opens.
  3. Click OLAP. The Import from Cubes dialog opens.
  4. In the MDX Connections pane on the left, select the name of the data source connection that contains the data to import. The cube catalog appears in the Browse Catalog pane.

    If you want to create a new data source connection, see How to Create a Data Source Connection to an OLAP (MDX Cube) Source.

  5. Click the expansion arrow to the left of the cube catalog to view the corresponding cubes.
  6. Drag a cube from the Browse Catalog pane, to the right pane, to add it to the import.
  7. Select the Import hierarchy as hierarchical attribute checkbox.
  8. Click Finish.

You can limit the hierarchical attribute elements users can access within your cube by creating security filters.

Use the VLDB property for MDX cell formatting to modify cell formatting for hierarchical attributes. See the Opening the VLDB Properties Editor and MDX Cell Formatting topics in the System Administration Help for more information.