Accessing a BEx report
Select (Click) the Business Intelligence tab.
Select (Click) the role.
Select (Click) the report.
Select required and optional
... [Show More] variables.
Save variable field value selections as a Variant (Optional).
Select (Click) OK to display the report.
Select Variables
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
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
By using high-low values, date ranges and specific fund / fund center / cost center selections
Multiple data values must be separated by
a semi-colon and a space
A range of data values is separated by
a space, a dash and a space (e.g., Fiscal Year: 2009 - 2011
To validate the entries
click the Check button at the bottom of the variable entry screen
Select Values screen
ensures the type, number and format of the variable data values are entered correctly
Select Values screen varies
based on the data values required for the variable
Select Values screen allows
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
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
Click on the data value
Add the value to the Selections list
Click OK
To select a range of variable data values:
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
a collection of saved variable data values selected by the user in the Variable Entry screen
BEx Report Variants
each report requires its own variant
BEx To save a variant
Click on the Save As... button on the Variable Entry screen to display the Save Variant screen
Select the Description: text box
Enter the name you want to assign to the Variant
Click OK to save Variant
BEx Save As User Variant check box
Check - Saves variant privately for personal use
Uncheck - Saves variant globally
BEx Report Variant - Access Variants
Click on the Available Variants: drop down box arrow button
Select the variant. The Variable Entry screen will automatically populate with the variables associated with the variant
This is an opportunity to alter your data values prior to running your query
Click OK at the bottom of the Variable Entry screen to generate the report using the selected variant
Which tab in GFEBs provides access to BEx reports?
the Business Intelligence tab
The BEx report navigation panel consists of three menus
Columns menu - List of characteristics or Key Figures which form the report table columns
Rows menu - List of characteristics or Key Figures which form the report table rows
Free characteristics menu - List of characteristics not displayed on the report when initially generated [Show Less]