Workday Workday-Pro-Integrations - Workday Pro Integrations Certification Exam

The requirement is to run the integration every 48 hours at a fixed time. In schedule configuration terms, 48 hours is equivalent to every two days. Therefore, the correct recurrence type is “Recurs every 2 day(s).” “Recurs every 48 hours” sounds mathematically equivalent, but it is not the schedule recurrence type shown for this configuration. Custom Recurrence would only be needed if the schedule pattern could not be represented by the standard recurrence options. Dependent Recurrence is used when an integration should run based on another process or dependency, which is not stated here. Since the file must include changes since the last run, the two-day recurrence controls how often incremental job changes are extracted.

In Workday integrations, XSLT is used to transform XML data, such as the output from a web service-enabled report or EIB, into a desired format for third-party systems. In this scenario, you need to write XSLT to process wd:Education_Group elements within a template matching wd:Report_Entry, using an < xsl:apply-templates > element to iterate only over wd:Education_Group elements where the wd:Degree is " MBA. " The correct XPath syntax for the select attribute is critical to ensure accurate filtering.

Here’s why option A is correct:

XPath Syntax Explanation: In XPath, square brackets [ ] are used to specify predicates or conditions to filter elements. The condition wd:Degree= ' MBA ' checks if the wd:Degree child element has the value " MBA. " When applied to wd:Education_Group, the expression wd:Education_Group[wd:Degree= ' MBA ' ] selects only those wd:Education_Group elements that contain a wd:Degree child element with the value " MBA. "

Context in XSLT: Within an < xsl:apply-templates > element in a template matching wd:Report_Entry, the select attribute uses XPath to specify which nodes to process. This syntax ensures that the template only applies to wd:Education_Group elements where the degree is " MBA, " aligning with the requirement to conditionally process only those specific education groups.

XML Structure Alignment: Based on the provided XML snippet, wd:Education_Group contains wd:Education and wd:Degree child elements (e.g., < wd:Degree > MBA < /wd:Degree > ). The XPath wd:Education_Group[wd:Degree= ' MBA ' ] correctly navigates to wd:Education_Group and filters based on the wd:Degree value, matching the structure and requirement.

Why not the other options?

B. wd:Education_Group/wd:Degree= ' MBA ' : This is not a valid XPath expression for a predicate. It attempts to navigate to wd:Degree as a child but does not use square brackets [ ] to create a filtering condition. This would be interpreted as selecting wd:Degree elements under wd:Education_Group, but it wouldn’t filter based on the value " MBA " correctly within an < xsl:apply-templates > context.

C. wd:Report_Entry/wd:Education_Group/wd:Degree= ' MBA ' 1:Degree= ' MBA ' : This is syntactically incorrect and unclear. It includes a malformed condition (1:Degree= ' MBA ' ) and does not use proper XPath predicate syntax. It fails to filter wd:Education_Group elements based on wd:Degree= ' MBA ' and is not valid for use in select.

D. wd:Report_Entry/wd:Education_Group[wd:Degree= ' MBA ' 1:Degree= ' MBA ' ]: This is also syntactically incorrect due to the inclusion of 1:Degree= ' MBA ' within the predicate. The 1: prefix is not valid XPath syntax and introduces an error. The correct predicate should only be wd:Degree= ' MBA ' to filter the wd:Education_Group elements.

To implement this in XSLT:

Within your template matching wd:Report_Entry, you would write an < xsl:apply-templates > element with the select attribute set to wd:Education_Group[wd:Degree= ' MBA ' ]. This ensures that only wd:Education_Group elements with a wd:Degree value of " MBA " are processed by the corresponding templates, effectively filtering out other degrees (e.g., B.S., B.A.) in the transformation.

This approach ensures the XSLT transformation aligns with Workday’s XML structure and integration requirements for processing education data in a report output.

Workday Pro Integrations Study Guide: Section on " XSLT Transformations for Workday Integrations " – Details the use of XPath in XSLT for filtering XML elements, including predicates for conditional processing based on child element values.

Workday EIB and Web Services Guide: Chapter on " XML and XSLT for Report Data " – Explains the structure of Workday XML (e.g., wd:Education_Group, wd:Degree) and how to use XPath to navigate and filter data.

Workday Reporting and Analytics Guide: Section on " Web Service-Enabled Reports " – Covers integrating report outputs with XSLT for transformations, including examples of filtering elements based on specific values like degree types.

