Inserting Design Items
Use
You use design items in BEx Analyzer to provide controls, interfaces, and functions in your worksheet to design a query application. There are eleven design items in all
All design items are based on data providers. After inserting the design item into your workbook, you configure the data provider and other properties relevant for the item in question.
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 that they are based on.
To add the Dropdown Box, Radio Button Group, Checkbox Group or Button design items to your workbook, you must enable the Microsoft Excel setting Trust access to Visual Basic Project (in Tools → Macro → Security → Trusted Publishers). If you skip 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 it.
This step is optional. If you are not already in design mode, 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 where 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] from the design toolbar, or BEx Analyzer → Design Toolbar → Insert [Design Item] from 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 menu under BEx Analyzer → Design Toolbar. 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.
6. Configure additional properties relevant for your design item.
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. When you switch to analysis mode, correctly configured design items return the data as it was configured in the data providers that they are based on.
See also:
● Moving and Resizing Design Items