Workday

Reset to Default View on Sheets

May 28, 2025 by Sarah Hildenbrand

When navigating display options or filters on different types of sheets in Workday Adaptive Planning, it can get messy quickly and even cause the data for a sheet to not load and have an error message. Workday recently released a function where when this occurs, you can simply choose “reset to default” to help get back to a good starting point and not have to back track with every display option or filter you chose.

1. First, go to each of your sheets and create the “reset to default view for all users” you want by clicking on the display options button.

2. Select the display options you want and click “OK” and “Set as default for all users”.

3. After choosing the display options, make sure to always save the new view and the default now set for all users.

4. Now when the data isn’t loading for a sheet or causing issues, you can click “Reset for Default” to get back to the past saved default view for an easy way to troubleshoot.

Revelwood is an award-winning, Platinum Solution Provider for Workday Adaptive Planning. We build solutions for the Office of Finance that minimize your risk by seamlessly incorporating business analytics into your everyday thinking. By combining the software with our best practices and out-of-the-box applications, we help businesses achieve their full potential with Workday Adaptive Planning.

Transforming Financial Planning: How LEARN Behavioral Streamlined Operations with Workday Adaptive Planning

May 21, 2025 by Revelwood

We partnered with our client, LEARN Behavioral, on a webinar highlighting how multi-site healthcare organizations can benefit from adopting Workday Adaptive Planning. Here’s their story

LEARN Behavioral is a leading provider of autism services, specializing in Applied Behavior Analysis (ABA) therapy and school-based programs. With multiple regional brands operating under the LEARN umbrella, the organization faced increasing complexity in managing its financial planning and analysis (FP&A) processes.

Challenges Before Workday Adaptive Planning

Prior to implementing Workday Adaptive Planning, LEARN Behavioral encountered several roadblocks in their budgeting and forecasting workflows:

Long Turnaround Times: The process of creating and updating budgets was time-consuming and inefficient.
Manual Excel-Based Templates: Reliance on spreadsheets led to errors, inconsistencies, and difficulties in consolidating data.
Lack of Insights Across Locations: With multiple sites operating under different brands, gaining a unified view of financial performance was challenging.

These challenges highlighted the need for a scalable and integrated solution to support LEARN Behavioral’s growth and operational complexity.

A Game-Changing Implementation

LEARN Behavioral adopted Workday Adaptive Planning to transform its FP&A capabilities. The implementation brought significant improvements, including:

Streamlined Processes: By automating data collection and reporting, LEARN drastically reduced the time required for budgeting and forecasting.
Enhanced Data Visibility: Centralizing financial data improved consistency and provided a single source of truth for decision-making.
Rolling Forecasts: The ability to maintain monthly rolling forecasts enabled greater flexibility and responsiveness to changes in the business.
Scenario Analysis: LEARN gained powerful scenario modeling tools to evaluate financial impacts and make informed decisions.

Empowering Operations with Data-Driven Insights

One of the most impactful outcomes of the implementation was empowering the operations team with direct access to financial data and dashboards. This self-service approach enabled managers to:

Monitor performance in real-time.
Identify trends and variances quickly.
Make data-driven decisions without relying heavily on the finance team.

Integration and Unified Systems

Another critical benefit was the seamless integration of billing, payroll, and financial data into a single platform. This unified system eliminated data silos, ensuring consistency and enabling better collaboration across departments.

Measurable Results and Future Outlook

Since adopting Workday Adaptive Planning, LEARN Behavioral has seen:

Reduced budgeting and forecasting timelines.
Improved accuracy and consistency in financial data.
Better insights to support growth and multi-site operations.

Looking ahead, LEARN Behavioral is well-positioned to continue scaling its services while maintaining financial discipline and operational efficiency.

LEARN Behavioral’s journey with Workday Adaptive Planning serves as an example of how technology can transform financial processes in complex, multi-site organizations. By streamlining workflows, enabling better data access, and enhancing forecasting capabilities, LEARN is now equipped to focus on its mission of providing high-quality autism services to families across the country.

Watch the webinar to learn more!

Workday Adaptive Planning Tips & Tricks: Report Parameter Behavior

