GFEBS BI exam 2023 with 100% correct answers
Accessing a BEx report 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 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: 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
Document information
- Uploaded on
- April 16, 2023
- Number of pages
- 5
- Written in
- 2022/2023
- Type
- Exam (elaborations)
- Contains
- Questions & answers