Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

Workday Pro Reporting > Calulated Fields > Flashcards

Calulated Fields Flashcards

1
Q

What can you do with calculated fields? (9)

A

Math calculations
date calculations and formatting
text concatenation, substring, and formatting functions
Currency conversion
Derive range bands from numeric or currency fields
Determine if conditions are true or not
Drill down and lookup levels and values in hierarchy and orgs
Lookup data in related objects
Sum, count and aggregate info across related instances

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Where can you use calculated fields?

A

Reports (new fields, prompts or filters, accessing data from PBO)
Business processes (controlling condition step, )
Integration (used with connectors and in reports that use data for documents transformations or EIB)
Scheduling recurring processes (dynamic runtime parameters)
And other areas

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Authorize usage area should be overridden for all areas?

A

No, should remain as default. Actual areas should only be added when necessary

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Who can see calculated fields?

A

Users with access to the domains that the calculated field is built off of.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Where can calculated fields not be used?

A) reports
B) business process condition rule
C) integrations
D) security configuration

A

Security configurations

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

What can you use the maintain calculated fields report to do?
A) create or edit a calculated field
B) share a calculated field with another worker
C) view standard fields in your system
D) view who created a calculated field

A

Create or edit a calculated field

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Being authorized for the custom field management domain allows you to edit, create, and delete which kinds of calculated fields?

A) system wide
B) report specific

A

System wide

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

What is substring text function?

A

Allows you to extract a specific portion of text within a field based on fixed positions or delimiters. You can search a string forward or backwards

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

What are the steps to create a Substring text calculated field?

A
  1. Run the create calculated field task
  2. Enter information information in the following fields
    Field Name, Business Object , function: substring text. Ok
    Text field: the name of field to use
    Substring Type: , delimiter, direction
    Category
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Which calculated field function computes a date that is specified number of days, months, or years before or after a date field?

A) format date
B) increment or decrement date
C) date difference

A

B) increment or decrement date

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

What field type does date difference calculated field return?

A) Numeric
B) date

A

Numeric

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q 
Which calculated field function would allow you to create a field that captures four digits of an employee’s social security number?
A) format date
B) substring text
C) format text
D) extract single instance
A

substring text

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

What does the evaluate function do?

A

Groups and transforms data, it evaluates a series of conditions and returns a value associated with the first met condition.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

How to create an evaluate expression?

A

Create text constants calculated fields if necessary
Create a true false condition
Create an evaluate expression

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q 
Which calculated field function would you use to evaluate and categorize the number of days off that an employee has taken over the past year?
A) evaluate expression 
B) true/false condition 
C) lookup range band
D) lookup related value
A

lookup range band

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

When creating a calculated field that evaluates multiple conditions, which condition should you list first?

A) the one that eliminates the greatest number of instances

B). The one that eliminates the most specific fields.

A

A) the one that eliminates the greatest number of instances

17
Q

Which calculated field function would allow you to create a field that categorizes employees by their employment status?

A) evaluate expression
B) true/false condition
C) lookup up range band
D) lookup related value

A

A) evaluate expression

18
Q 
What field type does a true/false condition calculated field return?
A) depends on configuration 
B) numeric
C) Boolean 
D) text
A

Boolean

19
Q

Sum Related Instances dynamically sum instances on what type of Business Object?

A

Related Business Objects

20
Q

How do you create a Sum Related Instance Calc Field?

A
  1. Run the create calculated Field task
  2. Enter Field Name, BO, SRI function
  3. select the related field, sum where instances conditions are true, select the condition, and the field to sum.
  4. add the field to the report
21
Q 
Which of the following mathematical operations are not supported by the arithmetic calculations function?
A)Addition
B)Multiplication
C)Exponents
D)Subtraction
A

Exponents

22
Q

Which calculated field function would you use to calculate the number of employees who have quit over the past year, given that this information is available on the org BO?

a) Sum Related Instances
b) Count Related Instances
c) Look up related value
d) extract single instances

A

Count Related Instances

23
Q

What calculated field function will allow you to represent relocation payments in the same currency for use in an arithmetic calculation to find the average amount?

a) Format text
b) format number
c) numeric constant
d) convert currency

A

convert currency

24
Q

What does the lookup related value function do?

A

Allows you to retrieve a value from a field on a related BO to a PBO. Must have a 1:1 relationship.

25
Q

What type of report allows you to access fields from RBOs one level away without using a calculated field?

a) Matrix
b) Advance

A

Advance

26
Q

Which calculated field function would allow you to make a field from the worker object available for use on an event condition rule on a RBO?

a) lookup related value
b) evaluate expression
c) text constant
d) lookup translated value

A

lookup related value

27
Q

which calculated field function would allow you to return the list of the teams an employee is currently a member of from a RBO?

a) Extract Single Instance
b) Extract Multi Instance
c) Lookup Related Value

A

extract multi instance

28
Q

What type of extract multi instance operation would allow you to return the benefits an employee is eligible for but not currently enrolled in?

a) union
b) except
c) subset
d) intersection

A

except

29
Q

Which calculated field function allows you to step through various levels of a hierarchy structure to organize data?

a) Lookup hierarchy
b) Lookup hierarchy rollup

A

Lookup hierarchy rollup

30
Q

What calculated function would allow you to return a specific level of a hierarchy structure to group a report data by?

a) Lookup hierarchy
b) Lookup hierarchy rollup

A

Lookup hierarchy

31
Q

What calculated field can you use to detect change?

A

Lookup value as of date

32
Q

Which function determines the value of a field specific effective and/or entry date?

a) date constant
b) lookup value as of date

A

Lookup value as of date

33
Q

When using the business object details report for event objects of interest which of the following should you expect to find?

a) available fields
b) reports that use the business objects
c) business process impacts
d) object relationships

A

a) available fields
b) reports that use the business objects
c) business process impacts

34
Q

When determine what happened in an event object, how’s the field labelled if the value coming into the event happens just prior to the change?

a) preceding
b) proposed
c) current
d) projected

A

current

Workday Pro Reporting (3 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions