• Skip to main content
  • Skip to footer
Revelwood Logo

Revelwood

Your SUPER-powered WP Engine Site

  • Who We Are
    • About Us
      • Our Company
      • Our Team
      • Partners
    • Careers
      • Join Our Team
  • What We Do
    • Solutions
      • Workday Adaptive Planning
      • IBM Planning Analytics
      • BlackLine
    • Services
      • Implementation Services
      • Customer Care
        • Help Desk
        • System Administration as a Service
      • Training
        • Adaptive Planning Training
        • IBM Planning Analytics / TM1 Training
    • Products
      • DataMaestro
      • LightSpeed
      • IBM Planning Analytics Utilities
  • How We Help
    • Workday Adaptive Planning Use Cases
    • IBM Planning Analytics Use Cases
    • BlackLine Use Cases
    • Client Success Stories
  • How We Think
    • Knowledge Center
    • Events
    • News
  • Contact Us

Workday Adaptive Planning Tips & Tricks

Workday Adaptive Planning Tips & Tricks: Templates

 

Tips & Tricks

August 12, 2020

By Gary Leiffer

This week’s Workday Adaptive Planning and Reporting Tip & Trick pertains to the useful and elusive template. Templates exist throughout the Adaptive Planning application to enable the upload of the important data utilized within. Whether you have a set of Actual GL data for your current month, or new Levels to append the current Level structure, there exists a template designed to assist you in the process. Locating the template, and using it however, is not so straight forward. I will show you in this article, where the templates are, and how to best use them for your application data imports.

The first template new users to Adaptive will most-often encounter is a Structure Import template. All very similar in nature, the GL Account Structure Import differs from the Custom, Metric and Assumption, Level, Dimension and Attribute Imports because there already exists within the structure the Root GL Accounts, which as described in one of my previous Tips and Tricks articles, can’t be deleted. The set of accounts imported into the structure will append the Root Account set of accounts.

The import function is located at the top of the General Ledger Accounts screen as circled in the following diagram:

Adaptive Insights Tips & Tricks: Templates

Upon selection of the import option, the following screen appears which enables import to occur:

Using templates in Adaptive Insights

The download template option circled in the previous screen capture, creates an Excel file, which appears at the bottom of the screen (in the rectangle in the screen capture below), and when opened and enabled, presents the user with format required for the import of the GL Accounts.

How to use templates in Adaptive Insights

The first tab of a template is filled with instructions about how to create the template for import.

How to use templates in Adaptive Insights

The second tab of the template (Accounts) is the required format for the importing of the elements. When working with the GL Accounts importing, the following points are required:

  1. Name, Rolls Up to, and Code are required and must be unique.
  2. When adding accounts a Root Account already in the structure, all accounts added will inherit the attributes associated with the parent Root Account.

The following screen capture shows the Accounts tab of the template and the element fields within.

Understanding templates in Adaptive Planning

Upon completion of the template creation, the user chooses the file and selects Upload as indicated in the rectangles in the following screen capture:

Understanding templates in Adaptive Planning

The format, location and utilization of the template I have described is similar for all element structure import processing.

A second import template type encountered regularly by end-users is required for data entry to Actual and any Budget version sheets within the system. Most sheets enable manual entry of data, however for large sets of data such as the Actuals for the current month, being able to import the data is extremely valuable, and time-saving.

The Import Data screen offers the end-user the option to import to either the Actual or Budget versions – and any sheets qualifying as such are offered as options to be imported too. The Download Template option (circled in the screen capture below) when selected, creates a similar Excel file template as I described previously. The default is to the Actual version and the standard sheet as displayed in the rectangle in following screen capture:

Learn how to use templates in Adaptive Planning

The unique requirements of the data import template are:

  1. The Actuals tab is a required template named tab – no matter what type of data being imported (Actual or Budget). Do not change the tab name from the default “Actual.” It is the main import data screen where the selection for version type is made.
  2. The Split Label column is also a required element of the import template, regardless of whether or not any splits are included in the specific import data set.
  3. The Region column is solely an example of how to import dimensions and should be deleted if there is no Region Level Dimension in the instance.
  4. The Account element column may either be the Account name or code and will directly import if there is a matching Account mapping that previously exists for the GL Account. If not, the required mapping will be requested during the import process – and if it does not exist will delay and cause errors in the file.
  5. When importing data to a non-standard sheet, enter the required identifying information on the Import screen and then download the template, which will be set up exactly as it should be for importing into the sheet. The data tab in non-standard sheets will then have the required sheet name on the tab.
