Menu Entry

Description

Predefined

Using the View ® Predefined ® Standard View menu option, you can return to the standard view. If you prefer the view that you are familiar with from the Query Designer in SAP BW 3.x, choose View ® Predefined ® View SAP BW 3.x.

Toolbars

You can use this function to show and hide the View, Standard and Exit toolbars.

Technical names

You can use this function to show or hide the technical names of the query components (InfoObjects, structures, variables, and so on).

Properties

You can use this function to show the Properties screen area. The content of the Properties screen area automatically adjusts itself. Depending on the object that you select, the respective properties appear as context-sensitive.

Tasks

You can use this function to show the Tasks screen area. In this area, the most important tasks are listed for the selected object with which you are currently working, as context-sensitive. This gives you an overview of the functions and options available while working in the query.

InfoProviders

You can use this function to show the InfoProvider screen area. The content of the InfoProvider upon which the query is based is displayed in this area and from here you can include objects in the query, using Drag&Drop.

Filters

You can use this function to show the Filter screen area. You determine the filter value of the query in this area. For more information, see Filters.

Rows/Columns

You can use this function to show the Rows/Columns screen area. In this area you determine the free characteristics for navigating in the query and the contents of the rows and columns. You can see the structure of the query in a preview.

Tabular View

You can use this function to show the Tabular View screen area. If the query only contains one structure, this area automatically appears as a tab page.

You can design a query for OLAP reporting and also for tabular reporting by activating or deactivating the Tabular Display mode when you define a query.

This function is only available for queries with one structure. Queries that have two structures are only available in the multidimensional display and are only suitable for OLAP reporting.

See Tabular Display of Queries.

Cells

You can use this function to show the Cells screen area. If the query already contains cells, this area automatically appears as a tab page.

You can define formulas and selection conditions explicitly for cells in queries with two structures. In this way you can override the cell values that are created implicitly from the intersection of the structure components. This function allows you to design much more detailed queries.

This function is only available for queries with two structures. The menu option is deactivated for queries with only one structure.

See Defining Exception Cells

Exceptions

You can use this function to show the Exceptions screen area. If the query already contains exceptions, this area automatically appears as a tab page.

You can define exceptions for a query. Exceptions are variations in key figure values that you define yourself. They are displayed in color in the query view. This allows you to see at a glance, any unusual deviations from the results you expect to get.

See Exception Reporting.

Conditions

You can use this function to show the Conditions screen area. If the query already contains conditions, this area automatically appears as a tab page.

You can define conditions for a query. You can specify threshold value conditions for the key figure values for every characteristic. For example, you can specify all sales figures under or above a certain threshold value. In the query, the chosen characteristics are displayed with the restricted key figures.

See Conditions

Messages

You can use this function to show the Messages screen area. System messages, check messages, warnings and information appear in this area. From the context menu of the message, you can goto the location of the error, or have a text explain the error.

Where-Used List

You can use this function to show the Where-Used List screen area. The Query Designer displays the objects (workbook, Web template, report or broadcasting setting) in which this query is used.

Documents

You can use this function to show the Documents screen area. If you select the Display Error Message function, the system message texts appear here.