Adding a value

You can add a value from a database to a Word document.

  1. Click where to add a value in the document.
  2. Click One Value.
  3. Select a data connection.
  4. Select a cube.
  5. Select a hierarchy.
    To search for a hierarchy, click the Search icon above the hierarchy list and specify all or part of a search term in the search box. If a search returns hierarchies that belong to the same dimension as the searched hierarchy but which do not match your search term, the Show button is displayed. Click the button to view those hierarchies.
    By default, the default element of the selected hierarchy is selected.
  6. To change the element, select the non-default option. To expand the elements panel, click the arrow next to the hierarchy. Select one or more elements.
    To select all visible elements, expand the elements and select the check box in the list header. You can also click the Search icon to look for specific elements.
  7. Optionally, to change the displayed element attribute, click the Display Format icon in the elements panel. By default, the element caption is selected.
    In the elements panel, you can also click the Element Visibility icon to select which elements to show.
  8. Click Add.