Workday Reporting: Interview Question & Answers

       1.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.

         2.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.

  1. 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.

  1. 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.

  1. 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.

  1. 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.

  1. 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.

  1. 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

  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.

  1. 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.

  1. 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.

  1. 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 esily.

  1. 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 option of the workday.

  1. What are the transformation types in EIB?

EIB allows only one transformation in Workday, we use mainly XML transformation using in EIB.

  1. 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.

  1. Explain about schedule future process by date?

Schedule future process by date describes the integration schedule configurations and time status that they can scheduled to run in future.

  1. 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.

  1. 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 extends 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.

  1. 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.

  1. How or where can you test Coreconnector 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.

  1. 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.

  1. 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.

  1. How many times Delivery attempts?

3 times by default.

  1. Which editor you can use for XSLT editor?

We use editors are oxygen, notepad and notepad++ for XSLT in Workday.

  1. What is the difference between CCW and PI?

CCW and PI are have same working environment and look and feel, but slightly differences are there.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 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.

  1. 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 extrapath 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.

Bonjour. A curious dreamer enchanted by various languages, I write towards making technology seem fun here at Workdaytrainings.com