1 / 16

BEx Query Designer

What is Business Explorer (BEx) Query Designer?. BEx Query Designer is an independent tool for defining queries that are based on a selection of characteristics and key figures (InfoObjects) or on reusable InfoProvider structures in SAP Business Information Warehouse (BW).In BEx Query Designer, you can parameterize queries by defining variables for characteristic values, hierarchies, hierarchy nodes, texts or formulas.You can specify the selection of InfoObjects more precisely by:Restrictin224

Faraday
Download Presentation

BEx Query Designer

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

    1. BEx Query Designer Unit 2: First Steps in the BEx Query Designer

    2. What is Business Explorer (BEx) Query Designer? BEx Query Designer is an independent tool for defining queries that are based on a selection of characteristics and key figures (InfoObjects) or on reusable InfoProvider structures in SAP Business Information Warehouse (BW). In BEx Query Designer, you can parameterize queries by defining variables for characteristic values, hierarchies, hierarchy nodes, texts or formulas. You can specify the selection of InfoObjects more precisely by: Restricting characteristics and key figures by characteristic values, characteristic value intervals, and hierarchy nodes Defining calculated and restricted key figures for reuse Defining structures for reuse Defining exceptions Defining conditions Defining exception cells

    3. Opening BEx Query Designer From your desktop, click Start | All Programs | Business Explorer | Business Explorer (SAP BW 3.x) | Query Designer (SAP BW 3.x).

    4. BEx Query Designer Toolbar

    5. Creating a Query To define a new query, open Query Designer and click the New Query button. In the New Query: Select InfoProvider dialog box, select the required InfoProvider.

    6. Creating a Query

    7. Creating a Query

    8. Creating a Query Once you have defined a query, choose Save Query or Save Query As... Save the query to your Favorites using the IP naming convention AHQ_ + Author’s Initials_ + Query Technical Name_ + Q001, Q002, …

    9. Creating a Query Click Display Query on the Web to execute the query in your Web browser.

    10. Finding a Query From within the Open Query dialog box, click Find.

    11. Changing a Query From within Query Designer, click Open Query and choose a query to open. You will only be able to modify queries that you created using the IP naming convention AHQ_ + Author’s Initials_ + Query Technical Name_ + Q001, Q002, …

    12. Filtering Data in the Query Definition You can restrict (filter) the characteristic values of a characteristic in the Rows, Columns, Free characteristics, and in the Filter. Right-click on the characteristic in the query definitions and choose Restrict.

    13. InfoProviders in SAP BW Reporting

    14. InfoProviders in Query Designer InfoCube Elements Key Figures Calculated Key Figures Restricted Key Figures Dimensions Characteristics Attributes Characteristic Value Variables Values

    15. InfoProviders in Query Designer Characteristic InfoProvider and ODS Object Elements Key Figures Number of Records (1ROWCOUNT) Dimensions Characteristic InfoProviders Attributes Key Part ODS Objects Data Part Key Part

    16. InfoProviders in Query Designer InfoSet Elements Key Figures Number of Records (1ROWCOUNT) Dimensions Attributes Key Part MultiProvider Elements Key Figures Number of Records (1ROWCOUNT) (if one of the InfoProviders included already contains this key figure, for example, in ODS objects) Dimensions Data Package InfoProvider (0INFOPROV)

More Related