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


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 .


3/45

Business Warehouse: Overview


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)


5/45

Role Functionality


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


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/45

myUK

Logon myUK,

https://myuk.uky.edu/irj

/portal

Key in yourActive

Directory Services

User Idand Password

Log on


9/45

Getting Through the Portal

Production Sandbox


10/45

BEx Analyzer


11/45

BEx Analyzer: Toolbar

*Open

*Save

*Refresh query

*Back

*Change query

Goto

OLAP functions for active cells

Format

Layout

Tools

Settings

*Help


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


13/45


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


14/45


Refresh query

Brings up the parameter window for you to

adjust their values of the variables.

Refresh query


15/45


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


16/45


Change query (local view)

Change query

Change query (global definition)

Change variable valuesTakes you back to the parameter screen, so you canchange variable values.


17/45


Help

For more information

about the BEx Analyzer,

go to the SAP Library for

assistance.

Help


18/45

Query Designer: Selec t query


19/45

Query Designer : New query


20/45

Query Designer : New query


21/45

Query Designer


22/45

Query Designer: Toolbar


23/45

Query Designer


24/45

Power Users: Create Query


25/45

Power Users: Save Query


26/45


Generate a Local Restricted Key Figure


27/45


Generate a Local Calculated Key Figure


28/45


Generate a Local Structure


29/45


Hierarchies


30/45


Hierarchies


31/45


Properties of Characteristics


32/45


Query Properties


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.


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


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.


35/45

Power Users: Change Query

Open

Queries


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


36/45

Power Users: Delete Query

Open

Queries


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


37/45

Questions About Queries

Do you have any questions on how to

display, create, save, change, runor

deletea query?

P U


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


39/45

Power Users:Create Query View

Creating & Savinga Query View in

BEx Analyzer

OpenQueries


Double-click

Make changes

Save view global

P U


40/45

Power Users:Run Query View

Run a Query View

in BEx Analyzer

OpenSaved Views

Find the view

Double-click on QueryView


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


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 ?


43/45

Quest ions?


44/45

T t Ti


45/45

Test Time

wb pas refernece

Documents