Selecting Members

Dimension Browser, an interface for selecting members and refining database queries, is used with the new document wizard, Cube Navigator dialog box, Information panel, or on its own.

The Dimension Browser presents dimensions as a node tree in the Browse frame. You must select dimension members from this Browse frame and move them to the Selections frame.

Members can be selected individually, by familial relationships, by data-source-specific option, or from predefined selection lists.

  To access Dimension Browser:

  • Right-click a member label on a data object, and select Browse.

  • In the view pane Information panel, select a dimension name.

  • Click the Data Layout button, and double-click a dimension name.

  • In the new document wizard, double-click a dimension name.

  To expand or collapse hierarchies in Dimension Browser, click the plus sign (+) or minus sign (-) nodes, or double-click a dimension name.

  To select a member, right-click the member, and select Select Member.

The member name is displayed in the Selections list. You cannot select the database connection name at the top of the node tree.

  To select a member dynamically in Dimension Browser, right-click the member, and select an advanced member selection method from the list.

See Advanced Member Selection.

  To remove a member from the Selections list, perform an action:

  • Right-click the member in the Browse or Selections list, and deselect the selected selection method.

  • Select the member in the Selections list, and click Remove.

  To remove all members from the Selection list, click Remove All.

  To preview members returned by advanced member selection, before you quit Dimension Browser, click Preview.

  To set dimension label mode, select a Dimension Labels option.

  • Use Default

  • Descriptions—the current alias table

  • IDs— the unique ID label

  • Both— ID label and description (used in Financial Management)

The label displayed by description is drawn from the alias table specified by the active user’s database preferences. You can set an alias table for each Active Preferences user ID or group ID.

Users can specify label mode in specific dimensions, using Dimension Browser.