Workday Adaptive Planning is a great planning tool due to its suitability for organizations in a wide variety of industries. However, one challenge is the inability to have multiple calendars to plan by. Some companies need this feature in order to accurately create budgets and forecasts.
The exciting news is that Adaptive Planning’s most recent release now lets the user import an alternate calendar!
This new release allows the user to import up to three alternate calendars. To do so, the user must go to the Time selection under the Modeling section.
By using the TimeStructure spreadsheet, the user can add columns that map the leaf strata of the original calendar to the new alternate calendar.
When adding in a new calendar it is important to make sure that there is at least one common time strata, or fork, to share with the default calendar. Typically, this would be the month.
Additionally, when creating a new calendar, the user must also make sure that it shares the smallest strata with the original calendar.
In the picture above you can see an example where the company has a fiscal calendar that begins in April and ends in March, and a standard calendar that follows January through December.
Notice how the first code, label, and short name columns all have the shared month intersection populated with the dates. This is the lowest fork in the example that enables Adaptive Planning to line up these calendars together.
This is a great new feature that will help many Adaptive Planning clients!
Visit Revelwood’s Knowledge Center for our Adaptive Insights Tips & Tricks or sign up here to get our Adaptive Insights Tips & Tricks delivered directly to your inbox. Not sure where to start with Adaptive Insights? Our team here at Revelwood can help! Contact us info@revelwood.com for more information
This blog post was co-authored by Ben Alcock, associate consultant at Revelwood and Julia Seelin, associate consultant at Revelwood.
Read more Workday Adaptive Planning Tips & Tricks:
Workday Adaptive Planning Tips & Tricks: How to Create a Dimension
Workday Adaptive Planning Tips & Tricks: Reusable Reports
Workday Adaptive Planning Tips & Tricks: Crosstabs – The Significance of and How to Build