May 14, 2025 by Julia Seelin

Recent updates to reporting tools in 2025 R1 of Workday Adaptive Planning streamline the creation and management of report parameters. These updates offer key benefits such as:

Consistent parameter creation across level, dimensions, and attributes, and
Automatic inclusion of new values as they become available.

This eliminates the need for manual updates and ensures reports are always up-to-date.

Users should review existing reports to take advantage of these improvements, potentially eliminating outdated attributes like “values only” filters, which were previously used to exclude uncategorized members.

This feature only applies to all new reports. For any existing reports, you need to manually update the available parameter choices and save them to reflect the latest functionality. If you don’t make any changes, the feature will only apply to new reports.

Learn The Ins and Outs of Reporting in Workday Adaptive Planning

May 7, 2025 by Revelwood

We have another new course offering in our Workday Adaptive Planning Open Enrollment training program. Our Workday Adaptive Web Reporting & Dashboards course is designed for both beginner and intermediate users who want to expand their reporting skills in Workday Adaptive Planning.

Participants will learn how to:

Use the matrix report builder, including basic and advance calculations and formula options
Design a P&L report
Create a version comparison report
Report on modeled sheet data
Use conditional formatting and display options
Understand the benefits of the upload file “report”

Learning from Revelwood’s Workday Adaptive Planning Certified Experts

Revelwood’s Open Enrollment training courses for Workday Adaptive Planning are conducted online by our seasoned, Workday-certified instructors. Their goal is to give you the technical skills needed to understand, use and master Adaptive Planning.

These instructor-led courses allow you to ask questions and get instant answers from your instructor. They also provide you an environment where you can learn from your classmates – unlike many online classes. Participants will come away from the courses with best practices and new tips and tricks. Workday Adaptive Web Reporting & Dashboards training courses are virtual (online) and occur regularly.

View our class schedule.

Workday Adaptive Planning Tips & Tricks: Greatest & Least Formulas

April 30, 2025 by Cameron Burke

Many of you have probably used the MIN and MAX formulas in Excel when working with financial models, reporting, and data analysis, comparing and selecting minimum or maximum values in a range is a common requirement. In Workday Adaptive Planning, we achieve these results by using the “least” and “greatest” functions. While these functions serve similar purposes, there are key differences in their syntax, use cases, and behavior. Let’s explore these differences to help you transition smoothly between Excel and Workday Adaptive Planning.

Excel’s MIN and MAX Functions

Syntax and Usage

Excel provides the following functions for determining the smallest and largest values within a range or set of numbers:

=MIN(number1, number2, …, range) – Returns the smallest number from the given arguments.
=MAX(number1, number2, …, range) – Returns the largest number from the given arguments.

Examples

=MIN(5,10,15) – Returns the number 5.
=MAX(A1:A10) – Returns the highest value within this range of cells.

Syntax and Usage

Accepts both individual numbers and ranges.
Ignores blank cells and text values within a range.
Can handle a large dataset efficiently.

Workday Adaptive Planning’s “Least” and “Greatest” Functions

Syntax and Usage

In Workday Adaptive Planning, similar functionality is achieved using:

least(value1, value2, …) – Returns the smallest value from the provided list.
greatest(value1, value2, …) – Returns the largest value from the provided list.

Examples

least(5, 10, 15) – Returns 5
greatest([Account1], [Account2], [Account3]) – Returns the highest value among the specified accounts
greatest(Account1 – Account2, 0) – Returns 0 if the formula results in a negative number

Key Features

Works with both hardcoded values, account references and formulas.
Requires specifying individual values explicitly; does not accept a single range like Excel.
Useful for comparing multiple account balances or forecast values within a model.

Understanding these differences ensures a smoother transition between Excel-based financial modeling and Workday Adaptive Planning. While the fundamental concept remains the same, adjusting for syntax and range-handling nuances will help you leverage these functions effectively in both tools.

Revelwood Offers Open Enrollment for Workday Adaptive Planning OfficeConnect

April 23, 2025 by Revelwood

We have expanded our Workday Adaptive Planning Open Enrollment training courses. We now offer a new class, Introduction to OfficeConnect.

