Reference: Reports for Importing Data and Metadata into Adaptive Planning
You can use Workday reports to import Workday data and metadata into Adaptive Planning for planning and reporting using your Workday data source. Workday provides these standard reports:
Report | Security | Description |
|---|---|---|
Plan Companies/Hierarchies
| Set Up - Adaptive Planning domain in the System functional area. | Provides a list of all companies and company hierarchies based on a Company Hierarchy prompt. |
Plan Dimensions/Hierarchies
| Set Up - Adaptive Planning domain in the System functional area. | Provides a list of all organizations based on these prompts:
Include these report fields to enable dimension and level associations for synchronizing data access from Workday into Adaptive Planning:
Assignable Role for Dimension Type prompt.Include these report fields to enable level ownership.
Assignable Roles for Dimension Type prompt. |
Ledger Accounts or Ledger Accounts Summaries
| Set Up - Adaptive Planning domain in the System functional area. | Provides a list of all ledger accounts and ledger account summaries based on these prompts:
|
To import data for workforce planning, we recommend that you migrate these reports from your Customer Central tenant and use copies of the reports:
- Planned Dimensions/Hierarchies
- PLN All Positions
- PLN All Workers
- PLN All Workday Accounts - User Sync
- PLN - Currency Conversion Rate
- PLN Drillback on Headcount
- PLN Initiatives
- PLN Locations as Bus Site
- PLN Job Management - Requisition
- PLN Job Profile Dimension
- PLN Worker Dimension
If you create custom reports to import Workday data and metadata, you must:
- Create the reports as advanced reports.
- Enable the reports as web services.
- Enable the reports for Worksheets.
- Not use calculated fields. You can't use calculated fields to drill down from Adaptive Planning sheets and reports to Workday objects and actuals.
- Ensure that the reports run in Workday in 20 minutes or less.
- Ensure that the reports contain less than 1 million rows.
- Use a unique Column Heading Override XML Alias.
After going live, we recommend that you change your configuration to use a prompt that’s determined at runtime to return the last closed period. This ensures that reports run dynamically on fiscal periods.