ANSWERS
Accessing a BEx report - ANS Select (Click) the Business Intelligence tab.
Select (Click) the role.
Select (Click) the report.
Select required and optional variables.
Save variable field value selections as a Variant (Optional).
Select (Click) OK to display the report.
Select Variables - ANS If you do not enter or select a value for all required variables, BI will
return an error message and will not process the query.
Variable Entry Screen - ANS You may directly enter selections into the Variable Entry screen
or use the select values tool that allows you to display and select available choices
Increase processing speed - ANS By using high-low values, date ranges and specific fund /
fund center / cost center selections
Multiple data values must be separated by - ANS a semi-colon and a space
A range of data values is separated by - ANS a space, a dash and a space (e.g., Fiscal Year:
2009 - 2011
1 Copyright ©2025 SIRJOEL ALL RIGHTS RESERVED
, To validate the entries - ANS click the Check button at the bottom of the variable entry
screen
Select Values screen - ANS ensures the type, number and format of the variable data values
are entered correctly
Select Values screen varies - ANS based on the data values required for the variable
Select Values screen allows - ANS you to search and select single data values, build a
customized list of multiple data values or a range of data values by key or text
The asterisk (*) can - ANS be used as a wildcard to search for data values with a similar
format (e.g., *D10, results in all direct Funds beginning in FY10, or *A*, results in all automatic
Funds regardless of appropriation or beginning year).
To select single and multiple variable data values - ANS Click on the data value
Add the value to the Selections list
Click OK
To select a range of variable data values: - ANS Click the Show tool: drop down text box and
select Value ranges
Select Sign:
Select Operator:
Select From:
Select To:
Select (click) Add button
A BEx report variant is - ANS a collection of saved variable data values selected by the user in
the Variable Entry screen
2 Copyright ©2025 SIRJOEL ALL RIGHTS RESERVED