Download - WB PAS Refernece
-
8/12/2019 WB PAS Refernece
1/45
SAP Business Warehouse
Business Explorer Analyzer
for Power Users(BEX_305)
Some information and illustrations were taken from the SAP Library
-
8/12/2019 WB PAS Refernece
2/45
Objective
This course is intended to familiarizeusers with the SAP Business
Information Warehouse (BW):
Business Explorer-Analyzer (BEx-
Analyzer). After attending this class,you should be able to create, run,
modify and save your BEx Queries.
You w i l l have to pass a sk i l ls test
before you are given the Power
User Role in Produc t ion .
-
8/12/2019 WB PAS Refernece
3/45
Business Warehouse: Overview
-
8/12/2019 WB PAS Refernece
4/45
University of Kentucky
BW Reporting Overview
Other
Report-
Developer2(BEx-Analyzer & RSA1)
Report-
Developer(BEx-Analyzer & RSA1)
Power Users(BEx-Analyzer)
End Users(BEx-Web)
-
8/12/2019 WB PAS Refernece
5/45
Role Functionality
-
8/12/2019 WB PAS Refernece
6/45
What is Required to Access BEx-
Analyzer? Web browsersthat support
DOM level 2 (with dynamicgeneration of DOM objects),ECMA-262 script, HTML 4.0,and CSS 1.0. The referenceWeb browsers are theMicrosoft Internet Explorer (MSIE) and the Netscape Navigator(NS) in the current Windows
implementations (MS IE 6.xand NS 6.x). Instances ofthese Web browsers on othersystems, for example, AppleMacintosh or Linux, may
behave differently.
An Active Directory
Services Account(domain
is ad or mc) from IT User
Accounts that is used to log
onto the Enterprise Portal toget to SAP. (This is the
same account used with
Outlook and Microsoft
Exchange) SAPGUI
Microsoft Excel
-
8/12/2019 WB PAS Refernece
7/45
Installing SAPGUI
Log onto http: / /download.uky.edu with
your U-Connect userid and password.
Search for SAPGUI
Download
Restart your computer
-
8/12/2019 WB PAS Refernece
8/45
myUK
Logon myUK,
https://myuk.uky.edu/irj
/portal
Key in yourActive
Directory Services
User Idand Password
Log on
-
8/12/2019 WB PAS Refernece
9/45
Getting Through the Portal
Production Sandbox
-
8/12/2019 WB PAS Refernece
10/45
BEx Analyzer
-
8/12/2019 WB PAS Refernece
11/45
BEx Analyzer: Toolbar
*Open
*Save
*Refresh query
*Back
*Change query
Goto
OLAP functions for active cells
Format
Layout
Tools
Settings
*Help
-
8/12/2019 WB PAS Refernece
12/45
BEx Analyzer: ToolbarOpen
Open
WorkbooksNot availableusin g po rtal /AD authent icat ion
QueriesCollection of aselection of characteristics
and key figures (InfoObjects)
for the analysis of the data in
an InfoProvider.
Saved ViewsThe savedchanges made to a query view.
Exceptions- Not available
-
8/12/2019 WB PAS Refernece
13/45
BEx Analyzer: Toolbar
Save
Save as new workbookWorkbooks are Not available
usin g po rtal /AD authent icat ion
Save view as jump targetTo use this option, you must
have a saved workbook;
therefore, Not available.
Save view globalThis willsave your view so you can recall
it later.
Save
-
8/12/2019 WB PAS Refernece
14/45
BEx Analyzer: Toolbar
Refresh query
Brings up the parameter window for you to
adjust their values of the variables.
Refresh query
-
8/12/2019 WB PAS Refernece
15/45
BEx Analyzer: Toolbar
Back
Go back one step. While you are makingchanges to a view of a query, you may
want to undo the last thing you did. To do
this, just hit the Back button.
Back
-
8/12/2019 WB PAS Refernece
16/45
BEx Analyzer: Toolbar
Change query (local view)
Change query
Change query (global definition)
Change variable valuesTakes you back to the parameter screen, so you canchange variable values.
-
8/12/2019 WB PAS Refernece
17/45
BEx Analyzer: Toolbar
Help
For more information
about the BEx Analyzer,
go to the SAP Library for
assistance.
Help
-
8/12/2019 WB PAS Refernece
18/45
Query Designer: Selec t query
-
8/12/2019 WB PAS Refernece
19/45
Query Designer : New query
-
8/12/2019 WB PAS Refernece
20/45
Query Designer : New query
-
8/12/2019 WB PAS Refernece
21/45
Query Designer
-
8/12/2019 WB PAS Refernece
22/45
Query Designer: Toolbar
-
8/12/2019 WB PAS Refernece
23/45
Query Designer
-
8/12/2019 WB PAS Refernece
24/45
Power Users: Create Query
-
8/12/2019 WB PAS Refernece
25/45
Power Users: Save Query
-
8/12/2019 WB PAS Refernece
26/45
Power Users: Create Query
Generate a Local Restricted Key Figure
-
8/12/2019 WB PAS Refernece
27/45
Power Users: Create Query
Generate a Local Calculated Key Figure
-
8/12/2019 WB PAS Refernece
28/45
Power Users: Create Query
Generate a Local Structure
-
8/12/2019 WB PAS Refernece
29/45
Power Users: Create Query
Hierarchies
-
8/12/2019 WB PAS Refernece
30/45
Power Users: Create Query
Hierarchies
-
8/12/2019 WB PAS Refernece
31/45
Power Users: Create Query
Properties of Characteristics
-
8/12/2019 WB PAS Refernece
32/45
Power Users: Create Query
Query Properties
-
8/12/2019 WB PAS Refernece
33/45
Power Users: Run Query
There are two ways to display the output of a query,in Excel or on the web.
Display Report in Excel
If in the Query DesignerClick on the first icon (green ball with a check mark in it)
If not in Query Designer
Open
Queries
Drill-down to a query
Double-click the query and it will run in Excel.
-
8/12/2019 WB PAS Refernece
34/45
Power Users: Run Query
Display Report on the Web
If in the Query Designer
Click on the third iconlooks like a spreadsheet with a world in
the upper left corner
If not in Query DesignerOpen
Queries
Drill-down to a query
Single-click the query
Change the query
Right-click and select change OR
Click on the icon that looks like a pencil
Note: This will put you in the Query Designer. See 1stoption.
-
8/12/2019 WB PAS Refernece
35/45
Power Users: Change Query
Open
Queries
Drill-down to a query
Single-click the query Change the query
Right-click and select Change OR
Click on the icon that looks like a pencil
Note: This will put you in the Query Designer
P U
-
8/12/2019 WB PAS Refernece
36/45
Power Users: Delete Query
Open
Queries
Drill-down to a query
Single-click the query Delete the query
Right-click and select Delete OR
Click on the icon that looks like a trash
can
Q ti Ab t Q i
-
8/12/2019 WB PAS Refernece
37/45
Questions About Queries
Do you have any questions on how to
display, create, save, change, runor
deletea query?
P U
-
8/12/2019 WB PAS Refernece
38/45
Power Users:Query Views
A query view is a picture of aquery that saves any formattingdone to the query. Examplesof formatting would be hiding
key figures from the initialdisplay of the report or thegeneration of exceptions andconditions. Power Users can
save, run, change the originalquery view, and delete queryviews.
P U
-
8/12/2019 WB PAS Refernece
39/45
Power Users:Create Query View
Creating & Savinga Query View in
BEx Analyzer
OpenQueries
Drill-down to a query
Double-click
Make changes
Save view global
P U
-
8/12/2019 WB PAS Refernece
40/45
Power Users:Run Query View
Run a Query View
in BEx Analyzer
OpenSaved Views
Find the view
Double-click on QueryView
-
8/12/2019 WB PAS Refernece
41/45
Power Users Change Query View
Change a Query View in BEx Analyzer
Open
Saved Views
Find the view
Double-click on Query View
Make changes
-
8/12/2019 WB PAS Refernece
42/45
Power Users Delete Query View
Delete a Query View in BEx Analyzer
Open
Saved Views
Find the view
Delete Query View
Right-click and select Delete OR
Click on the icon of a trash can
Q ti ?
-
8/12/2019 WB PAS Refernece
43/45
Quest ions?
-
8/12/2019 WB PAS Refernece
44/45
T t Ti
-
8/12/2019 WB PAS Refernece
45/45
Test Time