Best Workday Integration Training and Workday Reporting Training

1. Workday Reporting and Calculated Fields © 2020 Workday Training Online

2. What is Workday Reporting  Designed for the functional user, easy to deploy, with a simple-to-use, consumer- friendly interface.  Built-in to the application allowing users to take action on the report output directly from the user interface.  Leverage your security configuration, allowing you to access real-time, relevant data where you need it, how you need it. © 2020 Workday Training Online

3. Business Objects Give a striking overview of the problem and explain it briefly. Workday stores your data as business objects - organizations, workers, positions, and so on. Just as a database table or worksheet has columns and rows, a Workday business object has fields and instances Elaborate on how this negatively impacts people an their experiences. Frame the problems effectively as it will set the stage of your entire pitch. © 2020 Workday Training Online

4. Business Object Fields Give a striking overview of the problem and explain it briefly.  In addition to text, date, currency, numeric and Boolean type fields, a primary business object can include one or more fields that represent references or ‘links’ to related business objects.  There are two types of fields that describe the relationship a related business object has to the primary business object.  They are single instance and multi- instance field types. Elaborate on how this negatively impacts people an their experiences. Frame the problems effectively as it will set the stage of your entire pitch. © 2020 Workday Training Online

5. Data Sources Example © 2020 Workday Training Online

6. Object Type Fields © 2020 Workday Training Online

7.  Instances of a business object in Workday are like rows in a table or spreadsheet Fields And Instances  Each instance represents a unique occurrence of that type of object such as a given organization or worker.  A business object can have no instances, one instance, © 2020 Workday Training Online or many instances.  Workday automatically links related business objects together © 2020 Workday Training Online

8. Report Data Sources  Data sources are defined and delivered by Workday. Workday delivers different data sources for key primary business objects.  Business Object vs. Data Source: The Report Data Source is the view or selection of instances of a given business object on which you want to report. © 2020 Workday Training Online

9. Simple vs. Advanced Report Types Simple Report Advanced Report  No Sharing with Other Users Simple Filters  Cannot publish as Web Service  No Related Business Object fields  Can Share with Other Users Complex Filters – Prompting Publish as a Web Service  Access to Related Business Object fields (child tables)  Filtering on Related Business Objects . © 2020 Workday Training Online

10. Report Types Give a striking overview of the problem and explain it briefly.  Workday Report Writer provides the Elaborate on how this negatively impacts people an their experiences. following report types for creating custom reports and custom analytic solutions. In this course, we will cover Frame the problems effectively as it will set the stage of your entire pitch. Simple, Advanced and Matrix report types. © 2020 Workday Training Online

11.  Contextual Reporting in Workday is a key resource when you know the data, but not the meta data. Contextual Reporting  When viewing the data you’re interested in, select Reporting from the related action icon © 2020 Workday Training Online  You will find 3 main contextual reporting choices. © 2020 Workday Training Online

12. Sorting Give a striking overview of the problem and explain it briefly.  The Sort tab on the report definition allows you to control the order in which Elaborate on how this negatively impacts people an their experiences. data will be presented and grouped. This step is optional.  If no sort/group criteria are specified, Frame the problems effectively as it will set the stage of your entire pitch. the report will sort the data based on the first (leftmost) column © 2020 Workday Training Online

13. Filtering Give a striking overview of the problem and explain it briefly.  The Filter tab on the report definition Elaborate on how this negatively impacts people an their experiences. allows you to specify how you want to filter the primary business objects for the report beyond your data source. Frame the problems effectively as it will set the stage of your entire pitch.  This step is optional. If no filter criteria are specified for a report, all instances from the data source will be included in the report. © 2020 Workday Training Online

14. Associated With Business Object © 2020 Workday Training Online

15.  All Authorized Users, i.e., any user in a permitted security group the report’s data source Sharing Reports  Specific Authorized Groups, i.e. specific security groups permitted for the report’s data source © 2020 Workday Training Online  Specific Users, i.e. specific users with security groups permitted for the report’s data source © 2020 Workday Training Online

