Reporting Interview Questions
What are Advance reports?
Advanced reports enable you to perform many actions on your data from primary and related business objects, including: Counting, Grouping, Summarizing, Totaling.
Output format of these reports can be table and charts.
Which filter would execute first? Filter or sub filter?
Sub filter will execute first. Because sub filters are applied on related business object, so it will filter most of the data using sub filters and then remaining data using filters.
What is RAAS?
RAAS is a normal report which is web service enabled. Making a report as web service enable will help to call that report in EIB, studio Integrations and BIRT. Otherwise, we cannot call that report in EIB, Studio or BIRT.
What are the steps to create a report?
Choose Report type and Data Source>> Select Objects and Fields>> Order Columns>> Sort Output>> Define Filter Criteria
What is Workday Reporting? What are the types of workday reports?
Workday reporting is a tool to gain information on data which is stored in workday. This information can be in table format, chart format etc.
Types: There are 2 types of Workday Reports. Custom report, Standard Reports.
Standard Reports are again of two types.
Xpresso Reports:
These reports are delivered reports. User cannot edit these reports. User can only run reports for which S/he have access to.
Report Writer:
These reports are delivered reports. User can not directly edit these reports. User have to copy these reports and then user can edit that report.
Custom reports:
These are the custom reports created by user using report writer tool. The task to create custom report is “Create custom report”. The person who create the report is owner of that report.
How to make report as web service enable?
There are 2 ways to make a report as web service enable.
- While creating an advance report, you can find a checkbox to make report as web service enable.
- After creating a report, you can also go to advance tab and select web service enable checkbox. This way you can also disable report as web service, so it cannot be used in EIB, Studio and BIRT.
What is difference between advance reports and simple reports?
Simple reports will not have option to sub filter, prompts and will have less functionality, wherein advance reports will have these features.
Also, simple reports cannot be used as web service.
The Tab on the Report definition allows you to control the order in which data will be presented and grouped is
Sort
Which Report cannot publish Web service?
Simple
What is the task to convert a report from simple to advanced?
Related action >> custom report >> Change to Advanced Report type
How do you compare the WD reporting with Relational DB?
Data Source - View
Object - Table
Related Object - Child Table
Class Report Field - (CRF) Column
Instance - Row
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.
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.
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.
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.
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.
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.
Can custom field be used in Report?
Yes.
What are the different types of custom reports?
Simple, Advanced, Matrix, nBox, Search, Simple, Transposed, Trending.
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
