SAP Business Information Warehouse
Business Explorer – Web Application (BEX_300)
This course is intended to familiarize users with the SAP Business Information Warehouse (BW): Business Explorer-Web Application (BEx-Web) environment. After attending this class, you should be able to run, modify and save your BEx Reports. You will be tested at the end of class on these functions.
This is the Business Information Warehouse, also known as BW, which is like our current Data Warehouse in Oracle. Most of data we will be using is coming from R/3 (the SAP solution to replace our current mainframe environment) and imported into BW and placed either in an ODS (Operational Data Store); which is equivalent to a flat file, or an InfoCube; which is summarized data. We are coming in through the Enterprise Portal to get to Business Explorer (BEx) to produce reports from BW. There are other third party tools; like WebFOCUS, SAS, Crystal, … that can also be used to produce reports from the BW data… for an extra cost.
The third-party tools, we know are being talked about, are WebFOCUS and SAS… at this time, we only have BEx going against the BW data.
Web browsers that support DOM level 2 (with dynamic generation of DOM objects), ECMA-262 script, HTML 4.0, and CSS 1.0. The reference Web browsers are the Microsoft Internet Explorer (MS IE) and the Netscape Navigator (NS) in the current Windows implementations (MS IE 6.x and NS 6.x). Instances of these Web browsers on other systems, for example, Apple Macintosh 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 to get to SAP. (This is the same account used with Outlook and Microsoft Exchange)
The following must be done the first time an Active Directory Services account is used:
Your AD password expires 90 days after it has been changed
Your portal might look different, depending on your SAP access or Role.
The portal is a work in progress… it will be changing.
Click the Reporting Link under Sandbox
Here is where all your available queries/reports are located
Required variables are those listed with an asterisk on the end of the name. The other variables help to limit your report to what you really need. The more variables you can put in the better the performance; in other words, your report comes back quicker.
With Multiple Selections you have choices on how to select your criteria.
A range selection has a “from” area and a “to” area, with a “Selection Button” for each.
You can use this as a single selection if you have the same value in both boxes.
With a single selection, you will be able to choose one entry from the selection list for this variable.
Here are part of the available entries for the variable Fiscal Year/Period.
Only “Part”, because of “The Next 25 Values” button.
You have the choice to “Select All” of the values on this list OR just specific ones OR change your mind and “Deselect All” OR fine tune your selection options by doing a “Find”.
You have a list of what the Rows and Columns are and also Free Characteristics.
Free Characteristics are fields that are available to use in your report that are not in the initial report.
All of the fields in the list on the left can be used for drill-down, to drill-across and to apply a filter.
Drill-downs create breakdown of data by rows
If you want to see the data by GL Account, click on the icon with the down arrow.
Drill-across creates breakdown of data by columns
If you want to see the data by “Value type in FM”, click on the icon with the arrow pointing to the right.
You can add additional filters to your report to get the data you are really looking for. If you want to see a particular “Funded Program” apply the filter and the report updates. Take a look at “Funded Program” in the Free Characteristics. It now reflects what you selected.
The Context Menu can be different depending on what you right-click on to bring up the menu. Rows, Columns, Free Characteristics, Characteristic Column headers, Characteristic value (Characteristics are not amounts), Key Figure headers and Key Figure values (Key Figures are amounts). So, Characteristics describe what the Key Figures are.
There are two different types of Context Menus, Basic and Enhanced.
Key Figure Header
Key Figure Value
When you have your report the way you would like to see it on a regular basis, you can save the settings (not the data) with the “Save View” Button.
Views are shared…. Everyone that has access to this same query can run your saved view, but they cannot change or overwrite your saved view. They will be able to modify their own version and save it with a new unique Technical Name.
“Description”, max. number of characters are 60, make it as descriptive to you as possible.
We are suggesting the following guideline for your description:
your userid: description
Example - BKMCC03: Budget & Actuals by FYR by G/L
We would further suggest the ‘BY’ and ‘FOR’ principle, to apply after your userid: BUD/ACT BY FUND, FCTR FOR F/AREA 1000 - where BY indicates the drilled-down field, and FOR the filter.
“Technical Name”, max. number of characters are 30, there is a naming convention for technical names for views, this is…
Examples ZBKMCC03_0001 and Zdclaunch_0005
The purpose of the naming standard is to assist in identifying the views you have saved, using the suggested naming standard will quickly identify the person who saved the view and make it easier to find your next view number.
Since technical names have to be unique in the SAP BW system, you will need to keep track of your next view number. There is a spreadsheet on the SAP BW link, https://reporting.uky.edu/BWReports/BWRptTracking.xls, which you can download to your desktop to assist in keeping track of your saved views.
If you decide not to use the spreadsheet, you can still find your next view number by going to Open View.
To check existing views, click on “Open View”. By default on the “Choose a View” window, your Display: is “History”. Check each of the views by either moving your cursor over each one slowly (the technical name will appear) or click on each one (the technical name will display in the Selected Object: box.)
You can use the drop-down on Display: and choose Roles, where you can see all the views saved by everyone who has the same access you do per role. You will need to expand each role and check for your views and note the view numbers until you can determine what the next available number is. Using the suggested view Description standard (detailed previously) will make this process much easier.
Expand your role(s) by clicking on the small black arrows until you see the views that have been created.
In Roles, you will be able to see all the views created on each query.
-- So you can share
-- Maybe someone already created a view you
can also use
-- Find your views and run your mouse over
slowly or click each view to determine which
view number is available
Click “Cancel” when you know what the next available number is.
Once you save a view, it cannot be changed or overwritten by anyone (including yourself) – the only exception is the BW Support Staff. If you want to make a change to an existing saved view, you must re-save the view and give it a new technical name.
If you no longer need a view, send email to the BW Support Staff, [email protected], and specify what view you would like to have deleted. Make sure to include the ‘Technical Name’ of the view in your request. Deleting views no longer needed will help to keep the unwanted views from cluttering up the system. After the view is deleted, you can reuse the technical name, so you may also want to note the deletion in your spreadsheet.
Click Open View again and take a look at the Roles. You will be able to see the new view you just saved in Roles and in History.
The “Variable Screen” button takes you to the “Variables for Ad-hoc Report” screen so you can change the parameters for the initial view of the report.
Click “Execute” when you have finished making changes.
Exceptions allows you to put on and take off the coloring of cells that meet specified criteria. You can Activate and Deactivate by clicking the red & green icon.
There may be some Exceptions and Conditions supplied with the query… maybe not, but you can create your own.
To see what an existing Exception looks like, right-click the Exception and select display
To create your own “Exceptions”, click the “Create” button
Conditions allows you to change the report depending on specified criteria.
For instance, if you want the top 10 “Actuals".
Your newly created Exceptions and Conditions can be saved as a view and kept; otherwise, they will go away.
“Notes” are global documentation and specific to the initial query… they can be seen and changed by everyone who has the role where the query is located.
This can come in handy to relay information about a particular query.
Remember, if you save a view and add “Notes” to your view, you have also added it to the query in the role.
You can export your report to an Excel Spreadsheet or a CSV (comma-delimited) file. This is handy if you want to use the data in Access, Crystal, Brio … .
The “Graphical Display” tab shows you what the current report from the “Data Analysis” tab looks like as a graph.
You can choose how you would like to see your graph
Note: There will be no additional fields applied to Financial ODSs and InfoCubes until Human Resources Go-Live, which is January 1, 2006.
If you experience problems while using BEx-Web, or need additional information, check out the Frequently Asked Questions: go to the UK Reporting Home Page (https://reporting.uky.edu) – Business Warehouse link. If you still need assistance, send email to [email protected]