Implementing ChartHop
...
Apps & Integrations
FP&A

Workday Adaptive Planning

The Workday Adaptive Planning app runs outbound from ChartHop to Workday Adaptive Planning so you can use your ChartHop data in Workday Adaptive Planning to run financial models and perform analysis. You can sync data daily, hourly, weekly, monthly, or as needed. 

Effective dating is not supported, meaning that data cannot be stored with an individual date (for example, a promotion date). 

Customized field mapping is supported, so you can make any data point in your ChartHop organization available in Workday Adaptive Planning. Please direct field mapping questions or requests to ChartHop Professional Services or Support. 

How it works

The Workday Adaptive Planning app syncs your ChartHop data to a Custom Cloud Data Source in Workday Adaptive Planning. The Custom Cloud Data Source always has access to the most recent data from ChartHop. 

After you install the Workday Adaptive Planning app in ChartHop, you’ll set up Loaders in Workday Adaptive Planning, which will pipe data from your ChartHop Custom Cloud Data Source to your Workday Adaptive Planning Sheets. 

You can configure Loaders to run on a schedule or as needed. ChartHop recommends that you configure Loaders to run daily, so your Sheets—and the financial models that run on them—always have the latest ChartHop data.

The following diagram shows how ChartHop integrates with Workday Adaptive Planning.

ChartHop and Workday Adaptive Planning architecture


Install the Workday Adaptive Planning app

You install the Workday Adaptive Planning app in ChartHop with an install wizard. You’ll also need to complete some steps in Workday Adaptive Planning (including setting up a Custom Cloud Data Source and importing the ChartHop data structure). ChartHop’s in-app wizard provides full instructions.

To install the Workday Adaptive Planning app, you’ll need to be comfortable configuring external data sources in your Adaptive instance or have access to a resource who can perform this task. For detailed information, view the Workday Adaptive Planning documentation (Workday login required).

Workday Adaptive Planning app installation


To install the Workday Adaptive Planning app in ChartHop: 

  1. From the left sidebar, select Apps & Bundles.
  2. From the sub-menu, select Apps.
  3. Under Available apps, locate Workday Adaptive Planning and select Install.
  4. Select the Install button on the page that displays. 
  5. Complete the steps in the Connect to Workday Adaptive Planning section. 
  6. Select Next Step.
  7. In the Configure app settings page, select whether to make data from your primary org available in Workday Adaptive Planning.
  8. (Optional) Choose the ChartHop plans you want to make available for import in Workday Adaptive Planning.
    • You have the option to include scenarios, compensation reviews, performance reviews, and headcount plans.
    • You can include up to 10 plans.
    • ChartHop lets you filter by plan type and by the user who created the plan. 
    • You have the ability to edit the plans that are included after you've finished installation.
  9. Select the Advanced settings link and select the employee types to make available. 
    • ChartHop recommends accepting the defaults for Advanced settings, which makes all employee types available in your synced data.
  10. Select Next Step.
  11. Select Save.

Customize field mapping

After you install the Workday Adaptive Planning app, additional ChartHop fields can be mapped to your Workday Adaptive Planning Sheets using any column names you prefer. Please direct field mapping questions or requests to ChartHop Professional Services or Support. 

To map additional fields: 

  1. From the left sidebar, select Apps & Bundles.
  2. From the sub-menu, select Apps.
  3. Select the Installed Apps tab.
  4. Next to Workday Adaptive Planning, select Configure (gear icon). 
  5. Select the Field mappers tab.
  6. Select Add field mapping and then select Add Field Mapper
  7. Under ChartHop Field, enter the ChartHop field to map while leaving Optional Charthop Default blank. 
  8. Under Mapper Type, select One to One.
  9. Under Remote Fields, enter the name of the field as you want it to appear in your Sheets, preceded by job. For example, you could map ChartHopField to job.MyChartHopField. MyChartHopField would be the column name in your Workday Adaptive Planning Sheets. 
  10. Click Save field mappers to finish configuring custom fields.




Updated 24 Jan 2024
Doc contributor
Did this page help you?