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 the navigation 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 and checkbox 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 (see Inserting 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
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 |
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. |
General Tab Page |
|
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. |
Dimensions Tab Page |
|
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: ● 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 Providers Tab 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: