Pages
- Home
- Basics
- Workday
- Index
- Reports1
- Navigation
- Tasks
- Key elements
- W1
- W2
- W3
- W4
- W5
- W6
- W7
- W8
- W9
- W10
- W11
- W12
- W13
- W14
- W15
- W16
- CF17
- CF18
- CF19
- CF20
- CF21
- Simple vs Advanced Report
- Calculated fields
- Authorization
- Report Properties
- A1
- Check employee data
- Sort & Group
- Outline structure
- Prompt
- Values
- Output
- Check Report
- Share
- Advance
- Matrix Report
- Matrix Report
- Matrix2
- Composite
- Trending
- Dashboard
- Calculated Fields1
- Calculated Fields2
- Calculated Fields3
- Integrations
- EIB I1
- EIB I2
- EIB I3
- EIB O1
- EIB O2
- EIB O3
- Core connectors
- CC1
- CC2
- CC3
- CC4
- Workday Studio
- DT
- Prefix
- WQ
- WQ2
- Transport
- RReports
- PECI vs PICOF
- RID''s
- XML
- HTML1
- HTML2
Tuesday, November 30, 2021
Monday, November 29, 2021
Sunday, November 28, 2021
Saturday, November 27, 2021
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
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
Friday, November 19, 2021
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.
Wednesday, November 17, 2021
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
1.Increment and Decrement Date:
3.Look up value as of Date:
1. Sub string text:
1.Date Difference
1.Evaluate expression:Nested if conditions(Multiple conditions):
1.Convert Currency:
1.Date Difference:
1. Agree gate related instances:(Unique relationship):
1. Arithmetic calculation:
1.Concatenate Text:
1.Convert text to number:
1.Count related Instances:
1.Sum Related Instances: When RBO sum
1.Extract single instance:
1.Extract Multi Instance:
1.Look up related value:
1.Language
1.Date Difference
HTML2
1. <HTML> <HEAD> <TITLE>RAJ BLOG</TITLE> </HEAD> <BODY> <H1>Raj documents</H1> <H2>Ra...
-
Technical: Reporting: Report writer and Calculated fields Report Writer: 2 types 1. Workday delivered reports(Workday standard reports): S...
-
PECI vs PICOF Firstly we need to know the two common terms most frequently being referred in Payroll integrations PICOF abbreviat...