WorkDay Tutorial-ACTIVITY —USING CUSTOM REPORT TRANSFORMATION

 Scenario: Logan has been asked to change the resulting file from this integration to output a pipe delimited file with a heading that reads “WICT GMS New Hires” and Footer as “End of Data”.

TASK 1: CONFIGURE EIB TRANSFORMATION 

1.       Search for WICT NewHireIntegration. Be sure to select the Integration or All of Workday category and use the related action to access Enterprise Interface > Launch Configuration

Wizard 

1.       Select the Get Data icon and remove any previously configured Alternate Output Format. 

2.       Select the Transform icon 

3.       Notice the New Custom Report Transformation radio button is selected and then click Save. 

4.       Notice the warning message that your configuration may not be complete.



5.       From the integration system related action menu, select

Enterprise Interface > Configure Transformation




6.       Enter “|”  (pipe) in the Delimiter field 

7.       Click the row for Legal Name Last Name. Change the Column Heading Override to read 

Last Name”. 

8.       Repeat the actions to change the Column Heading Overrides to read “First Name” and “Total Base Pay”.





9.       Click the Header tab and enter WICT GMS New Hires as the Optional Report Header 

10.   Click the Footer tab and enter End of Data as the Optional Report Footer. 

11.   Click OK and Done 

TASK 2:  LAUNCH INTEGRATION SYSTEM AND REVIEW OUTPUT FILE 

1.       Search for WICT NewHireIntegration . Remember to select the Integrations category. Choose Integration > Launch/Schedule from the related action and Run Now. 


2.       Enter January 01, 2013 for the start date and today as the end date for the launch parameters.


3.       Click OK and Refresh to monitor progress.


       4.       Download the output file and open in a txt application, like Notepad. Notice the file is pipe delimited and contains the header and footer as you configured.