In the next step of the data flow we define a BW Query on top of the CompositeProvider.
BW Query: terminology and use cases
A BW Query defines precisely which data is available from the CompositeProvider to BI (Business Intelligence) or Planning tools. A BW Query is the final layer in the data flow and is consumed by the business analyst using the tool of their choice, either cloud or on-premise, SAP or non-SAP.
You define a BW Query in order to generate a result set from SAP BW/4HANA. In the definition of a BW Query you can choose which data should be available from the InfoProvider by selecting the InfoObjects and optionally applying filters to them. You also define the initial layout of the report (rows, columns, totals). You can also define additional calculations.
BW Query: system settings
In our scenario we have chosen the following:
Only data of Calendar Year 2020 is selected
Products are displayed using a hierarchy
Description of products are shown
Product ABC Category and Gross Weight of products are displayed with each product
A calculation Tax Rate has been added
A calculation Number of Business Partners has been added
You can watch the following demo to explore the BW Query: