Steps: Replace Default Overview Cards on the Close and Consolidation Hub in AP&C with Custom Reports
You can customize the cards on the
Overview
page of the Close and Consolidation
hub in Adaptive Planning and Consolidation (AP&C) to replace the default data visualization cards with insights from your own custom reports.
You can also:
- Customize the title and subtitle on the cards.
- Set up overflow menus that displays links to other tasks, reports, dashboards, or external resources.
To enable Workday to display a custom report on a card, the report must use the:
- Matrixreport type.
- Chartoutput type.
- Share with all authorized userssharing option.
- Access theCreate Custom Reporttask.Set up your custom report so that Workday can display it on a card.
- Select theMatrixreport type.
- Select a report data source or data source filter that has report fields as required or optional prompts that you can map to theConsolidation GroupingandClose Periodfilter prompts on the hub.
- On thePromptstab, add a row to thePrompt Defaultsgrid to map a report prompt to theConsolidation Groupingfilter prompt on the hub:FieldDefault TypeDefault ValueRequiredDo Not Prompt at RuntimeSelectCompanyorCompany/HierarchyDetermine default value at runtimeConsolidation GroupSelect.Select.
- When the report data source or data source filter has start and end date prompts, add 2 rows to thePrompt Defaultsgrid to map those prompts to theClose Periodfilter prompt on the hub:FieldDefault TypeDefault ValueRequiredDo Not Prompt at RuntimeSelect the start date report field.Determine default value at runtimeFiscal Period Start DateSelect.Select.Select the end date report fieldDetermine default value at runtimeFiscal Period End DateSelect.Select.
- When the report data source or data source filter has an accounting period prompt, add a row to thePrompt Defaultsgrid to map that prompt to theClose Periodfilter prompt on the hub:FieldDefault TypeDefault ValueRequiredDo Not Prompt at RuntimeSelect the accounting period report field.Determine default value at runtimeClose PeriodSelect.Select.
- Add rows for all other prompts on the report data source or data source filter, and select theDo Not Prompt at Runtimecheck box for each row.
- On theOutputtab, select the output typeChart.
- On theSharetab, selectShare with all authorized users.
- Complete your report configuration to display the data you want to show on the hub.
- ClickOK.
Security:Custom Report Creationdomain in the System functional area. - Access theMaintain Hubstask.
- For theClose and Consolidationhub, select .
- On theConfigure Hub by Admintask, clickEditfor the card you want to replace with your custom report.
Security:Set Up: Tenant Setup - GeneralandSet Up: Tenant Setup - Hubdomains in the System functional area. - Complete theEdit Card by Admintask to replace the default card.
- On theInformational Texttab, selectCustomize Titleand enter a new title for the card.
- SelectCustomize Subtitleand enter a new subtitle for the card.When you don't enter a new subtitle, Workday displays the subtitle from the default card.
- On theOverflow Menutab, add rows to the grid to set up an overflow menu for the card.Select security groups or condition rules to control which users can see the overflow menu items.Add subrows to theLinksand select items to display in the overflow menu.
- On theCustom Reporttab, select the custom report you want to display on the card.
- ClickOK.
Security:Set Up: Tenant Setup - GeneralandSet Up: Tenant Setup - Cardsdomains in the System functional area.
The
Close and Consolidation
hub in AP&C displays your custom reports on the cards on the Overview
page. You can use the filter prompts on the hub to change the filter criteria for the reports displayed on the cards.