Report Writer Interview Questions and Answers-Workday
Data Source – View
Object – Table
Related Object – Child Table
Class Report Field – (CRF) Column
Instance – Row
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.
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, 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 is Indexed Data source?
Indexed data sources are a special type of data source optimized for performance, aggregation, and faceted filtering on large volumes of data.
8.Can custom field be used in Report?
9.What are the different types of custom reports?
Simple, Advanced, Matrix, nBox, Search, Simple, Transposed, Trending.
10.What is the difference between Filter and Sub-Filter?
Filter is used to provide filter condition for Primary Business Object and Sub-Filter is used to provide filter condition for Secondary Business Object.
Python is a dynamic interrupted language which is used in wide varieties of applications. It is very interactive object oriented and high-level programming language.
Tableau is a Software company that caters interactive data visualization products that provide Business Intelligence services. The company’s Head Quarters is in Seattle, USA.
Micro Strategy is one of the few independent and publicly trading Business Intelligence software provider in the market. The firm is operational in 27 Countries around the globe.
Pega Systems Inc. is a Cambridge, Massachusetts based Software Company. It is known for developing software for Customer Relationship Management (CRM) and Business process Management (BPM).
Workday specialises in providing Human Capital Management, Financial Management and payroll in online domain.It is a major web based ERP software vendor.
Power BI is business analytics service by Microsoft. With Power BI, end users can develop reports and dashboards without depending on IT staff or Database Administrator.