Queries in Workbooks 

Use

Queries are inserted into workbooks so you can display them. When you insert a query, a link is made between the cell areas of the worksheet with the data of the InfoCube upon which the query is based. A link therefore exists between the Business Explorer and the Business Information Warehouse Server (BW Server). This link stays in place until you interrupt it (see Settings).

When you open a query and insert it into a workbook, the query is calculated and the view (initial view) of the data established in the Query Definition is displayed.

If Variables that are ready for input are used in the query, you can enter the required values for the variables or confirm the default values when you insert the query.

Workbooks into which queries are inserted are no different in appearance to other Excel workbooks. They can be saved as files, copied, sent and (using Excel functions) edited however you like and even supplemented with other data.

Functions

You can choose whether you want to insert a query into a new workbook, into an existing one, or into a workbook template:

If you want to insert a query into a new workbook:

  1. Choose the symbol for Open...from the BEx toolbar. This brings you to the screen Open SAP BEx:
  2. Select Queries from the left column.
  3. Select a query from all those available. The queries are arranged according to InfoCubes.
  4. Double-click on the required query or choose OK.

If you want to insert a query into the active workbook:

Open a workbook and choose Tools ® Insert Query... from the BEx toolbar. The query is then inserted into the current worksheet starting at the active cell.

If you want to insert a query into a workbook template:

  1. Create a workbook template.
  2. Insert the query into the workbook template.

See: Creating Workbook Templates

If you use the function based on permanent template (see Settings), the Business Explorer queries in all these workbooks will have the same formatting when you insert them.

See also:

Opening

Query Properties