Bex Fundamentals - Key Concepts | Attempts: 92 - Quiz, Trivia , Flashcards & Questions

2.

The Bex Design toolbar contains:

Color printing options
SAP code to write reports
Advanced features of report presentation
A link to SAP Online Help

Correct Answer

A. Advanced features of report presentation

Explanation

The Bex Design Toolbar contains advanced features of report presentation, such as lists of active filters, conditions, and exceptions defined in the query, as well as access to all available characteristics and structures for further analysis.

Rate this question:

3.

From the Bex 7.0 Global Menu, which button displays the complete list of folders containing the reports for all SBU’s, functions, and departments?

Find
History
Favorites
Roles

Correct Answer

A. Roles

Explanation

The Roles button allows the user to navigate to the main menu of folders containing reports by SBU, functional area, or department. The Find button allows users to search for a specific report using key words. The History button shows a list of recently run reports for the user. The Favorites button contains a list of reports saved by the user with preferred layouts.

Rate this question:

4.

From the Bex 7.0 Global Menu, the History button contains a list of reports the user has recently accessed. This feature allows easy access to frequently used reports for each user.

True
False

Correct Answer

A. True

Explanation

True, the History button contains a list of reports the user has recently accessed. This feature provides a quick access to frequently used reports, rather than going through the main menu and clicking into the appropriate folder path to launch the report.

Rate this question:

5.

Fields marked with an asterisk (*) in the selection criteria are _____________ and must be populated for the report to run.

Correct Answer
mandatory
required

Explanation
Fields marked with an asterisk (*) in the report selection screen must be populated in order for the report to run. Occassionally, these fields are prepopulated with a default value on behalf of the user. In other cases, the user must populate this field with the appropriate selection.

Rate this question:

6.

A saved variant will allow the user to:

Save the report as a favorite layout
Bypass the main report menu and provide a shortcut to the report
Prepopulate frequently used variables into the report selection screen
Remember your SAP user name and password credentials

Correct Answer

A. Prepopulate frequently used variables into the report selection screen

Explanation

Saved variants allow users to populate frequently used report selections one time and save those selections as a "saved variant". This reduces the amount of time spent keying the same information (for example, a range of profit centers) several times if the user runs the same report multiple times a month or a quarter.

Rate this question:

7.

Query properties will allow the user to make changes that apply to the entire report results. Select all that apply:

Add additional fields to the report results
Display or Hide Subtotals
Hide or Unhide Columns
Sort the report results alphabetically
Include or Exclude Zeros

Correct Answer(s)

A. Add additional fields to the report results
A. Display or Hide Subtotals
A. Hide or Unhide Columns
A. Include or Exclude Zeros

Explanation

Query properties contains many presentation and display options that apply to the entire report. To access Query properties, simply right click in the results area and select "query properties" from the context menu.

To choose sort options, right click in the results area and select "Sort by..." from the context menu. Options include Sort Ascending or Descending, and by Key (numeric value, such as GL Account) or by Text (alpha value, such as GL Description).

Rate this question:

8.

The Properties menu allow the user to choose the preferred display options for the selected field in the report results for the following: (Select all that apply)

Rounding and decimal place display preferences
Filter the report results
Display results as key (numeric value) or text (alpha value)
Save the report as a favorite

Correct Answer(s)

A. Rounding and decimal place display preferences
A. Display results as key (numeric value) or text (alpha value)

Explanation

Properties allow the user to select display preferences for a specific field displayed in the report results. To access properties, simply right click in the results area and select "properties" from the context menu. You can choose to display results as key (numeric value) or text (alpha value), or set rounding and decimal place display options.

To filter report results, the user can right click in the results area and slect "filter by" from the context menu and select the desired filter to apply. Advanced filtering options are available from the query properties menu.

To save a report as a favorite, click on the Save icon in the Bex Analysis toolbar, and choose "save workbook as".

Rate this question:

9.

To navigate back one step, right click and choose ________________________.

Correct Answer(s)
Back One Navigation Step

Explanation
If you have applied an unintended change to the report results, simply right click in the report results area and slect Back One Navigation Step. This will undo the previous action. If you wish to go back to the initial report results, simply right click in the report results area and select Back to Start.

Rate this question:

10.

If you would like to save a user-defined view of the report, simply create and save a BW Favorite by clicking the Save icon in the Bex Analysis toolbar and selecting "Save Workbook As".

True
False

Correct Answer

A. True

Explanation

Creating and Saving a BW Favorite allows users to save the preferred layout and filters as a user-specific report. This report is accessible through the Favorites button in the Bex main menu. Users are encouraged to save favorites to reduce time spent applying display and filter preferences in the report layout each time the report is run.

Rate this question:

Bex Fundamentals - Key Concepts

The Bex Analysis toolbar allows the user to access and run reports.

Quiz Preview

The Bex Design toolbar contains:

From the Bex 7.0 Global Menu, which button displays the complete list of folders containing the reports for all SBU’s, functions, and departments?

From the Bex 7.0 Global Menu, the History button contains a list of reports the user has recently accessed. This feature allows easy access to frequently used reports for each user.

Fields marked with an asterisk (*) in the selection criteria are _____________ and must be populated for the report to run.

A saved variant will allow the user to:

Query properties will allow the user to make changes that apply to the entire report results. Select all that apply:

The Properties menu allow the user to choose the preferred display options for the selected field in the report results for the following: (Select all that apply)

To navigate back one step, right click and choose ________________________.

If you would like to save a user-defined view of the report, simply create and save a BW Favorite by clicking the Save icon in the Bex Analysis toolbar and selecting "Save Workbook As".