Templates in Adaptive Planning

The third type of data import file is unique and well-hidden. As described in the previous section, Accounts and also Levels must be mapped to actual matching elements either during the import process or prior to the process in the mapping import optional screens, located in the Integration section of the application. In the following screen capture, the Import Level mapping screen is displayed, and the rectangle indicates the location of the importing section “Import Level Mapping.”

Learn how to use Adaptive Insights templates

Well hidden within the option is the circled “Download template” selection tab, which is often overlooked and deemed non-existent by new end-users. This very helpful import template enables you to create mappings for Levels and in other integration options, Accounts and Dimension values. One very unusual caveat while importing GL Account mappings, is that the map to Account is a concatenation of the Account Code and Name. It takes some practice and trial and error for the new end-users to create a valid mapping import file.

Adpative Insights Tricks: Templates

In summary, the benefits of being able to import large sets of data into the Adaptive instance are numerous and there exists a template for all import options. The download template options are located in non-consistent sections of the import data screens. The templates do require careful attention to enable whatever type of data you are importing to actually import. Any errors in the data file will cause the import to fail, and the file will require further attention and editing to enable the process to proceed and become a successful data import.

Adaptive Insights Tips: Templates

The team at Revelwood has been recognized by Adaptive for its thought leadership in the space, commitment to its Workday Adaptive Planning practice, and its rapid achievements of milestones. Visit Revelwood’s Knowledge Center for our Adaptive Planning Tips & Tricks or sign up here to get our Adaptive Planning Tips & Tricks delivered directly to your inbox. Not sure where to start with Workday Adaptive Planning? Our team here at Revelwood can help! Contact us info@revelwood.com for more information.

Read more Adaptive Insights Tips & Tricks:

Adaptive Planning Tips & Tricks: The Formula Assistant – How to, Where & Why

Adaptive Planning Tips & Tricks: Virtual Versions and Neutral Exchange Rate

Adaptive Planning Tips & Tricks: How to Remove Repetitive Total Rows

Author

  • Gary Leiffer
    Gary Leiffer

    View all posts

    • Categories

      • Awards & Recognition
      • Financial Close & Consolidation
      • FP&A Done Right
      • IBM Planning Analytics Tips & Tricks
      • News & Events
      • Success Stories
      • Tech Bulletins
      • Workday Adaptive Planning Insights
      • Workday Adaptive Planning Tips & Tricks

    Popular Posts

    Authors

    Adam Riskin
    Adam Riskin
    Ailenette Cruz
    Ailenette Cruz
    Alex Goldman
    Alex Goldman
    Ben Alcock
    Ben Alcock
    Brian Combs
    Brian Combs
    Dave Miersch
    Dave Miersch
    Dillon Rossman
    Dillon Rossman
    Gary Leiffer
    Gary Leiffer
    John Pra Sisto
    John Pra Sisto
    Ken Wolf
    Ken Wolf
    Koury Reid
    Koury Reid
    Lee Lazarow
    Lee Lazarow
    Lisa Minneci
    Lisa Minneci
    Marc Assenza
    Marc Assenza
    Mary Luchs
    Mary Luchs
    Michelle Song
    Michelle Song
    Nina Inverso
    Nina Inverso
    Revelwood
    Revelwood
    Robert Nordhagen
    Robert Nordhagen
    Tara Byrnes
    Tara Byrnes
    Wesley DeMarco
    Wesley DeMarco

    Sign up for our newsletter

    Connect

Footer

Revelwood Overview

Revelwood helps finance organizations close, consolidate, plan, monitor and analyze business performance. As experts in solutions for the Office of Finance, we partner with best-in-breed software companies by applying best practices guidance and our pre-configured applications to help businesses achieve their full potential.

EXPERTISE

  • Workday Adaptive Planning
  • IBM Planning Analytics
  • BlackLine

ABOUT

  • Who We Are
  • What We Do
  • How We Help
  • How We Think
  • Privacy

CONNECT

Contact:

25B Vreeland Road, Suite 111 Florham Park, NJ 07932
201.984.3030
info@revelwood.com

Copyright © 2023 · Revelwood Inc. All rights reserved. Revelwood® and the Revelwood logo are registered marks of Revelwood Inc.