Inserting Design Items
Use
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 (see Design 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 (see Configuring 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.
Procedure
To insert and configure design items:
...
1. If you are not already in design mode, use the Design Mode/Exit Design Mode function to enter design mode.
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.
2. Select a cell or cells in the worksheet in which you want the design item to appear.
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. See Moving and Resizing Design Items.
3. Insert a design item:
○ Choose Insert [Design Item] in the design toolbar, or BEx Analyzer → Design Toolbar → Insert [Design Item] in the menu.
An icon representing the design item appears in the workspace.
4. Call the properties dialog box for your design item to configure its properties:
○ To open the dialog box, choose the icon that represents the design item (using the left or primary mouse button). You can also use the right (secondary) mouse button to do this. In the context menu displayed when you click the right mouse button, choose Properties.
○ To access item properties of the design item in the menu, in design mode choose BEx Analyzer → Design Toolbar → [Design Item Name].
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.
5. Configure the data provider for your design item (see Configuring Data Providers).
6. Configure additional properties relevant for your design item (more information about specific design items: Design Items).
7. When you have finished configuring your design item, choose OK.
Result
In the worksheet, the design item icon indicates the location and approximate size of your design item (see Moving 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:
● Moving and Resizing Design Items