In Workday Report Writer, the available data sources depend heavily on the selected report type and the reporting context. If the required data source, such as All Active and Terminated Workers, does not appear in the prompt, the most likely cause is that the wrong report type has been selected during report creation. Workday filters the available data sources based on compatibility with the selected report type. Enabling a report as a web service does not remove data sources from the prompt, and temporary report settings do not determine whether this worker data source appears. Optimized for Performance affects report execution and performance behavior, not whether the core data source is selectable. Correcting the report type allows the proper worker data source to appear.

================

You are asked to create a calculated field that:

Takes the Hire Date

Adds 85 days

Formats it as YYYY-MM-DD

To accomplish this in Workday, you need the following calculated field functions:

Numeric Constant → define 85

Increment or Decrement Date → add 85 days to the Hire Date

Format Date → convert the resulting date to YYYY-MM-DD

Why other options are incorrect:

A. Date Constant would define a fixed date, not a dynamic calculation.

B. Date Difference is for subtraction between two dates.

C. Date Constant is still incorrect for offsetting a variable date.

In Workday, for an Integration System User (ISU) to be selectable as a Custom Report Owner, the security group the ISU belongs to must have Modify access to custom reports.

From Workday’s security configuration principle:

An ISU does not appear as a valid report owner unless its security group has Modify permission in the Report/Task Permissions section of the Custom Report Creation domain security policy.

This is because report ownership requires writelevel access over custom report objects.

Therefore, you must update the Report/Task Permissions table to include the ISSG with Modify access.

Options B, C, and D are incorrect because View or Get/Put do not provide report ownership capabilities.

In the context of a stylesheet, particularly within Workday ' s Document Transformation system where XSLT (Extensible Stylesheet Language Transformations) is commonly used, a namespace serves a critical role in defining the scope and identity of elements and attributes. The correct answer, as aligned with Workday’s integration practices and standard XSLT principles, is that a namespace " provides elements you can use in your code. " Here’s a detailed explanation:

Definition and Purpose of a Namespace:

A namespace in an XML-based stylesheet (like XSLT) is a mechanism to avoid naming conflicts by grouping elements and attributes under a unique identifier, typically a URI (Uniform Resource Identifier). This allows different vocabularies or schemas to coexist within the same document or transformation process without ambiguity.

In XSLT, namespaces are declared in the stylesheet using the xmlns attribute (e.g., xmlns:xsl= " http://www.w3.org/1999/XSL/Transform " for XSLT itself). These declarations define the set of elements and functions available for use in the stylesheet, such as < xsl:template > , < xsl:value-of > , or < xsl:for-each > .

For example, when transforming Workday data (which uses its own XML schema), a namespace might be defined to reference Workday-specific elements, enabling the stylesheet to correctly identify and manipulate those elements.

Application in Workday Context:

In Workday’s Document Transformation integrations, namespaces are essential when processing XML data from Workday (e.g., Core Connector outputs) or external systems. The namespace ensures that the XSLT processor recognizes the correct elements from the source XML and applies the transformation rules appropriately.

Without a namespace, the processor might misinterpret elements with the same name but different meanings (e.g., < name > in one schema vs. another). By providing a namespace, the stylesheet gains access to a specific vocabulary of elements and attributes, enabling precise coding of transformation logic.

Why Other Options Are Incorrect:

B. Indicates the start and end tag names to output: This is incorrect because namespaces do not dictate the structure (start and end tags) of the output. That is determined by the XSLT template rules and output instructions (e.g., < xsl:output > or literal result elements). Namespaces only define the identity of elements, not their placement or formatting in the output.

C. Restricts the data the processor can access: While namespaces help distinguish between different sets of elements, they do not inherently restrict data access. Restrictions are more a function of security settings or XPath expressions within the stylesheet, not the namespace itself.

D. Controls the filename of the transformed result: Namespaces have no bearing on the filename of the output. In Workday, the filename of a transformed result is typically managed by the Integration Attachment Service or delivery settings (e.g., SFTP or email configurations), not the stylesheet’s namespace.

Practical Example:

Suppose you’re transforming a Workday XML file containing employee data into a custom format. The stylesheet might include:

< xsl:stylesheet version= " 1.0 " xmlns:xsl= " http://www.w3.org/1999/XSL/Transform " xmlns:wd= " http://www.workday.com/ns " >

< xsl:template match= " wd:Employee " >

< EmployeeName > < xsl:value-of select= " wd:Name " / > < /EmployeeName >

< /xsl:template >

< /xsl:stylesheet >

