Module 2

1
Building Running Saving BOA Queries
Module 2
2
Building a Query
Drag and drop the objects you want to see on your
report from the Classes and Objects window to
Result Objects window or double click on the
object.
You can also highlight the object and hit the
Enter key on your keyboard.
3
Query Panel Functions
Stacks objects in the Result Objects window
Hides or shows the classes of data and objects
window
Hides or shows Help on selected items
4
Conditions Window
5
Conditions Window

• Use conditions to limits the data that appears
  on the report
• Example

With this condition, Ccpo Id Equal to DW, the
report will contain only records from Fort
Stewart
6
Running the Query
7
The Main Window
StandardToolbar
Menu Bar
This half of the Standard Toolbar is Microsoft
compliant
ReportToolbar
8
Parts of the Document Window
Click the Report Managerbutton to hide the
Report Manager panel.
1
The Report Manager
2
3
Data in a Table Block
5
More reports, accessed by clicking a Report tab
The Status Bar
4
9
Getting Help

• For general help

10
Getting Help (cont.)

• To read the Business Objects Users Guide

11
Getting Help (cont.)

• HQ Army Web Site
• (http//www.acpol.army.mil/)
• Standard Reports
• Cross Reference
• Guidelines
• FAQs
• List of CPOC BOA Administrators

• CHRA Web Site
• (http//www.chra.army.mil/mdcpds/business.htm)
• Desk Guide
• Training Slides

12
Data and Network Protection

• BOA protects
• The data in the database
• The network
• Limits may be set on
• The of rows retrieved
• Execution Time

13
Documents

• Act as a container for reports

Blocks provide different views of the Data
Reports are TABs in the Document
14
Steps to Save and Share Documents (Reports)

• Save as .txt or .pdf
• Export as flat file
• Send to users

15
Saving a Document
With the default location
the document is not saved where you can retrieve
it if you log back into BOA You need to save it
to your hard drive using Save As
16
Saving a Document (cont.)
Click on the File drop down menu and select
Save As
17
Saving a Document (cont.)
1. Select the boreport on censv005(R) drive.
2. Type a name for your document in the space
next to File name
3. Click on the Save button
18
Saving a Document (cont.)
4. Click on the File drop down menu and select
Save As again
5. Right click on the file you just saved to the
R drive
6. Select the Copy function from the drop down
menu
19
Saving a Document (cont.)
7. Path to your PC by clicking the down arrow here
8. Select either the C on Client(V) drive
or the D on Client(D) drive if you have one.
20
Saving a Document (cont.)
Once you are at the drive on your PC . . ..
9. Double click on the folder where you want to
save the document.
21
Saving a Document (cont.)
10. Right click in the white space of the Save
As screen.
11. Click the Paste function on the drop down
menu.
22
Saving a Document Instructions
23
Opening a Document

• To open a document in a local or shared folder

• Click the Open button in the Report Toolbar.

• You may have to path to where you save your
  reports.

Report-One.rep
24
Refreshing a Report

• The last time the data was refreshed is shown in
  the Status Bar

• To refresh the data

Click the Refresh Data button in the Standard
Toolbar.

• When the data is refreshed, the new date is shown
  in the Status Bar

25
Closing a Document
The document is closed
If any changes were made you will be asked if
you want to save the changes before it closes
26
Closing a Document
You can also click on this X to close the
document
The document is closed
Again, if any changes were made you will be
asked if you want to save the changes before it
closes
27
Logging out of BOA
BOA closes down
If any changes were made you will be asked if
you want to save the changes before BOA closes
28
Logging out of BOA
You can also click on this X to close BOA
BOA closes down
If any changes were made you will be asked if
you want to save the changes before BOA closes
29
EXERCISE TIME