Select Column dialog

Use this dialog to navigate to and select the columns or members to include in an analysis, prompt, filter, KPI, or when associating columns with layers for maps. In some cases, you can also use this dialog to add additional subject areas to the dialog.

For more information, see:

This dialog is also displayed as:

Add Columns dialog
Select BI Key Columns dialog
Select Columns dialog
Select member in Dimension Hierarchy dialog

Components

Add Related Subject Area

This button is available only if one or more related subject areas are available and you have permission to access them.

Use this button to display the "Add/Remove Subject Areas dialog", from which you can add or remove related subject areas.

Not available for maps. Click this button to search.

Subject Area

Use this tree to browse for and select the column for which you want to build the prompt, the column to add to the filter, the dimension to add to the KPI, or the column to associate with a layer for a map. For a map, you can select a single column, multiple columns from multiple subject areas, or multiple columns from a single subject area.

Selected Columns

This area is available only for columns to associate with a layer for a map. You can view and modify the columns that you have selected.

Shuttle

These buttons are available only for columns to associate with a layer for a map. You can select columns in one or more subject areas and move them between the two lists in the dialog.

Reorder

These buttons are available only for columns to associate with a layer for a map. You can select columns then click the buttons to modify the order or the columns in the list. If you are trying to duplicate the name of a geographic layer that has multiple parts, then ensure that the columns are in order from top to bottom to match that layer name. For example, if the layer name is Country_State, then ensure that you include the Country column above the State column in the list.