The course is designed for report developers with minimal experience with Workday Adaptive Planning’s OfficeConnect. Participants will learn:

OfficeConnect terminology and navigation.
How to create an OfficeConnect report dynamically linked to a Workday Adaptive Planning instance.
How to work with relative and static time-elements enabling you to create rolling report periods.
How to use parameters and labels to enable creating either a tabular Excel report or one report with selection options. A report with selection options is mainly used with the Level element from Workday Adaptive Planning.
How to link selected elements from a previously created Excel report to the matching Workday Adaptive Planning data. This enables you to use all of the creative presentation already existing in the report.

Additionally, participants will see a demonstration of the connectivity between OfficeConnect and its associated Word and PowerPoint applications.

Learning from Revelwood’s Workday Adaptive Planning Certified Experts

Workday Adaptive Planning OfficeConnect

Workday Adaptive Planning OfficeConnect enables users to easily create presentation-quality financial reports in Microsoft Office. With OfficeConnect, you can integrate your latest data from Workday into Microsoft Office. For example, you can connect your existing Microsoft Excel reports to Workday Adaptive Planning. You can also create new reports. Refreshing those reports is as simple as a single click – no more need to manually transfer data.

OfficeConnect gives you full connectivity between Adaptive Planning and Microsoft Excel, Word and PowerPoint. You latest data in Adaptive Planning easily flows from financial reports to board books to management presentations.The OfficeConnect training courses are virtual (online) and occur on a regular basis. View our class schedule.

Workday Adaptive Planning Tips & Tricks: Editing Dimensions

April 16, 2025 by Revelwood

Both modeled and cubed sheets in Workday Adaptive Planning offer the ability to add dimensionality to the model to further enhance data visualization. Dimensions and their values are often needed to be updated and maintained. While this could be seen as an inconvenience, Adaptive offers a feature that enables the user to edit the dimension directly on a cubed or modeled sheet rather than having to navigate through modeling to the dimension home screen.

If you navigate towards the back end of your cubed or modeled sheet and press on column and levels, you will see your dimensions. Select the dimension you want to enable the feature on, and check the “Edit dimension on sheet” checkbox circled in red. Save your changes.

To use the feature, navigate to the front end of the sheet you are working on. Hover over the cell you want to edit under the correct dimension column, and click the drop down arrow. You will then hit the “Edit Dimension” button that is circled in red.

Next, the window below will pop up. Circled in red is the button to add a new dimensional value directly onto the sheet. This will also be updated on the main dimensions tab as well. Additionally, you have the ability to rename an existing dimension in this same window.

This feature is also available for text-selectors and follows the same process as dimensions.

Selecting the Right Implementation Partner for Success with Workday Adaptive Planning

April 9, 2025 by Revelwood

Implementing a Workday Adaptive Planning environment can be the start of a transformative journey for the Office of Finance. Choosing the right implementation partner is as critical as selecting the software itself.

Meet Your Team: Why Face-to-Face Interaction Matters

One of the most effective ways to evaluate a potential implementation partner is to meet their consultants face-to-face (or via Zoom!), ideally during the selection process. These consultants will be responsible for guiding your organization through a significant transformation, so it’s crucial to understand their experience, approach, and how they align with your company’s culture.

Request meetings with the actual delivery team members rather than just sales representatives. This will give you a clearer view of who will be working with you day-to-day throughout the design and implementation phases. You should try to get an understanding of the experience levels of the people you will be working with. Ask about the individual strengths of the team members. This can provide invaluable insights into the partner’s ability to understand your goals and translate them into a successful Workday Adaptive Planning implementation.

Ask the Tough Questions: Beyond the Basics

Choosing the right partner goes beyond just checking credentials and past projects. Ask questions that will give you a deeper understanding of their capabilities. Assessing their Workday Adaptive Planning knowledge is a must, but it’s equally important to explore their problem-solving skills and project management approach. How do they handle unexpected challenges? How proactive are they in mitigating risks and adapting to changes? Do they offer ongoing support after the initial implementation?

