Set Up Curated Field Lists for Discovery Boards
Security: These domains in the System functional area:
- Discovery Boards: Manage Curated Data Source Field List
- Discovery Boards: Manage Drilling Field Lists
You can configure curated field lists so that it's easier for discovery board editors to find the right fields to use when building visualizations. For all visualizations except tables, you can perform better ad hoc analysis and reporting by configuring fields to drill into and view details for.
- Access theMaintain Field Lists for Reportingreport.
- From theProduct Areaprompt, selectDiscovery Boards.
- Select aBusiness Objectto base the curated field list on.All data sources with the primary business object you select share the same curated field list.
- As you complete theData Source Fieldstab, consider:
Option Description Enable in Discovery Boards(Available after you add fields to the curated field list.) Click to enable the curated list that you configured in discovery boards. Once clicked, you can clickDisable in Discovery Boardsto disable the curated field list.From the related actions menu of the discovery board, you can clickShow only curated fields:- Off to display all available fields.
- On to display only the fields configured in the curated field list.
Add FieldsClick to access theAdd Fields to Data Source Field List for Discovery Boardstask. TheFields to Addgrid displays all fields available to populate the curated field list.Remove Fields(Available after you add fields to the curated field list.) Click to access theRemove Fields from Data Source Field List for Discovery Boardstask. TheFields to Removegrid displays the fields currently on the curated field list.Selected FieldsThe grid displays all fields added to the curated field list that users view when creating visualizations.TheWhere Usedcolumn displays a usage count for each curated field. The count includes Workday internal development usages. - On theDrill By Fieldstab, clickEdit Drill By Field Listto access theEdit Drill By Field List for Discovery Boardstask. You can manage the fields you use to drill into visualization measure data.If you don't configure fields on theDrill By Fieldstab,Drill Bywon't display on visualizations.
- As you complete the tab, consider:
Option Description Enable in Discovery BoardsClick to enable the drill by field list that you configured in discovery boards. Once clicked, you can clickDisable in Discovery Boardsto display all available drill by fields for the business object you selected.Selected Grouping FieldsThe grid displays all fields added to the drill by field list that users view when creating visualizations. You can select theDefault Sortfor each field that determines the display order for the drill by fields. Example: When you select a drill by field in a visualization, Workday displays a new table. The new table displays theDefault Sortyou selected for the drill by data.Discovery boards don't support drilling on:- Blank orOthervalues.
- Fields that you can't filter on.
- Lookup prior value calculated fields.
- On theShow Details Fieldstab, clickEdit Show Details Field Listto access theEdit Show Details Field List for Discovery Boardstask. You can manage the fields Workday displays when you view the details of a data point to the transaction level.If you don't configure fields on theShow Details Fieldstab,Show Detailswon't display on visualizations.
- As you complete the tab, consider:
Option Description Enable in Discovery BoardsClick to enable the show details field list that you configured in discovery boards. Once clicked, you can clickDisable in Discovery Boardsto disable the show details field list.Selected FieldsThe grid displays all fields added to the show details field list that users view when creating visualizations. You can select theDefault Sortfor each field that determines the display order for fields when you view details. Example: When you clickShow Detailson a visualization data point, Workday displays a new table. The new table displays theDefault Sortoption you selected for the show details data.To change the order of theShow Detailsfields displayed in a visualization, remove the fields, then add them in the desired order.
Workday displays:
- Curated fields when you build discovery board visualizations if the data source has a primary business object with a curated field list configured.
- Options on the visualization to drill into and view details for your data.
You can drill into or view details for visualizations and display the resulting data in a pivot table or table. You can then click:
- Add to Sheetto add a visualization to a sheet. Each sheet can display up to 10 visualizations. Workday disablesAdd to Sheetif the visualization you drill into or view details for includes a lookup date rollup calculated field.
- Export as a Reportto export a visualization to the Report Writer. Workday disablesExport as a Reportif:
- The visualization you drill into or view details for includes a lookup date rollup calculated field.
- You don't have access to theCustom Report Creationdomain in the System functional area.