Here, the wd namespace provides access to Workday-specific elements like < wd:Employee > and < wd:Name > , which the XSLT processor can then use to extract and transform data.

Workday Pro Integrations Study Guide References:

Workday Integration System Fundamentals: Explains XML and XSLT basics, including the role of namespaces in identifying elements within stylesheets.

Document Transformation Module: Highlights how namespaces are used in XSLT to process Workday XML data, emphasizing their role in providing a vocabulary for transformation logic (e.g., " Understanding XSLT Namespaces " ).

Core Connectors and Document Transformation Course Manual: Includes examples of XSLT stylesheets where namespaces are declared to handle Workday-specific schemas, reinforcing that they provide usable elements.

Workday Community Documentation: Notes that namespaces are critical for ensuring compatibility between Workday’s XML output and external system requirements in transformation scenarios.

The Test Security Related Action shows Available by User = No when the security group running the integration lacks View permissions to the fields used in the override logic.

From Workday documentation:

Field Overrides require the ISSG to have View access to the domain policies securing each field referenced in the override, otherwise Workday blocks the field from execution.

Therefore, the appropriate fix is to:

• Identify the domains that secure the calculated fields and overridden fields

• Grant the ISSG View access in those domain security policies

• Activate pending changes

Options B and C incorrectly focus only on web service operations.

Option D incorrectly suggests Modify access — but View is the required minimum.

A calculated field that already exists in the tenant is not automatically emitted in a Core Connector output. For this requirement, the connector must be extended so the custom value becomes available and is then placed into the outbound structure. Creating a Custom Field Override service makes the calculated License ID available for the connector output, and the integration field override then adds that calculated field into the file. Integration Maps are used to translate values, such as converting one code set to another; they do not add a new calculated field. Field Attributes mainly control delivered field inclusion and field behavior. Since the requirement is to add a custom calculated output value, the custom field override service plus field override configuration is the correct workflow.

================

The requirement is to create a calculated field for a dashboard that displays a worker’s name and the number of days until their next birthday in the format " [Worker ' s Name] ' s birthday is in [X] days " (e.g., " Logan McNeil ' s birthday is in 103 days " ). This involves calculating the difference between today’s date and the worker’s next birthday, then formatting the output as a text string. Let’s break down the necessary functions:

Date Difference:To calculate the number of days until the worker’s next birthday, you need to determine the difference between the current date and the worker’s birthdate in the current or next year (whichever is upcoming). The Date Difference function calculates the number of days between two dates. In this case:

Use the worker’s " Date of Birth " field (from the Worker business object).

Adjust the year of the birthdate to the current year or next year (if the birthday has already passed this year) using additional logic.

Calculate the difference from today’s date to this adjusted birthday date. For example, if today is February 21, 2025, and Logan’s birthday is June 4 (adjusted to June 4, 2025), Date Difference returns 103 days.

Format Number:The result of Date Difference is a numeric value (e.g., 103). To ensure it displays cleanly in the output string (without decimals or unnecessary formatting), Format Number can be used to convert it to a simple integer string (e.g., " 103 " ).

Text Constant:To build the output string, static text like " ’s birthday is in " and " days " is needed. The Text Constant function provides fixed text values to include in the final concatenated result.

Concatenate Text:The final step is to combine the worker’s name (e.g., " Logan McNeil " ), the static text, and the calculated days into one string. Concatenate Text merges multiple text values into a single output, such as " Logan McNeil " + " ’s birthday is in " + " 103 " + " days " .

Option Analysis:

A. Format Date, Increment or Decrement Date, Extract Single Instance, Format Text: Incorrect. Format Date converts dates to strings but doesn’t calculate differences. Increment or Decrement Date adjusts dates but isn’t suited for finding days until a future event. Extract Single Instance is for multi-instance fields, not relevant here. Format Text adjusts text appearance, not numeric calculations.

B. Build Date, Format Date, Extract Single Instance, Format Text: Incorrect. Build Date creates a date from components, useful for setting the next birthday, but lacks the difference calculation. Format Date and Extract Single Instance don’t apply to the core need.

C. Date Difference, Format Number, Text Constant, Concatenate Text: Correct. These functions cover calculating the days, formatting the number, adding static text, and building the final string.

D. Increment or Decrement Date, Format Number, Text Constant, Concatenate Text: Incorrect. Increment or Decrement Date can’t directly calculate days to a future birthday without additional complexity; Date Difference is more appropriate.

Implementation:

Use Date Difference to calculate days from today to the next birthday (adjusting the year dynamically with additional logic if needed).

