SAP BEx Analyzer And Query Designer - The Complete Guide
Contents:
A query is a subcube created by selecting characteristics and key figures.
SAP BEx Analyzer And Query Designer - The Complete Guide
Using queries, the data can be quickly targeted and evaluated. The more precisely the query is defined, the smaller the subcube and the quicker the query can be navigated and refreshed. Selecting certain characteristics means that they can be more closely analyzed while others remain unspecified. The resulting key figures are aggregated across all characteristic values for the unspecified characteristics.
Accessing Query Designer:
A default navigational state is also established in the query definition when you arrange the characteristics and key figures in the rows and columns of the query. Only the data that is currently requested is transferred to the query. The OLAP processor builds the query from the data and provides methods for navigating through the data in several dimensions.
Since a query preselects information, the same data can yield dramatically different results depending on the query used to view its contents. BEx queries filter the data to create reporting objects or views called InfoProviders. Some InfoProviders contain actual data. Others provide views of data stored in elsewhere. The basic elements used to define InfoProviders are called InfoObjects. An InfoObject is a business evaluation object, such as customer or sales revenue , relevant to your analysis of business performance.
InfoObjects can be characteristics dimensions , key figures measures or facts , units , time characteristics , or technical characteristics for example, request number. An InfoObject catalog is an application-specific organization of InfoObjects, either characteristics or key figures.
Query Panel:
To report against a cube, you must create a BW synonym that describes it to the adapter. To create a synonym for a query cube, you first create the BEx query. This query serves as a template for data extraction from the cube. You will see the selection screen for all InfoProviders for which you can define a new query or queries. The available objects in the InfoProvider you have selected are displayed as a directory tree in the left part of the screen.
Next, you will select the objects for the query and drag them to the appropriate boxes to build the query.
The right area of the BEx screen contains selection boxes for the filter selection, the rows, the columns, and the free characteristics of the query. The object list will expand and display a list of all the available Key Figures or characteristics. Browse the Book Browse the Book. The BEx tools are tried and true.
Get an overview of the BEx toolset and what it can do. About the Book About the E-book pages, hardcover, 1 in. Reference book format 6.
Printed black and white on 60 offset paper. Reader-friendly serif font Linotype Syntax 9. E-book in black and white.
Books by Peter Moxon. These variables can be sequenced as per our need. This is how it looks like: An InfoObject is a business evaluation object, such as customer or sales revenue , relevant to your analysis of business performance. E-book Print edition Bundle. Next, you will select the objects for the query and drag them to the appropriate boxes to build the query.
Table of contents, in-text references, and index fully linked. Including online book edition in dedicated reader application.