You use design items in the BEx Analyzer to provide controls, interfaces, and functions in your worksheet to design a query application. Eleven design items are available (seeDesign Items).
All design items are based on data providers. After you insert the design item into your workbook, you configure the data provider and other properties that are relevant for the particular item (seeConfiguring Data Providers).
Design items are represented in design mode by icons. In analysis mode, correctly configured design items return the data as it was configured in the data providers upon which they are based.
To add the Dropdown Box, Radio Button Group, Checkbox Group, or Button design items to your workbook, you must enable Microsoft Excel setting Trust access to Visual Basic Project (in Tools → Macro → Security → Trusted Publishers). If you omit this step, the Access to Visual Basic project failed error is displayed when you attempt to insert or access these design items in analysis mode.
To insert and configure design items:
This is an optional step. If you are not already in design mode, the BEx Analyzer automatically switches to design mode when you choose a design function in the toolbar or menu.
You only need to select one cell to insert a design item. This corresponds to the upper-left coordinate of the design item. You do not need to select a range of cells large enough to accommodate the query results. Once you switch to analysis mode and the design items populate with results, they expand to fill the space required by the results. The upper-left coordinate remains fixed, and the lower-right coordinate expands to accommodate the data returned. SeeMoving and Resizing Design Items.
An icon representing the design item appears in the workspace.
The name of each design item you have inserted into your workbook appears in the BEx Analyzer → Design Toolbarmenu. These menu options are only active in design mode.
The properties dialog box for the selected design item appears.
In the worksheet, the design item icon indicates the location and approximate size of your design item (seeMoving and Resizing Design Items). When you switch to analysis mode, correctly configured design items return the data as it was configured in the data providers upon which they are based.
More Information: