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 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.
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):
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.
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. |
Range |
Manipulate coordinates for a cell or cells in this field to move or resize the radio button group. |
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:
|
Read Mode |
Specifies the method of retrieving the list of filter values:
|
Display |
Specifies how the filter values are displayed in the list. Select from the following values:
|
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: