The checkbox group design item lists the values of a dimension and lets you filter it by selecting one or more values from the list.
Use the checkbox group to easily filter a selected dimension by multiple values at once. 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 checkbox group. You might use the checkbox 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 a group of filter values at once. The dropdown box andradio button group design items provide similar functionality, except they restrict filer selection to one value at a time.
In the checkbox 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 checkboxes, and any currently filtered values are checked. Two buttons at the bottom of the list, Submit and Clear, let you either submit or clear checked filter selections, upon which the dimension filters are updated according to your selection. The query results in the analysis grid are refreshed.
Configure properties for the checkbox group on two different tabs in the Properties of Checkbox Group dialog box (seeInserting Design Items to learn about how to insert the checkbox group and access its properties):
To add a checkbox 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 checkbox group in analysis mode.
Properties of Checkbox Group
Property | Description |
---|---|
Name of Checkbox Group |
Displays the name of the checkbox 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 checkbox 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 Provider |
Assign an existing data provider to the checkbox 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. |
Area |
Manipulate coordinates for a cell or cells in this field to move or resize the checkbox group. |
AutoFit |
When selected, the width of the cells in the checkbox group expands as needed to accommodate the longest value listed. |
Display Dimensions Horizontally |
Select this option to display the values of the checkbox 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:
|
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 checkbox group. |
More Information: