8/2/2019 Reporting Fundas
1/18
September 21, 2010 TCS Public
SAP BI
Reporting Fundamentals
8/2/2019 Reporting Fundas
2/18
September 21, 2010 2
Contents
1. Business Explorer- Overview- Bex Architecture and Components
2. Tools and Functions available in Bex- Business Explorer Analyzer (BEx Analyzer)- BEx Web Analyzer
- BEx Query Designer- Portal Access3. Working with Bex Analyzer
- Launching a BW Report Via The Analyser- Displaying the available reports
- How to execute the report4. Working with Query Designer- Launching the Query Designer- Creating a Query- Changing a Query
- Filtering Data in the Query Definition5.Calculated and Restricted Key Figures
6. Exceptions and Conditions
8/2/2019 Reporting Fundas
3/18
September 21, 2010 3
Business Explorer
Overview,Architecture
BI Suite is used to create the required queries and analyses on the Web or in MicrosoftExcel and to distribute them using the portal.
8/2/2019 Reporting Fundas
4/18
September 21, 2010 4
Business Explorer
Components
The Business Explorer consists of the following components:
BEx Analyzer: Used to create and execute queries
BEx Browser: Used to retrieve and execute queries.
BEx Web: Used to access BW data using a web browser
BEx Query Designer: Used to create Queries
8/2/2019 Reporting Fundas
5/18
September 21, 2010 5
Tools & Functions available in Bex
Business Explorer Analyzer (BEx Analyzer
- The BEx Analyzer, an MS Excel-based tool, can be used to display the results of queriesdeveloped in the Query Designer. )
BEx Web Analyzer- The Web Analyzer allows you to execute ad hoc analyses on the Web.
BEx Query DesignerWhat is Business Explorer (BEx) Query Designer?
The BEx Query Designer is the BW analytical tool where queries are defined, by selecting key
figures and characteristics. You analyze the dataset of the BI system by defining queries forInfoProviders using the BEx Query.
Portal Access
As companies rollout portals, this access method is becoming more popular. The content aswell as look and feel for these portals can vary significantly from company to company.
8/2/2019 Reporting Fundas
6/18
September 21, 2010 6
Working with Bex AnalyzerLaunching the BI Report via the Analyzer
8/2/2019 Reporting Fundas
7/18
September 21, 2010 7
Working with Bex AnalyzerDisplaying the available Reports
8/2/2019 Reporting Fundas
8/18
September 21, 2010 8
Working with Bex AnalyzerExecuting the report via Bex Analyzer
0
8/2/2019 Reporting Fundas
9/18
September 21, 2010 9
Working with Query DesignerThe Query Designer is a powerful and versatile tool that can define and/or change BWqueries. It can execute various functions, such as working with queries (open, create,
change, save, delete, etc.), with the help of the Query Designer Toolbar.
Opening Query Designer
8/2/2019 Reporting Fundas
10/18
September 21, 2010 10
Working with Query Designer
Query Toolbar
8/2/2019 Reporting Fundas
11/18
September 21, 2010 11
Working with Query DesignerCreating 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.
8/2/2019 Reporting Fundas
12/18
September 21, 2010 12
Working with Query DesignerDirectory tree of the selected InfoProvider
ki i h Q D i
8/2/2019 Reporting Fundas
13/18
September 21, 2010 13
Working with Query Designer
Columns
You define the columns of your report in this area.
Rows
You define the rows of your report in this area.You can specify the details or granularity to be used
for the first call of the query. If characteristics are entered here, they are presented in the report as
dynamic drilldown. You can also define fixed drilldowns in the form of structures.
Free Characteristics
Free characteristics are initially displayed in the navigation block when you execute the query in
BEx Analyzer or on the Web.You can specify characteristics that will be available during the query
navigation for filtering and as drilldown. These characteristics
are not displayed as drilldown when
the query is called for the first time.
Filter
These characteristics are only used as global filters on the cube data and are not displayed in the
report.You can specify characteristics that are restricted using filter
values, but that are not to be used in
the additional navigation. A drilldown using these characteristics is not possible.
W ki i h Q D i
8/2/2019 Reporting Fundas
14/18
September 21, 2010 14
Working with Query Designer
Filtering the data in Query Defenition
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.
W ki ith Q D i
8/2/2019 Reporting Fundas
15/18
September 21, 2010 15
Working with Query DesignerCalculated and Restricted Key Figures
What is a Restricted Key Figure?Restricted key figures are (basic) key figures of the InfoProvider that are restricted (filtered)by one or more characteristic selections.Filter vs. Restricted Key Figure?
Filter estrictions are valid for the entire query Restricted Key Figure only the key figure inquestion is restricted to its allocated characteristic value or characteristic value interval
What is a Calculated Key Figure?You can recalculate the key figures of an InfoProvider for reuse in the Query Designer usingformulas. Calculated key figures consist of formula definitions containing basic key figures,restricted key figures or precalculated key figures
W ki ith Q D i
8/2/2019 Reporting Fundas
16/18
September 21, 2010 16
Working with Query DesignerCalculated and Restricted Key Figures
Working with Query Designer
8/2/2019 Reporting Fundas
17/18
September 21, 2010 17
Working with Query DesignerExceptions & Conditions
ExceptionsExceptions are deviations from pre-defined threshold values or intervals.Exception reportingenables you to select and highlight unusual deviations of key figure values in a query.
ConditionsConditions are restrictions placed on key figures in order to filter data in the query results.You can define multiple conditions for a query, and then activate or deactivate them in thereport itself to create different views of the data.
You can display all key figure values above or below a certain value.Using ranked lists, youcan display your ten best customers by sales revenue
Working with Query Designer
8/2/2019 Reporting Fundas
18/18
September 21, 2010 18
Working with Query Designer
Exceptions
Top Related