16. Worklets © 2020 Workday Training Online

17.  Calculated fields allow users to perform simple arithmetic, date calculations, text manipulation, logical expressions, retrieval of related data, formatting and transformations of their existing data. Calculated Fields and Custom Fields © 2020 Workday Training Online  Custom fields allow you to enter, maintain and report on additional data not managed in Workday. © 2020 Workday Training Online

18. The Workday Calculated Field Pyramid © 2020 Workday Training Online

19.  The Format Date function extracts the year, year-quarter, and year- month from a date and formats it as a text field. Format Date  It can also extract and format fiscal period, fiscal year, fiscal year- period, and date-time fields. © 2020 Workday Training Online  This function enables you to determine higher level time periods from a date © 2020 Workday Training Online

20. Data Difference Give a striking overview of the problem and explain it briefly.  The Date Difference function computes the number of days, months, years, hours, minutes or seconds between two date or date time related field types. Elaborate on how this negatively impacts people an their experiences.  The start date is subtracted from the end date. The results are rounded down to the nearest whole number depending on the calculation type selected. Frame the problems effectively as it will set the stage of your entire pitch. © 2020 Workday Training Online

21. Evaluate Expression Give a striking overview of the problem and explain it briefly.  The Evaluate Expression function groups and transforms data. It evaluates a series of conditions and returns the value associated with the first condition that is true. Elaborate on how this negatively impacts people an their experiences. Frame the problems effectively as it will set the stage of your entire pitch.  At run time the function applies the default value and then starts testing conditions starting with the first condition defined. © 2020 Workday Training Online

22. Lookup Date Rollup Give a striking overview of the problem and explain it briefly.  The Lookup Date Rollup is a calculated field function similar to Format Date that is primarily targeted for Financial Composite Reports. Elaborate on how this negatively impacts people an their experiences.  When created, it will return a single instance field type that can be used in Composite Reports for Control field groupings. Frame the problems effectively as it will set the stage of your entire pitch. © 2020 Workday Training Online

23. Concatenate Text Give a striking overview of the problem and explain it briefly.  The Concatenate Text function concatenates one or more text (or single instance) fields together and returns a text field type. Elaborate on how this negatively impacts people an their experiences.  Special characters that are commonly used when concatenating fields are provided by Workday as global text constants. Frame the problems effectively as it will set the stage of your entire pitch. © 2020 Workday Training Online

24. Intermediate Calculation Give a striking overview of the problem and explain it briefly.  This checkbox drives whether the calculated field will show in main field prompts or not. Elaborate on how this negatively impacts people an their experiences.  If checked as intermediate, it will NOT show in main prompts, and if not checked as intermediate, it will show in main field prompts. Frame the problems effectively as it will set the stage of your entire pitch. © 2020 Workday Training Online

25. Substring Text Give a striking overview of the problem and explain it briefly.  The Substring Text function extracts the specified portion of the text within a field. Elaborate on how this negatively impacts people an their experiences.  You can use the Substring calculated field function to extract a substring from a text or single instance field. Substrings can be based on fixed positions or delimiters. Frame the problems effectively as it will set the stage of your entire pitch.  You can also designate whether to search a string forward or backwards. © 2020 Workday Training Online

26. Text Length Give a striking overview of the problem and explain it briefly.  Text Length returns the length of either a text field or a single instance field. Elaborate on how this negatively impacts people an their experiences.  It typically is used as filter criteria in a custom report to list any employees whose data will be truncated during an integration. Frame the problems effectively as it will set the stage of your entire pitch. © 2020 Workday Training Online

27. Workday Training Online Workday Training Online provides in-depth functional skills in the field of this cloud-based ERP training software. We are giving training for various modules of Workday like Workday HCM, Integration, Finance, Reporting, Payroll, and Studio Training and more. Our trainer guided over 20,000 students who have been placed in reputed organizations. © 2020 Workday Training Online

28. For more info +1 214-872-7517 workday@workdaytrainingonline.com www.workdaytrainingonline.com © 2020 Workday Training Online