Show TOC

Radio Button GroupLocate this document in the navigation structure

Definition

The radio button group design item lists the values of a dimension and lets you filter it by selecting a value from the list.

Use

Use the radio button group to easily filter a selected dimension. Since filtering is a function also provided in thenavigation pane, you might not want to use a navigation pane in the same worksheet as the radio button group. You might use the radio button group if, for example, you don't want to offer the whole range of navigation that the navigation pane provides, but you want to be able to conveniently set filters. The dropdown box andcheckbox group provide similar functionality, except the checkbox group allows you to select multiple filter values at once.

In the radio button group properties, you configure the values for the dimension you wish to filter. In analysis mode, each value appears next to one of a group of radio buttons. When you then select one of the radio buttons, the dimension is filtered by your selection, and the query results in the analysis grid update accordingly.

Structure

Configure properties for the radio button group on two different tabs in the Properties of Radio Button Group dialog box (seeInserting Design Items to learn about how to insert the radio button group and access its properties):

  • General - lets you configure data provider, cell range, AutoFit, and horizontal display
  • Dimensions - lets you select and configure the dimension you wish to filter
    Caution

    To add a radio button group to the workbook, you must enable Microsoft Excel's Trust access to Visual Basic Project setting (in Tools → Macro → Security → Trusted Sources). If you omit this step, you will see an Access to Visual Basic project failed error when you attempt to insert or access the radio button group in analysis mode.

  • Target Data Provider - lets you select multiple data providers for which you want to apply a filter

Properties of Radio Button Group

Property Description
General Tab Page
Dimensions Tab Page

Name of Radio Button Group

Displays the name of the radio button group, which is generated automatically and is unique. This name is used on the BEx Analyzer → Design Toolbar menu to refer to a particular instance of the radio button group.

Display Technical Names/Do Not Display Technical Names

Use this button on any tab page to toggle the display of technical names.

Data Providers

Assign an existing data provider to the radio button group, create and assign a new one, or change or delete a data provider. The initial view of a data provider corresponds to the query view.

SeeConfiguring Data Providers.

Range

Manipulate coordinates for a cell or cells in this field to move or resize the radio button group.

SeeMoving and Resizing Design Items.

AutoFit

When selected, the width of the cells in the radio button group expands as needed to accommodate the longest value listed.

Display Dimensions Horizontally

Select this option to display the values of the radio button group horizontally, in one row across the sheet.

Dimension

Select the dimension you want to filter.

Text Type

Specifies which text type to display for the values of the dimension:

  • Default Text: Use the shortest available text to display the values.
  • Short Text: Use the short text to display the values.
  • Medium Text: Use the medium text to display the values.
  • Long Text: Use the long text to display the values.

Read Mode

Specifies the method of retrieving the list of filter values:

  • Posted Values (Q): Performs a SELECT on the fact table to list filter values that actually return data. Values that return no results when filtered are not displayed in the list. This calculation can be time-consuming, but yields only usable values in the list.
  • Dimension Table (D): Performs a SELECT on the dimension table to retrieve the list of filter values. This calculation is less time consuming than that for Posted Values. The probability that results are returned is higher than with Master Data Table.
  • Master Data Table (M): Returns all members of the selected dimension that appear in the master data table. Since InfoCubes may be quite sparsely populated, this will yield many selections that would show no results when filtered (No applicable data found), but the logic involved is simple and hence the performance is optimal.

Display

Specifies how the filter values are displayed in the list.  Select from the following values:

  • Text: Display the text
  • Key: Display the technical key
  • Key and Text: Display the technical key, followed by the text
  • Text and Key: Display the text, followed by the technical key

Maximum Number of Displayed Values

Use this selector to set the maximum number of values to display in the radio button group.

Affected Data ProvidersTab Page

Name of Affected Data Provider

The query results of a data provider can be filtered by the value of a dimension for which a radio button is designed. This filtering is not applied to other data providers within a workbook even though the same dimension is reused. This means that you need to create individual filters for the same dimension that is used in different data providers.

However, the affected data provider feature allows you to simplify the above scenario.  On this tab page, you can view all data providers that are used in the workbook. You can select the required or all data providers to apply the same filtering for specific or all data providers used in a workbook.

More Information: