Select a member or set by typing its name in an exploration view

The exploration view now offers a quick way to select a member or set. You can open an input box from a dimension tile in the Context or Bench area to enter a member name or Member ID and update the view with that member. Similarly, you can open the input box from a tile in the Row or Column area and type the set name to update the view with that set.

This feature is especially useful if you are familiar with the data in the cube and want to avoid using the Search feature to find and select a member or set.

When you enter a member using the input box, the current set is bypassed and you can directly use any member. The set then changes to a single member set.

If you are selecting a set using the input box, the named set you enter must exist. If customized sets are defined, then the named set must be in the customized set list.

To use the input box to select a member:
  1. Click the menu icon next to the dimension tile in the Context or Bench area and select Enter member to open the input box.

    Tip: If you're on Windows, simply press Ctrl + click the member name in a dimension tile to open the input box.
    Enter member option for a dimension
  2. Type the member name or ID in the input box and press Enter.
    Member named entered in the input box

The view updates with the member you entered.

You can select a set by typing its name in the same way from the tiles in the Row or Column area. If you are using the menu option, select Enter named set instead to open the input box.

Enter named set option on dimension tile