Reporting
1. What is the relation between Business objects and Data sources in
Workday?
Workday stores your data as business objects. A business object can be
defined as a template of an entity, whereas a data source is the data selection or
group of data that creates the template.
Data sources are defined and delivered by Workday. Workday delivers
various data sources for primary business objects. A data source can be designed to
return all instances of the primary business object, or it can have built-in filtering
logic defined by Workday
2. What is Matrix Report?
Matrix reports are similar, but not identical to pivot tables and cross tabs
found in other systems. You group data in a row group and optionally a column
group. Values in the matrix cells display aggregate values scoped to the
intersection of the row and column groups to which the cell belongs.
3. What is RAAS?
You may create custom reports and enable them as a web service to be
used in an Outbound EIB (Enterprise Integration Builder) as a data source. If you
select this option, then you must also define Column Heading Override and Group
Column Heading values on the Columns tab, and provide Label Overrides for all
prompts on the Prompts tab.
4. What is Worklets?
A worklet is a report that can be displayed in a "tile" on the Workday
"landing pages", which are: My Workday, All about Me, and My Team, and the
Dashboard slide-out. Worklets provide users quick access to frequently referenced
data and tasks common to a specific functional area.
You can create your own Worklets by using the Report Writer and
specifying either the advanced or the matrix report type, and then selecting Enable
as Worklet on the Output tab. If you choose to share a worklet, it becomes
available for authorized users to select when configuring their Workday landing
pages.
5. What is Trended Worker Data source?
Trended Worker Data source encompasses a number of fields that fall into
3 general categories:
Monthly worker snapshots: This type of data includes data about workers as of the
last day of the month, including compensation data, headcount numbers, and
biographical information.
Staffing events: These include hires, terminations, transfers and promotions
changes in position, addition or deletion of additional jobs, move events, and
international assignments.
Calculated metrics: These are calculations, we can make based on the trended data,
such as turnover rate and span of control.
Workday automatically updates the Trended Workers data source at the end of
each month. Data is collected for the last 36 months (that is, data is collected for as
many months that are available in Workday, up to 36 months). Any data older than
36 months is automatically purged from the data source. Additionally, any
retroactive changes that have been made to a worker in the last 3 months are
automatically incorporated into the trended data.
6. What is Trending report?
Using Trending Report, Workday enables to report on and analyze trends
in worker data such as headcount and attrition through a number of Workday
delivered standard reports. We could create custom Trending report types that use
trended data. By using either standard reports or custom reports, we can analyze
important trends in our workforce directly in Workday, without the need for a
third-party analytical tool. At the core of all trending report types is the Trended
Workers data source.
7. What are the ways to create a report in Workday?
You can create a report in two ways in Workday:
● Run the Create Custom Report task.
● Copy a Workday Standard Report and modify it
8. If a particular report is shared within the organization, will anyone be able
to see the same output while running the report with the same input values?
No, the output will depend on the security access to the data source of the
individual who is running the report.
9. What are Calculated Fields?
A calculated field is used for data manipulation. It is used in reporting,
integrations, business processes, scheduling recurring processes, and other areas
within Workday.
You should run the Create Calculated Field task to create calculated fields.
Some of the essential things you can perform with Calculated Fields are
currency conversion, lookup-related values, string or text manipulation, evaluation
of an expression, format a date, etc.
10. Name a few ways of how to access a Workday Standard Delivered
Report?
The following are the ways to access Workday Standard Delivered Report:
● Browsing by Category in the Sitemap
● Writing the name of a specific report in the search bar.
● Running Workday Standard Reports
11. How to improve performance of the Reports?
We are using filters, sub filters and prompts concepts in the reports for
reducing the Data. Then it’s automatically performance will be increased. It
decreases the system load and managing all needed records easily.
12. What is the purpose of the web service enable option?
We enable web service option in our report, it allows accessing that report
anywhere using through Web services. It is one of the portable and important
options of the workday.
13. What do you know about matrix reports?
A matrix report compiles data into a grid. It enables you to gather data in
both rows and columns. This kind of report to sort by two dimensions upon a
report.
14. Explain the trending report?
Trending report is used by workday to enable a report and analyze
trends in worker data like headcount and reduction through a number of Workdays
remitted standard reports. We could create custom Trending report types that use
trended data. Using either custom reports or standard reports, we can analyze
significant trends within our workforce undeviatingly in Workday without a third-
party analytical tool requirement. At the core of all trending reports, types are the
Trended Workers data source.
15. Tell me about Process Monitor?
Process monitor is a process to known about our present execution
status of the process. And its best way to checking and managing our process of
execution before executing.
16. What is the difference between reports and templates?
Reports are designed and built by customers or functional users using
the Workday Report Writer tool. They can be created new or as a copy of another
standard or custom report. Workday reports are actionable where you can drill
down on items to obtain additional information and use related tasks to perform
authorized actions on items within that report. As we will see, custom reports can
be scheduled, translated, shared, and more features are available.
Templates have built-in features that extend functionality to end users of
Workaday hcm. It contains different services, Attributes and Maps to build and
managing the integration system. We have different types of templates are
available in workaday, and have special features each of the template. Its take less
time to build own integration and it is more flexible. Great look and fell, user
interface are different from reports.
17. What is data source?
It is nothing but a view one primary business object and number of related
business objects.
18. What is business object?
It is nothing but a table like SQL
19. Types of custom reports?
1. Simple report
2. Advanced report
3. Matrix report
4. Composite report
5. N box report
6. Search box report
7. Trending report
8. Transposed report
20. What is difference between simple and advanced reports?
Simple Report Advanced Report
1. Simple Report we can’t pass the 1. Advanced Report we can call the
integration level. integration level.
2. Share tab is not available in simple 2. Share tab is available in Advanced
report Report
3. Only 3 tabs are available in Simple 3. 7 tabs are available in Advanced
Report. Report
21. What is difference between filter and Sub-filter?
Primary business object we can use in Filter level
Related business object we can use in Sub-filter level.
22. What is difference between ESI and EMI?
Ex: Employee get salary changes in 5 times by using extract single instance
We can get any single row of data either first occurrence (or) middle
occurrence (or) last occurrence
By using extract multi instance we can get all rows at a time.
23. What is difference between calculated fields and custom fields?
Calculated fields we have doing validations, data formatting and
different type of functions write in calculations.
Custom fields mean some additional fields we can maintain.
24. What is difference between matrix and composite report?
Matrix Report Composite Report
1. Data Source use in Matrix Report. 1. Business object use in composite
report.
2. At a time one data source use in
report. 2. Multiple data sources call in
composite report.
3. Non Configurable calculations do
total counts, averages etc., 3. Configurable calculation: sum,
difference, multiply, divide in
Composite Report.
25. Complex task in reporting?
I have a requirement for matrix report my business wants to see the all
head count of each country & cost center wise for that purpose I have created one
new custom report.
STEPS:
1. Firstly given report name, report type matrix, data source all active and
terminated workers.
2. Basically in matrix report most important tabs matrix & drill down
3. In matrix tab has 3 main elements row grouping, column grouping,
summarize
4. I have selected location address and country in row grouping
5. Coming to drill down tab here my business wants to see the view details of
each country and cost center, region, company, employee
6. I have selected required fields in detailed element.
7. Based on that my business seen the all country details.
26. Can you please tell me difference between simple and advance report
Simple Advanced
1. Few additional Properties are not 1. All properties are available in
available in Simple report like Prompt, Advanced Report
output, share, Advance
2. we can select only PBO data in 2. we can select PBO data as well as
Simple Report RBO data in Advanced Report
3. you can't share this report to anyone 3. you can share this report to every
one
4. you can't use this report in any of 4. you can use this report in
the integrations integrations
27. What are the steps to create a report?
1) Choose Report type and Data Source
2) Select Objects and Fields
3) Order Columns
4) Sort Output
5) Define Filter Criteria
28. What are the Data sources?
1. A Data source defines a particular set of Business objects instance for
reporting purpose
2. Data source is similar to Data Base view ,But Data source is more
flexible
3. Data source can return hierarchical data structures
4. Data source Automatically allows the access to all business objects
related to those in
5. The data source.
29. What are the Business objects?
1. Business object is one of the main parts in Workday for retrieving
fields Data.
2. Work Day stores data as Business objects, Business object has Fields
and Instances.
3. A Business objects is composed of set of related fields like Data Base
Tables.
4. Fields acts as DB columns, Instances acts as DB Rows in workday.
5. Business Objects Automatically links Related Business objects
(RBO’s) to access customer need Fields.
30. What is the difference between Run and Test in reports?
Run is used to be executing all functionalities of the Data in Reports at a time
to produces end of the output file. Test is executing the limited files of Data in the
reports for testing purpose and it displays the limited records of the output file.
31. What is the difference between Report and Custom Report?
Custom reports are designed and built by customers using the Workday
Report Writer tool. They can be created new or as a copy of another standard or
custom report. Workday reports are actionable where you can drill down on items
to obtain additional information and use related tasks to perform authorized actions
on items within that report. As we will see, custom reports can be scheduled,
translated, shared, and more features are available.
32. In Filter which fields will be use?
Specify the filter that should be used in the report for filtering data that I will be
used fields are hire date, employee Type.
33. What’s the difference between Filters and Sub filters?
Filtering is the one of option of the workday, it include ability to use
comparison Types, and it filters value of given condition. The main difference
between filter and sub filter, the sub filter logic is executed first comparing to filter
logic. Sub filter interact with PBO for given instances. It checks the condition
given value match the Dependent is RBO. Filter is reference to RBO checks first
then goes to the PBO.
34. Is it possible to the calculated field can be copy or edit?
Yes, it is possible Any user with access to the domain, we can manage
create/edit/view/delete any system-wide calculated field definition in the tenant.
36. How can you change simple to Advanced Report?
You can create custom reports as an Advanced report type from the start,
however, if you started with a Simple report type, there is an option to convert the
report from simple to advanced. Using the related actions on your report definition,
select Custom Report > Change to Advanced Report Type
35. What is CFBO?
Calculated fields are associated with a business object (BO). This BO is
referred to as the Calculated Field Business Object (CFBO). The CFBO controls
the fields are available when creating the calculated field. There are calculated
field function types that enable you to retrieve values from related business objects
(RBOs). Any calculated fields you create for a business object appear and behave
just like any other Workday- delivered fields for the business object. The business
object on which you base your calculated field (CFBO) also controls when the
calculated field appears in prompts and reports.
36. What is the purpose of the web service enable option?
We enable web service option in our report, it allows accessing that report
anywhere using through Web services. It is one of the portable and important
options of the workday.
About Reporting:
Report Writing is an essential skill needed for almost any advanced
interaction with Workday, and any Workday Professional (in our opinion) needs to
know Report Writing to perform their job duties successfully. Whether your job
includes helping a client through an implementation, perform data conversion,
configure business processes, configure security, develop integrations, or
administer any module in Workday, you need to be able to run and build custom
reports.
37. Name two types of Workday Standard Reports and a difference between
them?
Report writer Reports and XpressO reports. Report Writer can be copied and
customized, but you cannot copy XpressO reports.
38. Which prefix limits a search to reports?
“ rd: ”
39. What is the relationship between a Business Object and a Data Source?
Give an example.
The Business Object serves as a template of an entity, and the Data
Source is the data selection or group that will create that template. In Workday,
one example of a Business Object is ‘X Employee’ and for a Data Source, ‘All
Active Employees’ – a report with these two selections should only return active
employees within the organization. A scenario outside Workday could be a
Business Object called ‘Country’, and a Data Source named ‘All European
Countries’ – this non-Workday example should return Spain, Portugal, France,
Germany, Italy, etc.
40. which delivered report can provide the relationship between data source,
business object and security groups that have access to those?
The “Data Source” Workday delivered report.
41. Name some types of Class Report Fields
Currency, Boolean, Date, Numeric, Text, Object, Self referencing instance.
42. If you share a report with everyone within your organization, will anyone
be able to see the same output when running the report with the same input
values? Why?
No, the output will depend on the security access to the data source of
the person who is running the report.
43. What is a Calculated Field? How can you create one? What can you do
with it?
A Calculated Field is a field created to manipulate existing data.
To create a Calculated Field you can run the Create Calculated Field task. Some of
the things that you can do with Calculated Fields are: lookup related values,
currency conversion, string or text manipulation, evaluate an expression, format a
date, etc
44. How do you create Report?
Report creation following simple steps, Initially you search for
CREATE CUSTOM REPORT in search Box, then appears a new window on
your system it asking report name , select the Data source and select report
type ,you fill the all information after click OK ,next another screen you can see
options like column, sort, filter, prompts, output, share and Advanced etc, then
you choose column then select the Business Object ,and Field next click “ + ”
button for Adding columns. After choose sort option for sorting Ascending or
Descending the fields of data, then select Filtering and sub filtering tab’s for filter
the data .Prompts are used in Reports give Runtime parameters. An output option
is used for displaying output format in the Report. In Share option default selected
don’t share others for security. Advanced option, you choose the web services
enabled for retrieve data this Reports data then click Save and Run the report and
then you can see the resulted output in Excel file.
45. Tell me about the data types (PBOs / RBOs) that you have used most
often, during your last project?
Mostly I have used organization (recent project), worker (often),
RBO (division, country).
EIB
1. Why we are using EIB integrations?
EIB is simplest integration system to build and requires little to no programming
and you can define one source, one transformation and one delivery point that we
mostly prefers the EIB integration.
2. How can you do changes in XSLT?
We can use XML attachment transformation and custom transformations that you
create by using extensible style sheet language transformation (XSLT). Workday
does not generate or validate your XSLT attachments. These attachment XSLT can
be used in EIB, studio and Document transformation.
3. What are the EIB limitations?
EIB’s are purely imported a single data file and it have one data source ,one
transformation and one delivery point and It doesn’t allow multiple data sources,
transformations, delivery. It doesn’t support multiple input files and output files
and no error handling capabilities. It doesn’t supports change detection, validation
and transaction logs. EIB have limited storage data.
4. What are the transformation types in EIB?
EIB allows only one transformation in Workday, we use mainly XML
transformation using in EIB.
5. What is the difference between Custom report transformation and Custom
transformation?
Workday provides these transformations for build own integration purpose of EIB
of lies partly in the fact that users can create own.
Custom report transformation is used to convert report into something that can
understand external system. Main difference is It converts report into understand
EIB integration format.
Custom transformation is convert the already existing data into understand the
required format of other system, we can use processing data of integration EIB
included.
6. What is the difference between ILoad and EIB?
When you need to load a small volume of data on a tenant on an ad-hoc basis or
day to today activities, then you go for EIB.
If you need to load for high volume of data and that is initial conversion of data
from External system to workday. Apart from this all report, EIB and any
integration you can migrate from either implementation/sandbox to production by
using I load.
Solution is another tool which is used to migrate reports, eib and any integration
from one tenant to another tenant.
7. Complex integration in EIB?
Recently I have created eib integration for request one time payment,
so the challenge here actually all the bonus and compensation we are loading
request one time payment here one time payment we are maintain all employee
details information and some additional worktags like project, region, product
These three information is added into additional worktags , if generate
that eib these those additional custom worktags are not appearing into
your eib template getting issues like that required worktag information
is missing, so I could observe that and i reading something in community
and can able to understand how I can this is like additional tags so
i just go to view template mode in eib and then simply go to default
worktag section and go manually added the project, region, product and
regenerate the template make sure that template has been update correct data after
that i map all data rerun the process it went to success.
8. What is difference between eib and core connector?
EIB Core Connector
1. One Web service we can use in 1. Multiple web services we can use
EIB. in Core Connector.
2. It generates the single file. 2. It Generates the 6 files.
3. No services options available in 3. Coming to Core connector 24
EIB. services are available.
4. In EIB some limitations are their 4. There is no limitations in Core
eib inbound it supports 30MB Connector.
file eib out bound it supports
300mb file only.
9. What is sequence generator?
Sequence generator enables in our integration to generate unique
sequenced file name each time its runs.
10. What is transaction log?
By using transaction log we can reduce the integration run time.
and also it is pick the specific transaction changes.
ex: personal, compensation.
11. Why you choose EIB and Studio?
EIB: Enter Interface Builder to Build The own Simple and Secure
Integration based on your unique Business need with Work Day
You can use these EIB to build both inbound and outbound integrations.
EIB defined an Integration That has one Data source, one Transformation and
one Delivery point and It allows XML files.
You can choose Set predefined (XSL) Transformation to presented output in Excel
and CSV format.
It’s Deliver the External system endpoint using SFTP, FTPS, HTTP, Email, Web
dev and AS/2 services and Encrypt the document with PGP key.
Its creation is simple, flexible and No need of code to build the Integration, so
mainly Prefer the EIB’s
Workday Studio: It is power full Development tool enabling customers and
partners to build sophisticated and highly customized Integration tool from
Workday. It has many functionalities and preferred studio Integration little bit
complex when compare to EIB integrations.
12. When do use Transaction Log ?
The Transaction log to monitor The Events for particular transaction type
or Business process type in workday, and find compare differences that have
occurred in your workday Data within a particular Time period. We uses
Transaction log after Lunching Integration.
12. Differences B/w Report and EIB?
Report EIB
Report tool Build Simple and EIB to Build secure and simple
Advanced reports in Workday Integrations in workday
It doesn’t supports XML files It’s supports XML file and
Transformations
It doesn’t access the External system EIB access the External System
reports data reports Data using by Web services
and Transformations
Reports are More securable because it EIB’s are more flexible compared
runs on our local Machines and don’t to Reports
share others as report wise
It has little bit of code.
Reports are Don’t need of code,
Functional guys are used simply
13. When is eib preferred and studio?
If you want report to built from scratch better to use report tool and to
transform it eib as we all know its tidy process and require a lot of time but on
other hand in studio we can built have same functionalities as eib but it’s an
Extension when facing complex situations it better to use studio.
14. What is the concept of reference ID in Workday?
Reference id plays a crucial role in workday integrations. It is divides in to
type a value. We allocate reference id to instance of business object. Types can be
same but value should differentiate. For example let’s consider business objet
instance like French, English etc
Which has type of language_id but value something else which differ for every
instance. It is assigned by workday using sequence generator, but we
can edit them and
remember not assign same id value to same business instance cause problems
especially in mapping when referencing the internal value
With external when both instance have same id cause problems in mapping in
overriding the value.
15. What are the building blocks of an EIB integration?
get data(from web services, SFTP, workday attachment, custom report
etc). Transformation to desired output.(.csv, custom xslt, custom report).
(delivery)Transport Protocol (for sending data to external system using these.).
16. What are the different options available to test a document delivery
configuration in Workday?
Create a definition and configure the retention policy and the address to be
delivered the dress and protocols used to deliver it, give a tag name to
Distinguish itself from other files. Attach it in a business process
🡪Launch a integration🡪later test whether it reached its destination by checking it
on server, or using test document which gives the preview of the file on external
system.
17. Have you developed and / supported Workday Integrations in the last 2-3
years?
Yes, I was mainly on the supporting side also a very little on the
implementation side.
18. What is the difference between Column heading Overwrite and Column
heading Overwrite XML Alias?
Colum Heading Override XML Alias (on Columns tab), verify the
following headers. You will need to modify Last_Name and First_Name. The
headings cannot contain spaces.
Column heading Overwrite to change the column names if you want them
to be different than the field name. Configure a column heading override for the
Full Legal Name field to be just: Legal Name.
19. Why we are using EIB integrations?
EIB is simplest integration system to build and requires little to no
programming and you can define one source, one transformation and one delivery
point that we mostly prefers the EIB integration.
20. How can you do changes in XSLT?
We can use XML attachment transformation and custom transformations
that you create by using extensible style sheet language transformation (XSLT).
Workday does not generate or validate your XSLT attachments. These attachment
XSLT can be used in EIB, studio and Document transformation.
21. What are the EIB limitations?
EIB’s are purely imported a single data file and it have one data source,
One transformation and one delivery point and It doesn’t allow multiple data
sources, transformations, delivery. It doesn’t support multiple input files and
output files and no error handling capabilities. It doesn’t supports change detection,
validation and transaction logs. EIB have limited storage data.
22. What are the transformation types in EIB?
EIB allows only one transformation in Workday, we use mainly XML
transformation using in EIB.
23. What is the difference between Custom report transformation and Custom
transformation?
Workday provides these transformations for build own integration
purpose of EIB of lies partly in the fact that users can create own.
Custom report transformation is used to convert report into something that can
understand external system. Main difference is It converts report into understand
EIB integration format.
Custom transformation is convert the already existing data into understand the
required format of other system, we can use processing data of integration EIB
included.
24. Explain about schedule future process by date?
Schedule future process by date describes the integration schedule
configurations and time status that they can schedule to run in future.
25. Tell me about Process Monitor?
Process monitor is a process to known about our present execution status
of the process. And its best way to checking and managing our process of
execution before executing.
26. What is the difference between EIB with Studio and Connector with
Studio?
Connectors with studio:-the connectors exists and outputs most of
required data field of studio. We can use studio to enrich the output of workday
connector and it needs to require multiple and complex XSLT style sheets for
processing integration, it can be completed in less than 2hours.
EIB with studio:-it maintains error handling and validation based on condition
logic, we can use multi files and web services exists in order to support the require
functionality and it imported need to custom objects.
About Integrations:
Integrations are crucial when communicating external systems with
Workday. To be able to say you master them means that you understand
how data can be imported to or exported from Workday. Thankfully,
there are predefined rules of how that data must look like, and public
interfaces you can access anytime you need to build integration. In this
set of integration questions, we do not attempt to test the mastery of the
different Workday Integration tools available, but the general knowledge
of how to build integrations.
27. What are the main types of Workday Integrations and how do you select
which solution to use?
The main types of integrations are Workday Studio Integration, Enterprise
Information Builder (EIB) Integration and Cloud Connect Integration.
When deciding over which tool to use we need to take into account some factors;
whenever you take in the design of an integration, from the requirements you
should follow a roadmap, here is an example of it:
Is the solution already pre-built? Am I connecting to a third-party vendor with a
solution already in place? – If yes, most likely you will choose a Core Connector.
Does this integration just need to export or import some data into Workday? – If
yes, then most likely you need to go with EIBs.
Do I need to execute several rules, and reports to get the data and calculate the
results I need? For example: Determining payroll between Exempt and Non-
Exempt employees, calculate deductions, etc. – If yes, then most likely you need a
Workday Studio Integration.
28. Name a prefix you can use to search for integrations:
“intsys:”
29. Name some Integration ID types:
Workday ID, External ID, Reference ID
30. Name some input and output types for EIBs:
Input: SFTP/FTP, REST, or attachment
Output: SFTP/FTP, HTTP, Email, CSV, JSON, XML, etc
31. What do you use XSLT for in an integration?
You use XSLT to transform the input or output data going into an XML
document.
32. What is a WSDL? Why are they important?
WSDL stands for Web Service Description Language, and they are
important because they specify how XML documents should be formatted to be
accepted as input or define the output of Workday Web Services.
Say that you have a data warehouse or an external system that needs to be
updated when an employee changes their information in Workday. What
integration should you use?
Core Connector: Worker
33. What is the name of the XML query language you can use to select
elements from an XML?
Xpath
Core Connector
1. What is the difference between CCW and PI?
CCW and PI are having same working environment and look and feel, but slightly
differences are [Link] mainly concentrates on Worker operations and
managing employee data operations based on Worker Business object. It usually
performs operations on worker personal information, worker positions and worker
compensation.
Payroll interface explain about payroll information and it allows you to manage
payroll related data and send it to a third party payroll provider, And it provides
data changes, promotion, address change, Hire, Transfer, leave of absence and
payment process are can be processed in the payroll system.
Lunching parameters are different of PI and CCW.
2. Can you generate multiple files in Connector?
Yes. For example if you need to create 3 files separately, then create 3 DT and
separately write 3 xslt for each file and then each xslt you attach in individual DT.
Then finally these 3 DT you attach to the Connector by business process.
3. What is the core connector in Workday?
Core connectors extend the workday functionality to external systems for Payroll
Interface, Payroll, HCM (Human Capital Management), Speed Management and
Financial Management. All the integrations are managed and hosted by Workday.
4. What is the use of Workday cloud-connect?
The Workday Cloud Connect Benefits an enterprise management suite that gives a
single system to manage the benefits of your employee. The Workforce Cloud
Connect for Benefits helps companies design, implement, and manage various
benefits plans and opportunities.
5. What do you know about packaged connectors?
Packaged connectors are also called delivered ports, are the integration adapters
developed for a particular vendor. We just need to perform some fundamental
configuration to launch them, and no extra coding is required.
6. Why do we use “Field Override Solution”?
Filed Override Solution is used to add additional fields in the connectors.
7. What are The Lunch parameters in CCW?
The Data parameters extract the records that what are the data needed current as of
specified parameters in The Lunching an Integration System.
The CCW has four lunch parameters in Workday ,They are 1)As Of Entry Moment
,2)Effective Date,3)Last Successful As of Entry Moment,4)Last successful
Effective Date
As Of Entry Moment enables you to search for and retrieve future-dated data
changes where the changes has been entered in workday ,but the effective date has
not passed yet.
Effective Date defines the end of date range during which changes became
effective. The integration extracts all changes with effective dates on or before this
date.
Last Successful as of Entry Moment default to the last moment at which the
Integration system was successfully lunched. You can override this date and time
in order to force the Integration to search for and retrieve data changes over a
wider period.
Last Successful Effective Date defines the beginning of a date range during which
changes became effective. The Integration extracts all changes with effective dates
after this date
8. Tell me about a core connector / EIB / Studio that you have created.
I created integration system using pi which we discussed in later document
using ccw we
9. How do you convert the file format of a core connector and studio output,
do they use same process or different process. Describe in detail.
In ccw and pi in the same process where we select the services required for
them and configure them in the integration attributes and we mention that in xslt.
10. Explain Area Override Solution?
Area override solution is utilized to insert extra fields like calculated fields
within the output as those fields are not readily available under any kind of
solution.
11. How or where can you test Core connector worker integration?
We completed implementation part of integration, we check the execution
in tenet of workday, and mostly prefer for testing in sandbox. Then we move the
production environment.
12. What are DT and CCW? What is the relation between these two?
Document transformation integration system template is part of the
cloud connect catalog. It is using only the attach XSLT file for transformations and
we can use specific attributes, mapping values for specific process of integration in
the workday. After transformation DT generates the output.
CCW mainly concentrates on Worker operations and managing employee data
operations based on Worker Business object. It usually perform operations on
worker personal information, worker positions and worker compensations. and TO
get the output using DT in CCW for XML attachments. CCW can’t be proceed
directly XML operations.
13. How many times Delivery attempts?
3 times by default.
14. Which editor you can use for XSLT editor?
We use editors are oxygen, notepad and notepad++ for XSLT in Workday.
15. How can you identify that requirement will be do in CCW, EIB and
Studio?
When we require simplest integration system to build and requires little to
no programming and you can define one source, one transformation and one
delivery point that requirement we mostly prefers the EIB integration.
CCW mainly concentrates on Worker operations and managing employee data
operations based on Worker Business object. It usually perform operations on
worker personal information, worker positions and worker compensations that type
of requirement need to package, We prefers CCW template in the cloud connect
catalog of connectors
If the integration has a high number of use cases, needs to make multiple calls to
web services, process large amount of data and multiple business objects at once,
handling complex errors that requires we can choose Studio.
STUDIO
Workday Studio: It is power full Development tool enabling customers and
partners to build sophisticated and highly customized Integration tool from
Workday. It has many functionalities and preferred studio Integration little bit
complex when compare to EIB integrations.
1. Why Should We Use Workday Studio?
● Complex Integration
● Complex Validation
● Call Multiple custom report at same time
● Generate multiple file at same time
When you need to developed any inbound integration which has to be schedule
daily basis
You can incorporate java code in workday studio
2. Name some MVEL variables that you can use in Workday Studio?
"lp" to access launch parameters.
"vars" to access MessageContextVariables
"props" to access message properties
3. Which Workday Studio component is used to translate a conditional if or a
loop?
Route component is used to translate both conditional if or a loop depending on the
routing strategy.
Conclusion
So now, you have an idea of possible Workday interview questions you could
come across. You may not be explicitly asked these questions in exactly these
words in your interview, but having answers in mind for them makes you more
prepared for anything that the interviewer throws your way.
To master advanced concepts of Workday, join our comprehensive Workday
Course, which equips you with the necessary skills and more that you need and
help you become job-ready upon completion.
4. What is XPath?
XPath uses path expressions to navigate in XML documents and also
XPath is the syntax for defining parts of an XML document.
5. How can you identify that requirement will be do in CCW, EIB and Studio?
When we require simplest integration system to build and requires little
to no programming and you can define one source, one transformation and one
delivery point that requirement we mostly prefers the EIB integration.
CCW mainly concentrates on Worker operations and managing employee
data operations based on Worker Business object. It usually perform operations on
Worker personal information, worker positions and worker compensations
that type of requirement need to package, We prefers CCW template in the cloud
connect catalog of connectors
If the integration has a high number of use cases, needs to make multiple
calls to web services, process large amount of data and multiple business objects at
once, handling complex errors that requires we can choose Studio.
6. How do you select which solution to use?
When deciding over which tool to use we need to take into account some
factors; whenever you take in the design of an integration, from the requirements
you should follow a roadmap, here is an example of it:
Is the solution already pre-built? Am I connecting to a third-party vendor with
a solution already in place? – If yes, most likely you will choose a Core Connector.
Does this integration just need to export or import some data into Workday? –
If yes, then most likely you need to go with EIBs.
Do I need to execute several rules, and reports to get the data and calculate the
results I need? For example: Determining payroll between Exempt and Nonexempt
employees, calculate deductions, etc. If yes, then most likely you need a Workday
Studio Integration.
9. When to use the workday studio?
You have to use Workday studio when you have to do these:
When you have to deal with large sets of data.
Add Spring, Custom Java, or 3rd party capabilities.
When you have to include complex looping.
When you have to include branching logic based on external variables or dynamic
data.
When you have to execute several reports and rules to get your data.
10. How would you describe your experience level with XML, XSLT, X-Path
and web services?
I would tell good xslt is nothing but extensive style sheet of xml it is used
for rendering the xml document. It has tow attributes XTT and ETT transform
XML data to required output.
Xpath as we all know workday is object oriented. It use [Link] store
data using two types of database formats. One we relational and other was
hierarchy database where under parent emit child be present, in those databases to
extract data we use xpath to get the data.
XML is a markup language unlike html it does not present data rather it
store the data in any it was represented web services. There play crucial in
integrations an deport generations. Services like get_worker_payee help in
retrieving the
Worker and payee details. Some be invoked automatically some by
manually.
11. How to get the report by using the workday Studio components?
We get the report by using the web service URL link of the report, navigate to the
report in the tenant and use the related actions menu to view the Web Service
URLs. And click on the Workday XML link to view the report in a browser
window. You can copy the extra path out of the browser URL you will need to
enter a user/password. We create new assembly project in studio called as a report
named and Workday IN transport, workday output Rest transport, and async
mediation with log step after we set the PutIntegrationMessage (PIM) - when the
"Select Parameter" dialog is displayed, click Finish.
Write the components together and configure the other components as necessary.
we save the project and lunch.
Name some MVEL variables you can use in Workday Studio and what are they
used for:
“lp” to access launch parameters, “props” to access message properties, “vars” to
access MessageContextVariables
12. What Workday Studio component you can use to translate a conditional if
or a loop? What good practice you should add to your integration to get
notified of any errors in your Studio integration?
The Route component can act both as a conditional if or a loop depending on
the routing
strategy. Error handlers type send-error are used as a good practice to catch errors
and send them to either the integration event or another output method
via the out-transport.
Business Process
1. What do you understand about the term 'Business Process' in Workday?
In Workday, the business process is a collection of tasks that you can
initiate, act upon, and finish to accomplish the desired business objective as part of
an HR procedure. Business processes define Workday's core functionality. It
describes how significant events flow and allows the configuration of approvals,
notifications, conditions, etc.
Examples of business processes are changing jobs, Hiring, Terminating
Employees, Proposing Compensation Change, and more.
2. Define Workday Business Process Framework.
The Workday Business Process (WBP) Framework enables you to improve
process flows within a company by inducing various activities. It allows customers
to configure and manage core flows within the Workday to connect people, apps,
and services. In the Workday applications, the business process framework is
where all the transaction-related changes to data and events originate.
3. What type of conditions defines Business Process Steps in Workday?
In Workday, Start Proxy is the task that gives all the details of the business
processes involved in the Organization. Business process steps involve validation
condition, running condition, entry condition, and exit condition.
4. Tell me, will business process events be impacted if you modify the business
process definition in Workday?
In Workday, to edit the business process definition, you need to search the business
process name 🡪 edit the definition of the related action.
By creating a new business process definition, the already running business
process won't get affected. It keeps running in the background without causing the
event to overlap.
5. Which task helps you to test assigned steps in the business process in the
organization?
'Start Proxy' is the task used to test the assigned steps in the business
process. Proxy policies are configured from the "Create Proxy Access Policy" task,
and they cannot be executed in production environments.
6. Which type of approvals can you configure in a review step in a Business
Process?
Below mentioned Approvals are to configure in review step in a
Business Process
● Individual Approval
● Consolidated Approval Chain
● Consolidated Approval
● Mass Approval
● Approval Chain
7. What report provides the details of all the actions available for the specific
Business Process Type?
Business Process Configurations Options report
8. How can Organizations be tied to Business Processes?
Workday allows the configuration of Business Processes per
Organization. While implementing a business process with multiple Organization-
dependent definitions, Workday follows a hierarchy to check which definition to
execute.
An example could be multiple hire business process definitions depending on
departments.
E.g., Hire for Finance department, Hire for the HR department, Hire for the IT
department, etc.
9. What is a Business Process Completion Step?
The business process is considered complete once the completion step finishes the
execution. All the actions depend on business process completion but do not
depend on all the steps being executed.
For example, an organization wants to hire a candidate, and that position requires
background verification. Suppose if you do not want to wait for all the information
to come back from the background check business process, you can set the
completion step before the last step. That will allow the pre-hire or hire business
processes and enter the Background Check Business Process before the Pre-Hire
executes all the steps.
If no steps are marked as a completion step, then the last step will be the
completion step by default.
10. What actions can you do with a Business Process Event if you want to
modify its behavior in a running state?
You can use actions like cancel, reassign, correct, and delegate to modify the
business process event's behavior pattern. To search for events, you can use the
prefix "event"
11. What is meant by the business process?
A business process is a set of tasks that users can create, act upon, and complete.
These business processes are created with a combination of actions, approvals,
checklists, etc.
12. What are the business process steps in Workday?
Following are the steps involved in a business process:
● Entry Condition
● Exit Condition
● Running Conditions
● Validation Condition
13. What are the approval process steps in the Workday business process?
Below are the approval process steps of a business process,
● Individual Approval
● Approval Chain
● Consolidated Approval
● Consolidated Approval Chain
● Mass Approval
14. How can we check and mark a business process action behavior when it is
already running?
We can change the behavioral pattern of a business process using the below
actions,
● Cancel
● Reassign
● Delegate
● Correct
15. Which report can help you get the details of all action types available in
the Business Process Type?
The report which can give business process details is Business
“Process Configuration Report”.
16. Explain Business Process Completion Steps and its importance.
Once the completion step finishes the “Complete step” final execution, it’s called a
Business Process Completion Step. As other actions depend on the completion
step, it’s important to major this step for Business Process Completion. But at the
same time, it does not necessarily depend on all the included steps to final their
completion depending on this step.
Let’s take an example to understand this:
Similar to the organizations when they hire a new employee, it’s important to do
the background verification to onboard the resource. Though this is not part of the
hiring business process but it’s important for the onboarding process. It shows that
the HR does not need to wait for all the information to cross-check and verify
before onboarding but there is certain information related to educational
qualification, other job authentications are important to get verified. The rest keeps
working in the latter stage of the verification process. Processes can be set and
priorities as pre-hire and post-hire based on their requirement.
In the process stream if no step is marked as completion step then the last step in
the stream will be “Completion Step” by default.
Security
1. What are the two types of security policies in Workday?
Business Process policies and Domain policies
2. What is the use of Domain Security Policies?
With domain security policies, you can modify which group can view or
modify items in a report/task, or GET or PUT transactions from an integration.
3. How do you manage access to integrations?
You need to create an Integration System User and an Integration Security Group.
Next, assign the Integration User to the Integration security group. Then finally,
utilize that security group to add security policy access.
4. How do you apply changes to security policies?
You need to run the Activate Pending Security Policy Changes to apply the
security policy changes.
5. To modify security in Workday, what groups do you need to be a part of?
Security Configurator or Security Administrator.
6. Explain about security policies in Workday
There are two types of security policies in Workday,
Business Process Policy - define which security group can view or modify data
within domains
Domain Policy - indicate which security groups can participate in the business
process
7. Name the report which is responsible to view all security groups assigned to
users?
View Security Group for Users, Reports give the information of all security groups
assigned to particular users.