Sorting, Filtering, Prompting, Totaling, and Percentile Flashcards
What reports do you use to determine the (PBO) primary business object and data source for an existing report?
Business Object Details and Data Sources reports.
True or False: All custom reports sort output by the left-most column of the primary business object by default.
False: All custom reports other than Advanced reports sort output by the left-most column of the primary business object by default.
Note: The Sort tab on all report definitions allows you to override the default behavior and control the presentation and grouping order of report data.
When does Workday not support multi-instance fields for grouping and sorting?
When you create or edit reports with non-Prism data sources.
Does sorting on object field types performs better than sorting on simple field types?
No Sorting on simple field types performs better than sorting on object field types because object field types access additional data in the background.
True/False You must display fields on the report output that you use for sorting.
False
What are the options available when defining a filter?
And/Or - Enables you to specify how multiple filter conditions should evaluate.
Parentheses - Some report types, like Advanced, allow you to use any combination of And and Or conditions within a filter. You can use parentheses to group conditions together and control the condition evaluation sequence.
Field - Specifies the field to evaluate.
Operator - Specifies the logical operator in the filter condition. The available choices depend on the field type.
Comparison Type - Specifies how the system should compare the field.
Comparison Value - Specifies the value to compare to the Field value, or the user-selected prompt value. The ability to enable this field and available choices depends on the Field type, the Operator, and the Comparison Type.
What are the different types of Comparison Type in the report filtering tab?
Specifies how the system should compare the field. The options are:
* Value specified in this filter - This option allows you to explicitly specify a value to filter on.
* Value from another field - This option allows you to compare the value of one field to another.
* Prompt the user for the value - With this option, the user-entered prompt value determines the report filter.
* Prompt the user for the value and ignore the filter condition if the value is blank - This option configures an optional prompt. If the user enters nothing in the prompt (i.e., blank value), the report ignores the filter condition. The report only uses the value in the filter if it is not blank
Which filter logic executes first for a given instance of a primary business object?
The report filter
or
The report subfilter
the subfilter logic executes first, then the filter logic
How do you filter out instances of the primary business object that do not have related data in a report filter?
You include the condition “RBO not empty” in the filter.
When Workday applies report filters, which logic does it execute first? A. Filter
B. Subfilter
C. Filter and subfilter are executed simultaneously
D. Cross filter
B. Subfilter
You need to filter a custom report to only show regular employees. Which comparison type should you use when creating the filter?
A. Prompt the user for the value
B. Prompt the user for the value and ignore the filter condition if the value is blank
C. Value from another field
D. Value specified in this filter
D. Value specified in this filter
A custom report has a built-in prompt for Include Subordinate Organizations. How can you set the prompt value to always be yes and hide this prompt from users? (Select two correct answers)
A. Select Specify Default Value and identify the default selection
B. Add a filter to include subordinate organizations
C. Select the Do Not Prompt at Runtime checkbox
D. Use a different data source without a default prompt
A. Select Specify Default Value and identify the default selection
C. Select the Do Not Prompt at Runtime checkbox
- Which of the following is a source of prompts on a report? (Select two correct answers)
A. Data Source Filter
B. Data Source
C. Report Type
D. Business Object
A. Data Source Filter
B. Data Source
- When totaling data on a report, how many aggregations can you select per row?
A. One
B. Two
C. Three
D. Four
A. One
- What is the first step of setting up grouping in your report?
A. Select which groups should have a header line at the top of the group
B. Indicate if the report should have the group name in headers
C. Add the Group Name field to the top of the columns grid
D. Indicate if you want to enable outlining based on grouping
C. Add the Group Name field to the top of the columns grid