Skip to main content
Documentatie
Documentatie
Adaptive Planning
Laatst bijgewerkt: 2025-03-14
Manage Financial Planning Configurations

Manage Financial Planning Configurations

You can use the financial planning configuration manager to build your Adaptive Planning model when you have Adaptive Planning with Workday Financials or when you have Adaptive Planning and Consolidation (AP&C). Each has different prerequisites.
For AP&C:
For Adaptive Planning with Workday Financials:
  • Work with a Workday-certified implementer to set up this feature and its security. If you don't have access to an implementer, contact your Customer Success Manager or Named Support Contact to engage Professional Services.
  • Set up financials in Workday.
For both Financials and AP&C:
  • In Workday Adaptive Planning, create and register for orchestration the Workday data source credential for the Adaptive Planning instance you want to configure.
  • On the API client that you use for the data source credential, change the scope to include all the functional areas for the data sources and report fields on your planning application.
  • Security:
    • Set Up: Adaptive Planning
       domain in the System functional area. Ensure that you're assigned to a security group with Modify access on this domain.
    • Set Up: Financial Planning
       domain in the Adaptive Planning for Financials functional area. Ensure that you're assigned to a security group with Modify access on this domain.
You can configure and activate the financial planning configuration manager in Workday to reduce the time it takes to set up Adaptive Planning models and data. The financial planning configuration manager automatically creates Adaptive Planning:
  • Level hierarchies by concatenating Workday dimensions according to actuals.
  • Dimensions, dimension values, and dimension attributes.
  • Asset, liability, equity, and income statement accounts in the Adaptive Planning General Ledger account hierarchy, mapped to Workday ledger account summaries.
  • Time strata for default and alternate calendars.
  • Corporate and reporting currency with currency exchange rate mapping. For AP&C this includes 1 translated currency that loads to actuals in the currency without the need for exchange rates in Adaptive Planning.
  • Actuals version. For AP&C, this includes currency versions.
  • Actuals from managed journal line summaries in Workday.
  • Integration data sources.
  • Integration metadata and data loaders.
  • Integration tasks with metadata and data refresh schedules.
  • Workday external systems.
You can configure dimensions like Cost Center, Company, and Location to load into Adaptive Planning as list or hierarchical dimensions.
Adaptive Planning creates the levels and dimension values after the task completes.
Links to view objects in Adaptive Planning function only for tenants configured with User Sync.
You can only edit the Workday custom reports created by the configuration setup from within the financial planning configuration manager.
Once you create a financial planning configuration manager, you can continue to edit it until you activate. After you activate the financial planning configuration manager, you can still make and activate these changes:
Plan Structure
No changes after activation.
Level
Change the top level hierarchy, included values, excluded values, and advanced filter values.
Dimensions
  • Add new dimensions.
  • Change the top level hierarchy, included values, excluded values, and advanced filter values.
Accounts
  • Add new attributes.
  • Change the excluded values and advanced filter values.
Time
No changes after activation.
Currency
No changes after activation.
Version
No changes after activation.
Actuals
  • Change actuals start period.
  • Change included values and excluded values on primary level and dimension.
