SAP Business Intelligence (BI 7) Reporting Training: Award Report
SAP Business Intelligence (BI 7) Reporting Training: Award Report
SAP Business Intelligence (BI 7) Reporting Training: Award Report
Contents
Business Intelligence 7.0 (BI) Reports .........................................................................................................................................4
BI Logon......................................................................................................................................................................................5
Entering Variables ......................................................................................................................................................................7
Data Update ...............................................................................................................................................................................8
Tab Layout ..................................................................................................................................................................................8
Tab Descriptions .........................................................................................................................................................................9
Summary Tab.................................................................................................................................................................................. 9
Budget Tab ................................................................................................................................................................................... 10
Commitments Tab ........................................................................................................................................................................ 11
Actuals Tab ................................................................................................................................................................................... 11
Payments Tab ............................................................................................................................................................................... 12
Dashboard Tab ............................................................................................................................................................................. 13
Toolbar Icons ............................................................................................................................................................................ 14
Toolbar Button Icons .................................................................................................................................................................... 14
Open Saved User-Defined Views
........................................................................................................................................... 15
....................................................................................................................................................................................... 16
Back to Start
.......................................................................................................................................................................... 16
Variables ....................................................................................................................................................................................... 16
Display
................................................................................................................................................................................ 17
Filter Values
Export to Excel
........................................................................................................................................................................... 18
....................................................................................................................................................................... 18
Navigation Pane
Filter Pane..................................................................................................................................................................................... 22
Full Window
.......................................................................................................................................................................... 24
Views ........................................................................................................................................................................................ 25
BI Jump Functionality ............................................................................................................................................................... 27
Contact Information ................................................................................................................................................................. 29
APPENDIX A .............................................................................................................................................................................. 30
QUICK REFERENCE OF BI TOOLBAR ICONS ................................................................................................................................... 30
BI Logon
Users will logon to BI through Employee
Self Service (ESS) in the same manner as
they do currently to access their pay
statements and enter leave requests.
1. Go to the ESS portal. You may
already have this saved in your Favorites.
If not, you can go to the Human Resources
and Labor Relations website
@ http://bloomu.edu/node/837
and select Employee Self Service on the left
pane.
2. Select Log Into ESS on the right
side under Quick Links.
3. Enter your University domain user ID
([email protected]) and password
and click Enter Portal
4.
You will now see a Business Intelligence tab as one of your options. Click on the tab
Entering Variables
Variable Entry Screen
After clicking on the Award Report link, a Variable
Entry screen will appear.
Most users have already been set up with their own
unique personalization based on the funds centers
they are responsible for. If your personalization is upto-date and accurate, you will not need to change any
of these values. Simply click the OK button to execute
your report.
After clicking OK, a
turning wheel will
indicate the report is running.
If you are not seeing any variables listed, you can
enter the variables yourself. Some variables can be
typed in directly. Others must be selected by using
the Selection Button
- reference the screen shot
to the right. When typing directly into the field it is
recommended that you click on the Check Button
to verify the values you entered are valid. You
can enter more than one item by separating them
with a semi-colon. For example, if you are entering
data in the funds center field:
1011030201;1011030202
Entering values with the Selection Button
1. Click on the Selection button
to open a dialog
box for the variable value options.
2. Select the value from the list by clicking on the
block to the left of the value. In this example,
multiple values can be selected.
3. Click the Add button to add the values to the list.
4. After clicking add, notice the Selection values are
added to the right.
5. Click OK when all the selection values are added
Data Update
Query Description and Last Update
A. For each tab selected, the description of the query will display.
B. The Last Data Update date and time will also display. This is the day and time the SAP BI reports were last
updated with SAP data. Keep this date and time in mind when viewing BI reports. BI is a reporting platform
and does not contain real-time data. Typically, your reports contain all the prior day information by 6:30 AM
each morning.
Tab Layout
Tab Layout
BI reports are tabular in nature. The tabs have been created to categorize data for financial managers
and enable them to meet their reporting needs. To navigate from tab to tab, click on the appropriate tabs.
Please note that a user should click one-time only. BI will display a processing wheel until processing
is complete. The active tab will be darker than the others.
Tabs are arranged in a logical order. Summary or high level data is first, followed by more detailed or specific
Tabs. Specialty tabs (i.e. Payments, and Dashboard) can be
found at the end. The Summary tab is the most commonly viewed report. More information on this, as well as the
Specialty tabs, can be found in the sections that follow. Features described on the Summary tab section (i.e. drop
down boxes, arrows, etc.) are also available on most other tabs.
Tab Descriptions
Summary Tab
The Summary tab shows the budget status and is the most commonly viewed report.
A. Users can click on any of the dropdown boxes to select data
B. It is important to note that if multiple funds or funds centers were included on the variable selection, that
the data rolls into one total. The user will need to select each individual fund or funds center from the drop
down box in order to view the data separately.
C. The most commonly viewed Commitment Item Category is Total Expenses which shows the personnel
budget, operating budget and operating reserves (CI 6xx, 7xx, 82x, and 90x) . This is the default but can be
changed by selecting from other categories in the drop down box such as Personnel and NonPersonnel.
By expanding Current Budget, you can view the budget source. To collapse the data, click on the arrow again.
By expanding Commitments, you can view funds reservation, purchase requisition, and purchase order data. You
can drill down into each category to view additional details.
Budget Tab
The Budget Tab displays all budget entries: Enter (Original Budget), Carry Forwards, Transfers, Supplements, and
Returns. All of these items make up your Current Budget.
10
Commitments Tab
The Commitments Tab displays all open commitments. The following detail is displayed
Example:
Actuals Tab
The Actuals Tab displays all actuals or paid items. The Fund and Funds Center are shown. The additional items are
also displayed: Commitment, Posting Date, Doc #s, Doc Text, Vendor, and Actuals.
Click on the arrow before Actuals, report will run and then show payment type.
11
Payments Tab
The payments tab will display all paid invoices to vendors where the expense was posted to the funds center.
12
Dashboard Tab
The Dashboard tab provides a dashboard report based on variables selected on the the summary tab.
A. The percent of the current fiscal year is displayed based on remaining pays.
B. Dropdown boxes allow filtering on Fund and Funds Center.
C. The most recent posting date of non-personnel expenses scroll by expense dollars in descending order.
D. The bar graph displays actual expenses in green and commitments in yellow in descending order.
E. The speedometer graphs display the dollars and percent of budget remaining. The dotted blue line
represents the % of the fisal year passed. If the solid line passes the dotted line, expenses and
commitments are exceeding the rate of time.
F. Displays operating expense and chargebacks by month. Commitments are not included in this graph
G. Displays current/prior YTD variances by Commitment item group
13
Toolbar Icons
Toolbar Button Icons
14
15
Back
NOTE: THIS ACTION MAY TAKE SEVERAL MINUTES. VARTAN WAY (SYTEC) ARE CURRENTLY WORKING ON A SOLUTION.
Click on the Back icon
to undo your last navigation or filter. Each time you click the Back button you will undo one
step. You can click multiple times to undo multiple steps but you must wait for the screen to refresh after each click.
DO NOT use your browsers back button or your
browsers context menu back button.
Browser Back Button
BI Toolbar Button
BI Context Menu
Back to Start
NOTE: THIS ACTION MAY TAKE SEVERAL MINUTES. VARTAN WAY (SYTEC) ARE CURRENTLY WORKING ON A SOLUTION.
Clicking the Back to Start
button will remove all navigation steps and return the report to the original navigational
state. It will also remove any dynamic filters that we added since the report was executed.
Variables
Use the Variables Icon to quickly
reprocess the report with new values.
A. Click on the Variables icon
to call the variable
screen to change variable
values.
B. The variable dialog box will open.
C. Change the variable values.
D. Click OK
16
Display
The Display button will show toolbar icon legend, all variable and filter selections, query filters, general information,
and any query documents.
1. Click on Display button on toolbar
2. Icon Legend will explain the use for each toolbar button
3. Variables and Filters will display all variable values, including blank variable values, as well as dynamic filters
on the active tab.
4. Static Filters/Query Filters will display variable values as well as filter values that are in the query design.
5. General Query information will display who created the query, the technical name of the query and web
template, who last modified the query, the current user, last update, etc.
Query Documents displays any documents that are attached to the query.
17
Filter Values
A. Variable Filters: This will display the variable values entered when you ran the report.
B. Dynamic Filters: This will display any filtering done on the current tab. Dynamic filters only apply to the tab
you are viewing while Variable Filters are the same for all tabs.
C. To hide the display of the Variable and Dynamic filters, click on the
icon.
Export to Excel
The Export to Excel
18
19
Properties
Users have the ability to change the
properties of many reporting objects by
activating the properties pane. Click on the
Properties button
to open the properties
pane. (Click on Properties button again to
hide the properties pane).
You can modify Table, Chart, All Data Cells, and
Query properties. For example, you may want
to display text on every line, regardless if it is
repeating.
A. Click on the Properties icon/button on the
toolbar
B. Click on the Table tab
C. Check the Display Repeating Text checkbox
D. Notice that every row will now display text, even if that text is the same as the row above.
20
Navigation Pane
- Swap/Replace Characteristics
Click and
Drag
You can drag from the Navigation Pane to the table, from the table to
The Navigation pane, or even move characteristics within the table
or navigation pane.
Result
Characteristics are
swapped
Navigation Pane
21
Filter Pane
- Dialog Selection
22
Click and
Drag
Click and
Drag
If you find yourself completing any of the above navigation on a regular basis, you can save yourself time by
saving the layout as a personal view. See Page 18 for saving a personal view. Note that saving a personal view
saves all the tabs of the report in the layout they are in when the view is saved so make sure the entire report is
exactly as you want it.
23
Full Window
If you data list is very long, you may wish to open the data table in a full window. You will still have the ability to use
the BI Context Menu but the other web items will be removed from the full window view. Simply click on the Full
Window button
to open a new window.
There are several tools that will help maximize the display area and assist with scrolling while locking the column
and row headings.
A. You can adjust the display area by entering the number of rows and columns to display at one time. Simply
enter a number and press Enter on your keyboard. You can set the rows and columns to a display area that
best fits your computers screen size and resolution.
B. Use the scroll buttons to scroll through the data. Column and row headings will display with each step.
C. You can also use the scroll bar on the right and/or bottom of the screen to scroll through pages.
To Exit a BI report simply click the black X in the upper right hand corner of the Report.
24
Views
Global Views
Each tab may contain multiple views in a
dropdown list. Simply click on the dropdown
arrow to display a list of views built on the
query. Click on the desired view and wait for
the screen to refresh with the new view.
Refer to Appendix A for a description of views
for each report and tab.
25
26
BI Jump Functionality
BI provides users the ability to jump into the details which make up amounts displayed on reports. On the
summary tab of the Budget Report, a user can drill in to all of the amounts displayed.
Summary amounts will allow the user to jump into the detailed transactions. Detailed transactions will allow users
to jump into the actual documents such as the Funds Reservation, Purchase Order, Journal Entry, Budget
Document and Payment Details. Directions for jumping into the details are included below. Because the options for
jumping vary depending where you are located on the report, a flowchart is included on the next page to help
users navigate.
1. To view actual revenue and/or expense document
a. Right click on the Actuals column and select Goto. (By clicking on the total you will see results for all
commitment items displayed. By clicking on an individual commitment item line, you will see only
results for that commitment item.)
b.
Because you were on the Actual Amount, you will select Actuals Detail Lines.
c. A new window will open and display a summary of all of the transactions
3.
27
28
Contact Information
Please contact the following with assistance with Budget
reports, logging on, training, etc.:
BUDGET OFFICE:
Audra Halye
[email protected]
x4700
Barbara Meyer
[email protected]
x4029
ACCOUNTING OFFICE:
Debra Newman
[email protected]
x4584
GRANTS OFFICE:
Julie Kaschak
[email protected]
x4022
PURCHASING OFFICE:
Jeff Mandel
[email protected]
x4045
29
APPENDIX A
QUICK REFERENCE OF BI TOOLBAR ICONS
30