Selecting Fields

After selecting an SAP BW object, the next step is to add query values. Use the Query Builder ‑ Fields page to select values, create clauses, and set conditions.

The Fields page in divided into three main parts:

Characteristics and Key Figures—The selected SAP BW object, its characteristics and key figures, and all its members. Use to add query values or set up the query clause.
Query Values—Query values for the report.
Query Clause—Conditions.

To add a query value:

Drag a characteristic or key figure from Characteristics and Key Figures to Query Values.
Select a characteristic or key figure and click .
Double-click a characteristic or key figure.

To set up a query clause:

Drag a member (dimension member, dimension child member, dimension level, or dimension level member) from Characteristics and Key Figures to Query Clause.
Select a member and click .
Double-click a member.

Setting up a query clause allows you to add filters, slicers, Order By clauses, and SAP Variables to the generated report. (See Defining Filters, Defining Slicers, Defining Order By Clauses, and Defining SAP Variables.)

Tip:

To display the SAP unique name for an object under Characteristics and Key Figures, point at the object. The SAP unique name displays as a tool tip.

Selecting fields involves: