Sunday, November 21, 2021

Workday Studio

 Workday Studio - Complex Integration Tool

limitations - 

EIB Inbound  ---> 300 MB

EIB outbound ---> 1 GB


Workday Studio Usages:

1. No data limitations

2. Using API's Data calling

3. Offer letter Design or company's any PDF formats design with workday studio

   (BIRT  Business intelligent  reporting tool).

4. you can merge 2 custom reports(Advanced)

5. Complex validations 


Project Explorer - This is a local work space, it it used for create a new studio project as well as Edit the existing project

Cloud Explorer   - This is a Tenant work space or connection, it is used to see the list of studio projects are available in workday tenant level


1.Install Studio 

2.Connect Studio 

Create and Modify studio program in Project explorer (Local Work Space)

Deploy to Workday (Cloud Explorer)

How to take backup

1.Studio level with export option

2. view cloud collection ( download clar file directly)


lp.getsimpledata('name')


lp.getsimpledata('Date')


lp.getdata('Location')


Hellooolllllll @{lp.getSimpleData('name')}


Hellooolllllll Ramu


If you want to print variable into Text - we should use below MVEL expression syntax


@{} - MVEL Expression standard syntax


@{lp.getsimpledata('name')}



https://wd5-impl-https://wd5-impl-services1.workday.com/ccx/service/customreport2/abbott_gms1/Gjr/Test_31_Studio_Outbound


https://wd5-impl-services1.workday.com/ccx/service/customreport2/abbott_gms1/Gjr/Test_31_Studio_Outbound?format=simplexml



@{intsys.reportService.getExtrapath('Test_28_Studio_outbound')}



SOAP Request - Request message created and excute with endpoints to get the response 

               example - workday webservices - getworkers,getloactions...ect


REST         - Based on URL access we will get the data

               example - reports are rest opeartions



Rass Report - If custom report enable as webservice, we can call it as rass report service


Studio Log File Syntaxs -


props['p.success.log'] = new java.lang.StringBuffer();


props['p.error.log'] = new java.lang.StringBuffer();


props['p.success.log'].append(props['a'] + ',' + props['b'] + ',' + props['c'] + ','  + props['d'] + ' , One time Loaded  Successfully.  '  + '\r\n')


@{props['p.success.log'].toString()}



props['p.error.log'].append(props['a'] + ',' + props['b'] + ',' + props['c'] + ','  + props['d'] + ','  + context.errorMessage + ' , One time request failed.  '  + '\r\n')



@{props['p.error.log'].toString()}



props['p.error.log'].append(props['a'] + ',' + props['b'] + ',' + props['c'] + ','  + props['d'] + ','  + context.errorMessage + ' , One time request failed.  '  + '\r\n')



@{props['a']} 




BIRT --> It is using for company authrozied documents like - HR Letter, Offer letter, Check Print, Hike Letter ...etc



Report Template will migrate to workday via Business form layout


View Business Form Layout - Here we can see the list of all workday custom business form layouts(BIRT)


View Delivered Business Form Layout - Workday delivered Business Form layouts(BIRT)






Hi XXXXXXXXXXX,


Thanks for the details.


I am intrested for below opprtunity, Please find the below requested questions along with answers - 


Kindly 































Saturday, November 20, 2021

CC4

 https://youtu.be/_JtEsoGFFU0

DT

 DT Document Transformation

 

1. Create Integration System -- -> Select template as "Document Transformation"

Getting error like “missing integration attachment services”, so added a dummy file to resolve this error.

 

2. Configure re Integration sequence Generator               . - ->       File sequence:-generator completed

3. Go to core connector                > Configure Integration Attribute             - > output document tags

·- - -> create document tag (Test _31_out put Tag)

4. Go to DT --> Configure Integration Attributes                >

input document tags ---> select  document tag  for  above custom one  ( Test31_outpu t_Tag )

5. Create a Business process at core connector level --->               add a new step in BP select type as integration - - ->                Configure

 

6. "'  "**"'Prepare a DT (xslt )  against core connector output file_.  Later we will

delegate dummy attachment service in DT and attach the above create exact DT file


CC3

 CC3

https://youtu.be/GGBhPxqE6AA

CC2

 https://youtu.be/D4KQX777wR0


Thursday, November 18, 2021

Core connectors

Core connector: It is a collection of integration services(i.e.Integration template)

Logic:For first time it will send a full file, later it will send only changes from last successful run time to till date.

Mainly we can use change deduction logic to send only changes from last successful ran to till date, also when ever we need full time option, yes we can ran i.e. both options are available.

Core connectors are mostly useful for out bound integrations(80%).


What are the difference between EIB ,Core connectors &Workday studio?

In what cases you are going to use EIB ,Core connectors &Workday studio? Can you explain more with examples?


Core Connector for HCM -Templates:

Core Connector: Worker

Core Connector: Positions

Core Connector: Locations

Core Connector: Job Requisitions

Directory Service

E-Verify - Employment Verification

Core Connector: Job Profile and Job Family

Core Connector: Organization Inbound

Core Connector: Organization Outbound

 

Integration - Templates:

Enterprise Interface Builder  (EIB Related)

Cloud Integration Template   (Studio related)

Document Transformation

 

Cloud Connect for Benefits - Templates:

CIGNA: Medical, Dental, Wellness, FSA

Guardian: Dental, Vision, Insurance

Delta Dental of CA: Dental

Aetna: FSA, HSA, Life, Disability

MetLife: Dental, Vision

HealthPartners: Medical, Dental, Vision, Rx

 

 

 

Cloud Connect for Third Party Payroll - Templates:

Payroll Interface

PI External Results Inbound (Do Not Use)

Import External Payslips

Payroll Effective Change Interface

PECI - Merge Files Integration Template

External Payroll Results Inbound

Worker Effective Change Interface

 

iLoad- Templates:

iLoad Bulk: Process Input File Template

iLoad Bulk: Doc Splitter


Access the report - Integration Template Catalog to view all the integration templates that Workday is offering.


EIB Outbound3

 EIB Outbound3


https://youtu.be/B1eki0yoLiA

EIB Outbound2

 EIB Outbound2


https://youtu.be/gw1BzQynCJg

EIB Outbound1

 EIB Outbound1

https://youtu.be/UEvw3W54XgE

EIB Inbound3

 EIB Inbound3:

Spreadsheet key and Row ID:

https://youtu.be/r6sS1t2v5kI

EIB Inbound2

 EIB Inbound2 

https://youtu.be/297q9JtQaGY

Tuesday, November 9, 2021

Index

 1.Reporting

2.Calculated fields

·         Calculated Field Concepts

·         System wide vs. Report Specific Calculated Fields

·         Global Calculated Fields (e.g. Constants)

·         Calculated Field Dependencies

·         Available Functions, such as:

·         Date Calculation and Formatting Functions

·         String and Text Functions

·         True/False Conditions

·         Evaluate Expression

·         Lookup Functions to leverage hierarchies

·         Functions that access Related Business Objects

·         Lookup Value as of Date

·         Arithmetic Calculations

·         Key Reports & Resources

3.Integrations

·         Integration Architecture Overview

·         Integration cloud Connect.

·         Integration System templates.

·         Core Connector: Worker.


   4.Core connector

·         Integration Services in Core connector.

·         Change Deduction Procedure in Core Connectors.

·         Integration business Process.

·         Core Connector: Worker.

·      


     5.EIB

·         EIB Overview

·         EIB Design Pattern

·         EIB Limitations.

·         Workday Public Webservices overview.

·         Workday Reports-as-a-Service

·         Developing an Inbound EIB.

·         Developing a Outbound EIB.

·         Custom Report Transformation.

·         EIB Features.

·         Loading Customer Transactional Data into Workday using EIB's.




5.DT


Reports 1-14

calculated fields 15-22

EIB 23-27

Core connector 28-30

DT 31

Workday Studio 33-38





Integrations

 Integrations:

Key elements in integration:

Integration ID'S:it is used for integrations all web services will accept integration id's which are eligible

WID: System generated one and we can't override

Reference id:System generated one and we can override

External Reference id:User can maintain external reference id for specific conditions.

Web services:It is using for only integrations. So we will import/export the data in workday.

Task->Business process(Approvals)->Web services

1. EIB(Enterprise interface builder)  Simple Integrations

Inbound EIB:Using the webservice spread template we processing the data in workday generally we called as EIB inbound.

Inbound: Import the data into workday from flat file.

Out bound:export the data from workday into flat file.

2.Core connector

3. DT

4.Studio


Calculated Fields3

 Calculated Fields3

1.Date Difference



Output:



1.Increment and Decrement Date:


Output:

3.Look up value as of Date:


Output:




1. Sub string text:






Output:







1.Date Difference


Output:



Output:





1.Evaluate expression:Nested if conditions(Multiple conditions):




Output:





1.Convert Currency:



Output:





1.Date Difference:



Output:

Output:


Output:




1. Agree gate related instances:(Unique relationship):


Output:







1. Arithmetic calculation:



Output:






1.Concatenate Text:







1.Convert text to number:


Output:






We can't convert text to numeric. So in output it is 0.
Output:






1.Count related Instances:




Output:



Output:




1.Sum Related Instances: When RBO sum


Output:




When we migrate the data from RBO to PBO at that time we can use Extract single instance.

1.Extract single instance:


Before output:



Output:




1.Extract Multi Instance:




Output:



1.Look up related value:





Output:




1.Language


Output:












1.Date Difference

HTML2

 1. <HTML> <HEAD> <TITLE>RAJ BLOG</TITLE> </HEAD> <BODY> <H1>Raj documents</H1> <H2>Ra...