Refresh Schedule
No changes after activation.
  1. Access the
    Manage Financial Planning Configuration
     task.
  2. Complete the
    Level
     page:
    Optie Omschrijving
    Dimension
    Select a primary level.
    Company
     automatically populates.
    (Optional) Select a
    Secondary
     and
    Tertiary
     dimension to concatenate to the
    Primary
     dimension.
    (Optional) Select level attributes for each dimension.
    To change the primary level, you must include
    Company
     as either:
    • Secondary
    • Tertiary
    (Optional) Select filters to apply to level dimension metadata. Filters apply to actuals data. You can change the actuals filters in the
    Actuals
     page.
    Configure
    (Optional) Configure a filter for the level. You can't select:
    • Report fields that contain parameters.
    • Calculated fields with or without parameters.
    When you configure a filter, it applies to both the level and nonhierarchical level attributes.
    • Top Level Hierarchy
       only filters the hierarchies. You can also select mid-level hierarchies.
    • Include
       and
      Exclude
       only filter leaf nodes, and are mutually exclusive.
    When you select a level, you can only use these prompts in these combinations:
    • Top Level Hierarchy
       and
      Exclude
      .
    • Include
       only.
    • Exclude
       only.
    Label overrides can't exceed 64 characters.
  3. Complete the
    Dimensions
     page:
    Optie Omschrijving
    Dimension
    Select a dimension from the list of supported worktag types, including custom organization and custom worktag types.
    Load as List
    (Optional) Select to add dimension attributes.
    Configure
    (Optional) Configure a filter for the dimension. You can select custom worktags or organizations.
  4. Complete the
    Accounts
     page:
    Optie Omschrijving
    Account Set
    Select a ledger account set.
    Accounts
    (Optional) Select
    Concatenate Revenue Category and Spend Category
     check box. You can add attributes to the primary ledger account dimension. You can include
    Revenue Category
     and
    Spend Category
     as dimensions when concatenating with the ledger account.
    Map Adaptive Planning root accounts to a single individual ledger account summary for each account type.
    When you select the
    Concatenate Revenue Category and Spend Category
     check box:
    • The
      Accounts Concatenation
       section becomes available in the
      Concatenations
       page.
    • You can select top level hierarchies for both these accounts if you include them in your account concatenation. You can select more than 1 top level hierarchy to create multiple attributes.
    • We automatically create these default hierarchy attributes to contain all of the hierarchy values:
      • Revenue Category Hierarchy
      • Spend Category Hierarchy
    • When you configure attributes, you can only select either:
      • An
        Attribute
         with no
        Top Level Hierarchy
         and the
        Hierarchy Attribute
         check box cleared.
      • A
        Top Level Hierarchy
         with no
        Attribute
         and the
        Hierarchy Attribute
         check box selected.
    Map all income statement and balance sheet accounts if you plan on loading balance sheet data in the future.
    Liabilities
    Assets
    Equity
    Income Statement
    Map Adaptive Planning root accounts to a single individual ledger account summary for each account type. You can only exclude values from the ledger account summary map when you filter.
  5. (Optional) Complete the
    Concatenations
     page:
    Optie Omschrijving
    Level Concatenations
    Select a:
    • Primary concatenation.
    • Secondary concatenation.
    • Tertiary concatenation
    If you selected a third level dimension in the Levels page, populate all three concatenations for the level.
    Account Concatenations
    Only available when
    Concatenate Revenue Category and Spend Category
     is selected in the Accounts section of the Accounts page.
    Select a:
    • Primary concatenation. Ledger account.
    • Secondary concatenation. Revenue category.
    • Tertiary concatenation. Spend category.
    This page enables creating planning-only concatenations, without requiring actuals activity.
    When you delete concatenations, they don't automatically delete within Adaptive Planning. Delete the concatenated levels or accounts from Adaptive Planning, separately.
    Changed or deleted concatenations don't display in the Preview Data page.
  6. Complete the
    Time
     page:
    Optie Omschrijving
    Default Calendar
    Select a
    Fiscal Schedule
    .
    (Optional) Select
    Fiscal Summary
     for more granular detail.
    Alternate Calendars
    (Optional) Select additional
    Fiscal Summaries
    .
    To add additional fiscal periods to Adaptive Planning, add them in Workday so that they sync through the Financial Planning Configuration Manager. Sections of the Time Administration page in Adaptive Planning lock when you use the manager. Use the Time loader in Adaptive Planning Design Integrations to update the Adaptive Planning calendar as needed.
  7. Complete the
    Currency
     page:
    Optie Omschrijving
    Corporate Currency
    Select a corporate currency.
    Reporting Currency
    Select a reporting currency.
    Currency Exchange Rate Type Mapping
    Map planning exchanges rates to Workday:
    • Monthly Average
    • End of Month
    Translated Currency
    (Optional) Select up to 1 currency. The currencies available are the same as you selected for Corporate Currency and Reporting Currency.
    Enables you to load actuals data directly from Workday when the data is already in the currency.
    Example: You have CAD and EUR for reporting currencies. You can now select EUR for translated currency. You can load actuals in EUR for all levels, eliminating the need for converting the data to EUR.
    Account Translation Rule Set
    Prerequisites:
    Select a rule set for the translated currency.
    The currencies of Included companies in the
    Level
     page load automatically after each scheduled synchronization, or after a change to the planning configuration model.
  8. Complete the
    Version
     page:
    Optie Omschrijving
    Copy Data into Actuals
    Select the default actuals version.
    Copy Data into Actuals Version
    Create the actuals sub-version.
  9. Complete the
    Actuals
     page:
    Optie Omschrijving
    Ledger
    Select a ledger book from Workday Financials.
    Book
    Select a book code as a filter.
    End Period
    Select an end period:
    • Current Period.
    • Prior Period.
    • Prior - 1 Period.
    Actuals Start Period
    Select a start period.
    Enable Balance Sheet
    (Optional) Select to load balance sheet accounts.
    Levels
    (Optional) Apply additional filters for levels to refine the actuals import.
    Filters inherit from the metadata filters configured in the
    Level
     pages.
    Dimensions
    (Optional) Apply additional filters for dimensions to refine the actuals import.
    Filters inherit from the metadata filters configured in the
    Dimensions
     pages.
    You can exclude dimensions you don't need for actuals import.
    Adding dimensions after activating automatically sets them as
    Exclude
    .
  10. Complete the
    Refresh Schedule
     page for metadata and data:
    Optie Omschrijving
    Refresh Frequency
    • Daily:
       We automatically select this option. You can change the refresh frequency.
    • Weekly
      : Select the day of the week.
    • Monthly
      : Select the day of the month.
    Start Time
    The refresh start time.
    Load Actuals Data for
    Current Period.
    Current and Prior Period for closing consolidation activities.
    Time Zone
    (View only) The time zone for the refresh schedule.
  11. Complete the
    Preview Data
     page:
    Optie Omschrijving
    Level
    (Optional) Click
    Preview
     to view the results, including your applied filters.
    Dimensions
    (Optional) Click
    Preview
     to view the results, including your applied filters.
  12. On the
    Security
     page, review and correct any security issues preventing you from completing the setup.
    We require you to:
    • Give your ISU access to all of these data sources and report fields.
    • Select the functional areas for all of these data sources and report fields on your API Client Scope.
  13. Your implementer completes the
    Select Instance & Activate
     page, activating your Adaptive Planning instance.
    We only display this page the first time your financial planning configuration manager loads for implementers. After the first time, we display the
    Review Changes and Activate
     page, instead.
  14. Activate Scheduled Tasks for Planning Configuration Manager
    only once, after the first time your implementer completes the
    Select Instance & Activate
    page.
  15. When you change activated applications, either activate or discard your changes on the
    Review Changes and Activate
     page.
We automatically create custom reports in Workday that you can't edit or delete. We use these custom reports in the load to Adaptive Planning.
We append (Active) to the name of the financial planning configuration manager in Workday. You can view the statuses by accessing the
View Planning Applications
 task.
Metadata values load on your configured schedule. To troubleshoot orchestration errors, you can manually trigger the orchestration task from Design Integrations in Adaptive Planning.
In Adaptive Planning:
  • Create formulas.
  • Create additional accounts.
  • Build your standard sheets.
  • Create your financial plan, which you can publish back into Workday.
If you no longer want to automatically update Adaptive Planning, reset the orchestration task in Design Integrations in Adaptive Planning. Select
Reset Orchestration
 to clear all of your Adaptive Planning integration data sources, loaders, and tasks. When you reset, the financial planning configuration manager no longer updates Adaptive Planning. Resetting doesn’t remove any data or metadata that already loaded.
You can reregister for orchestration to:
  • Reactivate the orchestration tasks.
  • Enable your planning instance for configuration in the financial planning configuration manager in Workday.