Design Mode 

Use

In BEx Analyzer design mode, you design the interface for your query applications. A query is basically a complex select statement, an abstract object without visualization. Once you embed it into an Excel workbook and activate design mode, you add its visualization by designing its interface.

In design mode, your workbook appears as a collection of design items represented by their respective icons. When you activate analysis mode, the way the results of your query are displayed depends on how you configured them in the design items. You thus use design items to create an interface that dictates how you can analyze and navigate the results in analysis mode.

The query results are displayed in the analysis grid design item, where you can navigate in and analyze the query results together with the navigation pane design item. You can customize the interface for your query further by adding and arranging design items such as dropdown boxes, radio button groups, and checkboxes to filter your results.

You can also use the editing functions in Microsoft Excel to format your workbook, print result areas, insert additional worksheets, and create graphics and charts.

The workbooks you create in design mode are thus complete query or BI applications. In analysis mode, you can then save them in your favorites or your role on the BW server for someone else to then open and work with in analysis mode. You can also save the workbook locally on your computer.

In the standard setting, worksheets are protected in design mode to prevent you from unintentionally deleting design items.

 

Activities

●      Activate the design mode functionality using the corresponding design toolbar or the menu in BEx Analyzer menu. More information: Design Functions

●      Use design items as the building blocks of your query interface. More information: Design Items

●      Configure data providers to deliver data for your design items. See: Configuring Data Providers

●      Arrange design items in your workbook, resize them and delete them.  See also: Moving and Resizing Design Items, Deleting Design Items