Apply Format Number to ensure the result is a clean integer.

Use Text Constant for static text ( " ’s birthday is in " and " days " ).

Use Concatenate Text to combine Worker Name, static text, and the formatted number.

References from Workday Pro Integrations Study Guide:

Workday Calculated Fields: Section on " Date Functions " explains Date Difference for calculating time spans.

Report Writer Fundamentals: Covers Concatenate Text and Text Constant for string building in reports.

The scenario describes a Core Connector: Worker integration configured to output Position Title and Business Title fields for workers who meet the Integration Population Eligibility criteria (Is Manager = true), with the Transaction Log service subscribed to the " Position Edit Event. " The integration is launched with specific date parameters, and a test is performed by updating Jared Ellis’ Business Title via an " Edit Position " action. Jared is a manager, and the change is logged with an effective date of 05/27/2024 and an entry moment of 05/24/2024 07:58:53 AM. Despite this, Jared does not appear in the output. Let’s analyze why and determine the configuration element that needs modification.

In Workday, the Core Connector: Worker integration relies on the Transaction Log service to detect changes based on subscribed transaction types and processes them according to the date launch parameters. The integration is configured as an incremental run (since " Last Successful " parameters are provided), meaning it captures changes that occurred since the last successful run, within the specified date ranges. The date launch parameters are:

As of Entry Moment: 05/25/2024 12:00:00 AM – The latest point for when changes were entered into the system.

Effective Date: 05/25/2024 – The latest effective date for changes to be considered.

Last Successful As of Entry Moment: 05/23/2024 12:00:00 AM – The starting point for entry moments from the last run.

Last Successful Effective Date: 05/23/2024 – The starting point for effective dates from the last run.

For an incremental run, Workday processes changes where:

The Entry Moment falls between the Last Successful As of Entry Moment (05/23/2024 12:00:00 AM) and the As of Entry Moment (05/25/2024 12:00:00 AM), and

The Effective Date falls between the Last Successful Effective Date (05/23/2024) and the Effective Date (05/25/2024).

Now, let’s evaluate Jared Ellis’ change:

Entry Moment: 05/24/2024 07:58:53 AM – This falls within the range of 05/23/2024 12:00:00 AM to 05/25/2024 12:00:00 AM, so the entry timing is captured correctly.

Effective Date: 05/27/2024 – This is after the Effective Date of 05/25/2024 specified in the launch parameters.

The issue arises with the Effective Date. The integration only processes changes with an effective date between 05/23/2024 (Last Successful Effective Date) and 05/25/2024 (Effective Date). Jared’s change, with an effective date of 05/27/2024, falls outside this range. In Workday, the effective date determines when a change takes effect, and incremental integrations rely on this date to filter relevant transactions. Even though the entry moment (when the change was entered) is within the specified window, the effective date being in the future (relative to the integration’s Effective Date of 05/25/2024) excludes Jared from the output.

To include Jared Ellis in the output, the Date launch parameters must be modified. Specifically, the Effective Date needs to be adjusted to a date that includes 05/27/2024 (e.g., 05/27/2024 or later). This ensures the integration captures changes effective up to or beyond Jared’s edit. Alternatively, if the intent is to process future-dated changes entered within the current window, the integration could be adjusted to consider the entry moment as the primary filter, though this would typically require a different configuration approach (e.g., full file mode or a custom report, not standard incremental behavior).

Let’s evaluate the other options:

A. Integration Population Eligibility: Set to " Is Manager = true, " and Jared is a manager. This filter is correct and does not need modification.

C. Integration Field Attributes: Configured to output Position Title and Business Title, and the change to Business Title is within scope. The field configuration is appropriate.

D. Transaction log subscription: Subscribed to " Position Edit Event, " which matches the " Edit Position " action performed on Jared. The subscription type is correct.

The mismatch between the integration’s Effective Date (05/25/2024) and Jared’s change effective date (05/27/2024) is the reason for exclusion, making B. Date launch parameters the correct answer.

Workday Pro Integrations Study Guide References

Workday Integrations Study Guide: Core Connector: Worker – Section on " Change Detection " explains how effective dates and entry moments govern incremental processing.

Workday Integrations Study Guide: Launch Parameters – Details the roles of " Effective Date " and " As of Entry Moment " in filtering changes, emphasizing that incremental runs focus on the effective date range.

Workday Integrations Study Guide: Incremental Processing – Describes how future-dated changes (effective dates beyond the launch parameter) are excluded unless the parameters are adjusted accordingly.