The answers to these questions will give you a sense of their readiness to handle the complexities and uniqueness of your project. A good partner should be able to anticipate and address issues that might arise, and they should have a structured yet flexible approach to achieving your objectives.

Trust Your Instincts with the Right Partner

Another critical factor is how well the partner’s team communicates with you during the selection phase. Are they responsive, transparent and professional? These qualities are often indicators of how they’ll operate once the project begins. Choose a team that communicates clearly, listens actively and demonstrates a genuine commitment to your project’s success. How invested are they in your success?

If there’s a natural rapport and an ease of communication, it’s a good sign that you’ll be able to work together effectively. On the other hand, if interactions feel strained or overly formal, it might signal challenges down the road.

Maximizing Your Opportunities for Success

Implementing a Financial Planning and Reporting system requires a substantial commitment of time and resources. By actively leading the selection process for your implementation partner, you establish a solid foundation for a productive collaboration and a smoother, more efficient project rollout. When you invest the time to carefully select the right partner, you’ll be well-prepared to manage the complexities of design and implementation and succeed with confidence.

Revelwood is an award-winning, Platinum Solution Partner for Workday Adaptive Planning. We’ve worked with Workday customers of all sizes, in every industry. Learn more about our Workday Adaptive Planning practice.

Cube Sheet Restrictions in Workday Adaptive Planning

April 2, 2025 by Cameron Burke

Cube sheets in Workday Adaptive Planning often include a wide range of filters such as dimensions, accounts, attributes, and others. However, not all options under each filter are relevant for every model. By taking advantage of the cube sheet restrictions feature in Workday Adaptive Planning, you can hide or limit unnecessary filters, simplifying the sheet and improving usability.

The restrictions function offers powerful customization options. Users can configure a sheet to display different accounts for the actuals version versus the forecast version, specify accounts tied to specific dimension values, filter accounts to appear at different levels, and more. This flexibility helps tailor cube sheets to your needs while keeping them efficient.

It’s important to note that cube sheets have a 15,000-row limit. Using restrictions to limit intersections on the sheet prevents unnecessary rows, ensuring optimal performance and maintaining clarity in your data.

How To Add Cube Sheet Restrictions

1. Go to Modeling -> Level assigned or user assigned sheets -> Select the cube sheet you want to add restrictions to.

2. Click Restrictions

3. Click Add New

There are two elements of a cube sheet restriction. The first is selecting what dimension determines what you want to restrict and the second is what dimension will be restricted.

In this example, if you create a Level/Site-Dimension restriction, you can specify which sites to be able to select for any given set of levels.

Here, I am checking off just Sites 1, 2, and 3 to be shown for the Operations level.

For the Marketing level, I want sites 4, 5, and 6 to show, but not 1-3 or 7-9. Click the save icon in the top left corner.

Now, when I filter this cube sheet by the Operations level, only sites 1-3 are available to select from the dropdown. When I go to the Marketing level, only sites 4-6 are available.

Workday

Read more Workday Adaptive Planning Tips & Tricks:

Challenges Before Workday Adaptive Planning

A Game-Changing Implementation

Empowering Operations with Data-Driven Insights

Integration and Unified Systems

Measurable Results and Future Outlook

Read more Workday Adaptive Planning Tips & Tricks:

Participants will learn how to:

Learning from Revelwood’s Workday Adaptive Planning Certified Experts

Excel’s MIN and MAX Functions

Syntax and Usage

Examples

Syntax and Usage

Workday Adaptive Planning’s “Least” and “Greatest” Functions

Syntax and Usage

Examples

Key Features

Read more Workday Adaptive Planning Tips & Tricks:

Learning from Revelwood’s Workday Adaptive Planning Certified Experts

Workday Adaptive Planning OfficeConnect

Read more Workday Adaptive Planning Tips & Tricks:

Meet Your Team: Why Face-to-Face Interaction Matters

Ask the Tough Questions: Beyond the Basics

Trust Your Instincts with the Right Partner

Maximizing Your Opportunities for Success

How To Add Cube Sheet Restrictions

Read more Workday Adaptive Planning Tips & Tricks:

Footer

Revelwood Overview

EXPERTISE

ABOUT

CONNECT