Items Panel

Use the Items panel to select measures, dimensions, and hierarchies for a query.

As you move items from the Available box to the Selected box, you specify the items for the query. Some of the items that are listed in the Available box might be incompatible with the items that are specified in the Selected box. The items are incompatible if they do not have shared dimensions.

If this situation occurs, then you will notice a yellow triangle icon beside the item name in the Available box. The yellow triangle icon and the following text will also display near the bottom of the Items panel: Indicates Incompatibility with Selected Items. While you can add some incompatible items from the Available box to the Selected box, you will need to ensure all items in the Selected box are compatible before continuing with the definition of the query.

Panel components

Available box -- Displays a list of measures, dimensions, and hierarchies that you can select for the query.

Add selected items button -- Adds the currently selected item or items to the Selected box. Folders cannot be added to the Selected box. This button is disabled if a folder is selected. To add all items from a folder, you must select the items themselves and then click the Add selected items button.

Add all items button -- Adds all available items to the Selected box, except folders.

Remove selected items button -- Removes the currently selected item or items from the Selected box.

Remove all items button -- Removes all items from the Selected box.

Selected box -- Displays a list of measures, dimensions, and hierarchies that are selected for the query.

Automatically Add/Remove Dimensions box -- Specifies whether the dimensions that are associated with a particular measure are automatically added to or removed from the Selected box when that particular measure is added or removed.

Description bar -- Displays a description of the currently selected item. If multiple items are selected, then the bar displays text for the last item that was selected. The text that is displayed in the Description bar is the value of the Description property of the item.