• 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
        • Workday Adaptive Planning Training
        • IBM Planning Analytics / TM1 Training
    • Products
      • DataMaestro
      • LightSpeed
      • IBM Planning Analytics Utilities
  • How We Help
    • Use Cases
    • Client Success Stories
  • How We Think
    • Knowledge Center
    • Events
    • News
  • Contact Us

Adaptive Insights

FP&A Done Right: Traditional Budgeting is a Challenge

May 1, 2020 by Revelwood Leave a Comment

FP&A Done Right

This is a guest blog post from our partner Workday Adaptive Planning, written by Gary Cokins. Cokins explains why traditional budgeting is no longer adequate for most companies.

Traditional budgeting is simply too slow and too rigid to keep up with today’s rapidly changing business environment. There is great volatility, complexity, and uncertainty in the future. Gone are the days when budgets could be one-and-done — tied to a fixed point in time and too inflexible to adjust to quickly changing business opportunities and challenges. In today’s world, a startup can be up and running and profitable in three months and disrupt its competitors. Consider Uber and Airbnb as examples. If your company takes nearly as long to develop an annual budget, it will be extremely difficult to fight off the upstarts or keep up with your established competitors.

The solution? A flexible, continuous budgeting and forecasting process that helps you anticipate change and focus on outcomes rather than outputs. Rolling financial forecasts are emerging as a valuable planning method to augment the annual budget.

Here are five tips to modernize your budget process:

Tip 1 – Just say no to one-and-done

Now more than ever, December’s fiscal year-end budget numbers often bear little resemblance to July’s realities—requiring more streamlined, accurate, and responsive budgets and forecasts. Annual budgeting won’t go away, but spending weeks and months processing data and reconciling spreadsheets that are out of date soon after the consolidated master budget is published doesn’t cut it anymore.

Modern budget solution:
● Increase the frequency of budgets and forecasts to reflect shifting business conditions
● Make decisions and plans based on data-backed insights rather than old and stale information
● Change how resources are allocated throughout the year and how it incorporates real-time opportunities and challenges

Tip 2 – Focus on business drivers, not cost centers

Traditional budgeting focuses on allocating resources to cost centers, but business objectives (e.g., projects, products, service lines) are cross-functional with end-to-end business processes. By assigning resources to projects and processes, budgets and forecasts reflect company-wide versus cost-center specific performance.

Modern budget solution:
● Enable organization-wide access to reports and data that allows everyone to have visibility into project-level and process-level performance
● Review forecasts against project and process budgets to eliminate confusion among competing departments
● Provide real-time information for the needed insights to support better decision-making at all levels of the organization

Tip 3 – Create rolling forecasts

More than ever, fluctuating market conditions make accurate forecasts extremely challenging. Rolling financial forecasts help manage funds and provide visibility into business performance using time horizons that reflect the speed of your business.

Modern budget solution:
● Generate rolling financial forecasts that accommodate real-time shifts in market conditions
● Enable self-service reporting so everyone in the organization can measure their performance against companywide KPIs
● Help everyone understand the downstream effects of their resource allocation decisions

Tip 4 – Look forward, not back

Most budgets and forecasts are outdated before you push “publish” or soon afterward. And some factors are impossible to take into account (natural disasters, broken supply chains, work stoppages). The rear-view mirror orientation of traditional budgeting (last year’s actuals create this year’s budgets) can’t keep up with the speed of modern business. Look through the windshield.

Modern budget solution:
● Respond faster to shifts in market conditions with real-time access to financials
● Adjust outdated budgets and forecasts as change occurs
● Move leadership discussions toward insight, planning, and action, rather than using the budget as a cost control mechanism

Tip 5 – Use the right tools for the job

Creating a budget process that keeps up with the pace of today’s business requires a comprehensive, collaborative, and continuous planning platform—one that gives you robust, accessible reporting and modeling capabilities; dashboards that provide visibility into overall company performance; and automated tools that streamline budgeting and forecasting processes.

Modern budget solution:
● Enable comprehensive planning that aligns the priorities and actions of everyone across the organization around common KPIs
● Create opportunities for collaboration by giving everyone access to the data they need and deserve
● Adjust and update budgets and forecasts on a continuous basis so you can navigate volatile market conditions in real time

Don’t let traditional budgeting lock you into outdated assumptions and fixed targets. Some managers view the fiscal year budget as a “contract” with handcuffs that they cannot get out of to minimize unfavorable variances from their allotted cost center budget expenses. This short-term focus jeopardizes the longer-term view. The modern FP&A professional knows the truth: Aligning budgets and forecasts with comprehensive plans lays the groundwork for proactive rather than reactive planning—a significant strategic advantage in today’s highly competitive environment.

Gary Cokins is an internationally recognized expert, speaker, and author in enterprise and corporate performance management (EPM/CPM) systems. He is the founder of Analytics-Based Performance Management LLC. Gary can be reached at gcokins@garycokins.com

This blog post was originally published on the Workday Adaptive Planning blog.

Read more guest blog posts from our partner Adaptive Insights:

FP&A Done Right: What is Financial Modeling?

FP&A Done Right: How to Improve your Financial Reporting Process

FP&A Done Right: 3 Barriers to Business Agility

Home » Adaptive Insights » Page 4

Filed Under: FP&A Done Right Tagged With: Adaptive Insights, Budgeting, Budgeting Planning & Forecasting, business drivers, Financial Performance Management, modern FP&A, Planning & Forecasting, Rolling Forecasts

FP&A Done Right: Spreadsheets are Outdated

April 17, 2020 by Revelwood Leave a Comment

FP&A Done Right

This is a guest blog post from our partner Workday Adaptive Planning, written by Adaptive Insights’ Founder Rob Hull. It was originally published on FEI Daily.

The global marketplace is moving faster, requiring companies to be more agile than ever in this age of urgency. Yet businesses—and specifically finance teams—still rely on tools that sustained them decades ago. Those tools were designed for an age when planning was an annual, top-down and linear process, but today we no longer have the luxury of devoting an average of 77 days to develop an annual plan. Change is continuous, so planning must be too.  And it must also be more collaborative.

The rapid change in our technological ecosystem is causing a growing number of finance chiefs to tell their staff to find tools better suited to modern business planning and analysis than spreadsheets — for decades the default planning application for virtually every business. The inconveniences of spreadsheets for planning and analysis, such as version control errors stemming from manual data entry, clumsy email collaboration, and the challenges of creating a single source of truth from disparate data sources can now be a distant memory thanks to modern planning tools. As Bernard Marr observed in Forbes, spreadsheets may still be a great choice for some tasks, but not for the kind of agile planning and analytics required in today’s fast paced business environment.

From the cloud, a different way to plan

These and other observers have pointed to the rise of cloud-based planning software that has taken the fundamental capabilities of the noble spreadsheet and turned them into something that spreadsheets never quite managed to be – automated, intuitive, collaborative, integrated, multi-dimensional, and always up to date. Just as cloud-based CRM applications like Salesforce.com replaced legacy applications like Siebel, so too are cloud planning solutions replacing spreadsheets and legacy applications to provide much needed agility in today’s era of urgency.

Spreadsheets are a wonderful personal productivity tool, and as such will continue to have a place among business applications. But for company-wide finance, sales, and workforce planning, reporting and analysis, the future will look different than the past.

The future of planning is unfolding

With the advancement in technology, we’re starting to see menial tasks accomplished through automation, making time for teams to spend on high value tasks. Finance execs report that, on average, 83 percent of their staff’s time is spent on manual, menial tasks like data input and consolidation. That’s lost time that could be converted to more valuable and strategic tasks with better tools for planning, reporting and analysis.

Pinsent Masons LLP, a UK-based law firm with offices throughout Europe, the Middle East, Africa, Asia, and Australia, found that swapping out spreadsheets for cloud-based planning, reporting and analysis helped automate previously manual tasks, freeing finance staff to be more strategic. “We spent 70 percent of our time entering and verifying data, and 30 percent viewing and interpreting it,” notes Andrew Brett, who heads financial reporting at Pinsent Masons. “We now can spend seven out of every 10 hours gleaning insight from our data.”

Meanwhile, anytime, anywhere access and intuitive application design make planning far more collaborative. Spreadsheets are great for individual users, but in small groups, they’re less great and in large groups, they’re abysmal. On the other hand, cloud solutions were built for collaboration. They allow any authorized participant to work on a plan, from anywhere, at any time. Better still, you’ll always know who made changes and when. Leading cloud vendors have introduced intuitive planning interfaces that make it easy for non-finance personnel to collaborate, enter data, create reports, and run what-if scenarios because they recognize that in business, everybody plans.

Organizations that make the digital transformation leap for planning will see gains in scale and speed. The spreadsheet wasn’t built for enterprise scale, but the cloud was – modern cloud-based planning solutions can support thousands of concurrent users and highly complex multi-dimensional models. Modern solutions are also built to address the performance demands of enterprises. The most advanced cloud planning software solutions use powerful modeling engines that add memory and compute resources when needed and remove the data limits finance pros have come to despise.

Teams can also access data from every corner of the business. Manually importing enterprise data into spreadsheets can be complicated and troublesome — and that’s being polite. In contrast, the best cloud platforms automatically integrate data from your ERP, HCM, CRM and other transactional data sources so that you can refresh data with a single click and know you are working with the latest information.

Mind the gap

There’s a dangerous gap that can emerge when companies rely on outdated processes while their competitors embrace new, more agile ways of working. Agile teams produce market-leading results. The gap yawns even wider for companies still relying on tools developed for the way businesses operated before the internet changed…well, everything.

Holistic company-wide planning isn’t the pipe dream it once was – it’s now a business imperative and it’s the key to unlocking the kind of agility that turns planning into a competitive advantage. Realizing this, more and more execs are coming to the same conclusion: On the journey to the future, spreadsheets for business planning have become as archaic as the Rolodex.

Rob Hull is the founder of Adaptive Insights, a Workday company. Rob had a vision to provide modern finance leaders with an easy-to-use SaaS-based solution to manage business performance. Today that vision is a reality for thousands of businesses around the world.

This post also appeared on the Workday Adaptive Planning blog.

Read additional FP&A Done Right blog posts from our partner Adaptive Insights:

FP&A Done Right: Can you Recover from Static Planning?

FP&A Done Right: How to Improve your Financial Reporting Process

FP&A Done Right: 3 Barriers to Business Agility

Home » Adaptive Insights » Page 4

Filed Under: FP&A Done Right Tagged With: Adaptive Insights, Analytics, Budgeting, Budgeting Planning & Forecasting, Financial Performance Management, FP&A, FP&A done right, Planning & Forecasting, Planning & Reporting, Revelwood, Rob Hull, spreadsheets

Revelwood Offers Adaptive Insights Training Online

April 16, 2020 by Lisa Minneci Leave a Comment

News & Events

Get the most out of your Adaptive Insights implementation by taking Adaptive Insights training from our award-winning team. Our seasoned, Adaptive-certified instructors ensure you get the technical skills you need to excel with Adaptive Insights.

We offer a range of courses – for the new Adaptive Insights user to experienced Adaptive Insights users looking to take the next step in planning and reporting.

Our current Adaptive Insights training courses are:

Introduction to Adaptive Planning & Reporting

This course introduces new users to Adaptive Planning. You’ll learn Adaptive basics, including:

  • How to navigate throughout the application
  • Structure design element basics
  • How to create an Operating Expense sheet and enter a budget into it
  • Models & Cubes, Users & Roles, Basic Formulas, Basic Reports, and more

Adaptive Reporting

We’ve designed this course for both new users and intermediate users who want to learn about the reporting features in Adaptive Planning. You’ll learn:

  • How to use the matrix report builder
  • How to design a P&L report
  • How to create a version comparison report
  • How to use conditional formatting and display options, and more

Introduction to Office Connect

If you have minimal experience with the Office Connect application, then this is the course for you! You’ll learn:

  • Office Connect terminology and navigation
  • How to create an Office Connect report that is dynamically linked to Adaptive Planning
  • How to work with relative and static time-elements, enabling the creating of rolling period reports
  • How to link selected elements from an Excel report to matching Adaptive Planning data, and more

We offer two different options for these online courses. The first option is a four and a half hour long, fully interactive course. In order to participate in this, your company must have access to the Adaptive Insights eLearning program. The second option is an online, three-hour, view-only course. This course is open to everyone.

Check out our class schedule to find a convenient time for you to hone your Adaptive Insights skills!

Home » Adaptive Insights » Page 4

Filed Under: News & Events Tagged With: Adaptive Insights, Adaptive Insights training, adaptive planning training, Analytics, Budgeting, Budgeting Planning & Forecasting, Financial Performance Management, Planning & Forecasting, Planning & Reporting, Revelwood

FP&A Done Right: Financial Modeling – Your Superpower

March 6, 2020 by Revelwood Leave a Comment

FP&A Done Right

This is a guest blog post from our partner Workday Adaptive Planning, written by Gary Cokins. Cokins explains financial modeling.  

Financial modeling is like a superpower—one that lets you test your assumptions and hypotheses across dimensions, versions, and time before executing budgets and plans. A well-formulated model lets you run unlimited scenarios across any program, department, or business unit, according to your fiscal calendar or other business milestones. In other words, dynamic financial models show you the probable results of pulling various levers (e.g., adding headcount, reducing production time, expanding sales territories) to see likely outcomes.

Not exactly X-ray vision, but close.

Yet if financial modeling is a superpower, outdated tools and manual processes that limit the number and types of scenarios you can run are kryptonite.

Let’s take a look at how to generate flexible and robust financial models powerful enough to drive strategic decisions and help your business leap over the competition in a single bound.

Manual processes undermine your models

Ideally, financial models should be robust and flexible enough to accommodate current circumstances and multiple queries. If your team is bogged down aggregating data from multiple sources and making sure spreadsheets are accurate, modeling takes a back seat to fixing errors and broken formulas.

According to an Adaptive Insights CFO Indicator Report, 71% of finance teams manage data from at least three sources. When data is aggregated manually from multiple sources and managed in spreadsheets, it’s often laborious, error-prone, and inaccurate.

Financial modeling that works in today’s fast-paced business models should automate these processes and free your time to test your hypotheses.

Properties of robust models

Robust models should let you model everything, everywhere—expenses, capital, headcount, revenue, projects, grants, quotas, and territories—across any department, entity, or function.

Your financial model is an opportunity to check in with stakeholders, gather information about priorities and plans, and create a set of assumptions that improve decision-making throughout your organization. Done well, financial models teach you and the people in your organization something: a new way of doing business, in-depth information about the competitive landscape, or the factors that might support or detract from corporate objectives and KPIs.

Robust and effective financial models should accomplish the following:

  • Establish a single source of truth

A single source of data truth that is accessible, relevant, and flexible enough to respond to emerging market conditions ensures that there’s a united front and full alignment behind the same objectives. When everyone agrees on the validity and accuracy of the data, there is less bickering over the numbers and more collaboration between business units.

  • Build confidence in the numbers

If everyone is fighting about the validity of data sources, the process will be caught up in arguments instead of strategic decision-making. From extensive cost allocations, multiple budget versions, and a variety of organizational structures, your financial models and analytics should build confidence in the numbers and the models.

  • Automate calculations

Outdated tools and manual processes take too much time to generate insights. By automating planning, budgeting, and forecasting tasks, your team will have more time to run unlimited what-if scenarios and answer multidimensional queries in real time.

  • Enable collaboration

Everyone in your organization is modeling—whether they know it or not. By making financial data modeling tools broadly available to business units and ensuring that tools are user-friendly, you’ll allow everyone to weigh in—on assumptions about headcount, product releases, and more. After all, true collaboration results in better financial models.

Modern modeling requires modern tools

Modern businesses require modern financial modeling and analysis capabilities that enable on-the-fly queries and limitless what-if scenarios and testing. Proliferating data, outdated tools, and a rapidly changing market make continuing with the same-old, same-old a strategic mistake.

The solution? An intelligent, scalable, and comprehensive cloud-based planning platform that gives you the power you need to support the sophisticated and robust financial planning, modeling, and analytics modern businesses require.

Gary Cokins is an internationally recognized expert, speaker, and author in enterprise and corporate performance management (EPM/CPM) systems. He is the founder of Analytics-Based Performance Management LLC. Gary can be reached at gcokins@garycokins.com

This blog post was originally published on the Workday Adaptive Planning blog.

Home » Adaptive Insights » Page 4

Filed Under: FP&A Done Right Tagged With: Adaptive Insights, Analytics, Budgeting, Budgeting Planning & Forecasting, financial modeling, Financial Performance Management

Adaptive Insights Scores Highest in Gartner 2019 Critical Capabilities Report in Three Use Cases

March 2, 2020 by Lisa Minneci Leave a Comment

News & Events

Adaptive Insights earned the highest scores in the Gartner 2019 Critical Capabilities for Cloud Financial Planning and Analysis Solutions report for lower midsize organization use cases, upper midsize use cases and for business unit use cases.

Gartner’s Critical Capabilities for Cloud Financial Planning and Analysis Solutions report examines the strengths of different vendors offering financial planning and analysis solutions as it relates to specific use cases. The goal of the research is to help organizations assess products and compare products that most closely meet their business needs. Overall Gartner found that many of the vendors covered in the research “improved year-over-year scores in critical capabilities.” The report continues, “this indicates that maturity levels and satisfaction associated with cloud offerings in this market are rapidly improving.”

Gartner’s assessment of Adaptive Insights includes the following highlights:

  • Top quartile scores for ease of implementation
  • Top quartile scores for ease of use and maintenance
  • Top quartile scores for financial budgets and plans

Additionally, Gartner writes “Adaptive Insights improved its scores across all capabilities this year, with financial budgets and plans and IFP/modeling showing the largest improvements.”

Adaptive Insights Scores 4.40 out of 5.0 in Lower Midsize Organization Use Case

Gartner defines “lower midsize organization” as “small public or private organizations between $50 million and $250 million in annual revenue.”

Adaptive Insights Scores Highest in Gartner 2019 Critical Capabilities Report in Three Use Cases

Adaptive Scores 4.32 out of 5.0 for Upper Midsize Organization Use Case

An “upper midsize organization” is defined as “midsize public or private organizations with $250 million to $1 billion in annual revenue.”

Adaptive Scores 4.32 out of 5.0 for Upper Midsize Organization Use Case

Adaptive Insights Scores 4.34 out of 5.0 in Business Unit use case

This category is for business units in large organizations.

Adaptive Insights Scores 4.34 out of 5.0 in Business Unit use case

According to Gartner, the research “analyzes how successfully the selected vendors support FP&A processes, as well as the successes of their respective solutions in terms of use and adoption.” In addition to Adaptive Insights, the report includes Anaplan, BOARD International, CCH Tagetik, Host Analytics (now Planful), IBM, Jedox, Kaufman Hall (Axiom Software), Kepion, OneStream Software, Oracle, Prophix, SAP, and Vena Solutions.

Home » Adaptive Insights » Page 4

Filed Under: News & Events Tagged With: Adaptive Insights, Analytics, Budgeting, Budgeting Planning & Forecasting, Financial Performance Management, Planning & Forecasting, Planning & Reporting

FP&A Done Right: The Path to Great Reporting

February 28, 2020 by Revelwood Leave a Comment

FP&A Done Right

This is a guest blog post from our partner Workday Planning, written by Gary Cokins. Cokins discusses some of the challenges with traditional financial reporting processes.  

For FP&A, financial reporting is a tricky balancing act.

If you share too many reports, business leaders may give up reading them all together. They are saturated. In a study by the American Institute of CPAs and the Chartered Institute of Management Accountants, 32% of C-level executives said more data has made things worse, not better, for decision-making.

But if you offer bare-bones financial reporting, stakeholders scream for more relevant data and timely information. Case in point: That same survey found 70% of C-level executives saying at least one strategic initiative failed in the last three years due to delays in strategic decision-making. So how do you find the balance of not overwhelming your business partners while still getting them the information they need?

They need facts because in the absence of facts, anybody’s opinion is a good one. And usually the biggest opinion wins, which is likely managers at the top of the org chart. So to the degree they are making decisions on gut feel, intuition, flawed and misleading information, or office politics, an organization is at risk.

Here are three proven steps:

Step #1: Survey users

Your CEO needs access to different data than the manager of HR. Yet there’s also a good chance that they may be interested in some of the same information. And even within the same departments, managers may seek different information. Managers have varying requirements and goals; some prefer a very high-level overview, while others want specific information and a lot of granular details.

So what’s a finance team to do?

It sounds simple, but it begins with good communication. Talk to users and find out what they want and why they want it. Ask what types of decisions they will make with better information. Delve into how they would like reports presented and how often they need them. From time to time, follow up with a brief meeting or a simple survey to ensure that managers are using reports and if there is any new information that would be useful.

Of course, it’s essential to continue to make ongoing investments in technology that ensure you can deliver the reports that business partners are looking for in user-friendly formats. Technology investments not only save FP&A time—which allows for a more thoughtful and strategic approach to generating relevant reports—they also have a measurable impact on the bottom line. A study conducted by Nucleus Research found the average return from each dollar spent on analytics technology was $13.01.

Step #2: Customize dashboards

A key strength of technology investments is dashboard technology. Dashboards have revolutionized reporting, dramatically reducing the mountains of spreadsheets with racked-and-stacked tables that find their way to managers and department heads via email or hard copy. So make sure you are making the most of the technology by working with users to customize dashboards so they can access the reports they want and in a format that is most useful to them.

A customized dashboard allows managers to do a better job by measuring and monitoring performance as well as proactively shaping business outcomes through real-time awareness of financial and sales data. Dashboards are also a powerful tool to track your company’s actual broader performance against your planned expectations and goals, year to date.

When it comes to dashboards, a quick demo can go a long way. You can show users the power of data visualization presented in a range of formats from standard bar, column, or doughnut charts to more engaging funnel, waterfall, and bubble graphics. And you can demonstrate how they can generate their own reports to gain even further insight into their team’s performance and how it impacts the entire organization.

These visualization tools have proven to be game-changers in terms of making reports accessible and understandable to a wide range of users. As a TechTarget writer recently pointed out: “Without (data visualizations), analytics teams are engaging in a nearly impossible task that’s tantamount to flying an airplane while blindfolded.”

Step #3: Track results

It’s often said that what gets measured gets done. It’s also often said that if you cannot measure it, you cannot manage it, and if you cannot manage it, you cannot improve it. With that in mind, one way to ensure that relevant reports are being generated is to assess whether they are leading to measurable results.

Have reports resulted in greater efficiency, changes in behavior, or an uptick in sales and profits? Internally, are the reports helping drive collaboration and more insightful conversations? If not, why? You may need a deeper dive into whether the right information is getting into the right hands at the right time.

Opening lines of communication with business partners is key. Discuss targeted outcomes and then identify the reporting—or tweaks to reporting—that will provide the real-time data and insights to drive better results. Adaptive Insights customer Cumulus Media successfully applied this approach, instituting self-service reporting so users across the organization can create and run reports on demand. The result: It now takes just seconds—not days—to access and analyze business performance data relevant to each manager.

Finally, celebrate and highlight success. If a certain department is delivering big wins by leveraging insights from the reports it is receiving and generating, then promote and broadcast that throughout the organization. Success will breed success.

Good reporting leads to better results

Of course, it’s important to remember that when it comes to reports, finance should be a facilitator and strategic partner, not a hand-holder. Managers need to be self-sufficient. But it’s important to put the relevant information in their hands so they don’t have to track down finance every time they have a question.

Ultimately, good reporting leads to better results. By identifying and delivering the reports that leaders and managers throughout your organization need, FP&A can make a big impact and solidify its role as a strategic business partner. Finance has the opportunity to expand from bean counters to bean growers.

Gary Cokins is an internationally recognized expert, speaker, and author in enterprise and corporate performance management (EPM/CPM) systems. He is the founder of Analytics-Based Performance Management LLC. Gary can be reached at gcokins@garycokins.com

This blog post was originally published on the Workday Adaptive Planning blog.

Home » Adaptive Insights » Page 4

Filed Under: FP&A Done Right Tagged With: Adaptive Insights, Analytics, Budgeting, Budgeting Planning & Forecasting, dashboards, Financial Performance Management, financial reporting, Planning & Forecasting, Planning & Reporting

Adaptive Insights Tips & Tricks: Trigger for a Cube Calculated Account

February 12, 2020 by Michelle Song Leave a Comment

Tips & Tricks

When you try to use the “actuals overlay” function in a cube calculated account to display actuals data from a modeled sheet, but you keep receiving a formula error that says “Cube Calculation Formulas must evaluate to zero when the cube’s other accounts are zero”, what do you do?

Adaptive Insights Tips & Tricks: Trigger for a Cube Calculated Account

The reason for this is that cube sheets are intended to use for data input with multi-dimensions and calculations within the current cube, but not as a way to display data from other areas in the instance. To solve this problem, you have to condition the account based on another account in the current cube sheet.

For example, you can create a “Trigger Account” and assigned a value of 1 to the account for all intersections and periods that you want to display the data.

Adaptive Insights Tips & Tricks

Then, in the formula section of the cube calculation account, write

Adaptive Insights Tips & Tricks

Note: If you do not need the actual overlay function, you can use a Cube Metric account. Cube metric accounts can reference accounts from other sheets and do not need “trigger” accounts.

The team at Revelwood has been recognized by Adaptive for its thought leadership in the space, commitment to its Adaptive Insights practice, and its rapid achievements of milestones. 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.

Read more Adaptive Insights Tips & Tricks from the Revelwood team:

Adaptive Insights Tips & Tricks: Alternate Time Tree

Adaptive Insights Tips & Tricks: Assumption Sheets

Adaptive Insights Tips & Tricks: Finding Missing Formulas

Home » Adaptive Insights » Page 4

Filed Under: Workday Adaptive Planning Tips & Tricks Tagged With: Adaptive Insights, adaptive insights tips & tricks, Analytics, Revelwood

Adaptive Insights Tips & Tricks: Alternate Time Tree

January 29, 2020 by Michelle Song Leave a Comment

Tips & Tricks

Have you ever wanted to have an alternate time tree/ stratum rollup in Adaptive Insights? The current Adaptive Insight system only supports one stratum rollup and there is no “Time Attribute” available in the current system to group the different time periods together. Here are some workarounds for you.

For example, the screenshot below is your current time tree setup in Adaptive Insights. Week is the lowest time stratum in the time tree. It has a stratum rollup of Week – Month – Quarter – Year.

Alternate time tree in Adaptive Insights

This is the main time tree that you used in your company for planning. However, you also have an alternate time tree that you used for your in store calendar, which has a stratum rollup of Week – Cycle – Year. Weeks are the same in both time trees, but Cycles do not roll up into Month and Quarter, so you couldn’t include Cycle in the current time tree.

Here are two methods to achieve an “alternate time tree”:

  1. If the alternate time tree is only used for reporting purposes, plan at the Week (lowest) time stratum and use Report/OfficeConnect to sum up the weeks for each Cycle.
Understanding alternate time trees in Adaptive Insights

In this case, Cycle1-2019 is a subtotal calculation of WK1 to WK4-2019.

2. If the alternate time tree is used for planning purposes, create a dimension for Cycle and use it in the sheet. An example is shown in the screenshot below of a modeled sheet. The timespan is used to input expense for each week. Week 1 to week 4 is Cycle 1, so the values for Cycle 1 are only entered in those periods.

stratum rollup in Adaptive Insights

Here’s a report to show the results.

Understanding stratum rollup in Adaptive Insights

Hope you find this helpful and feel free to reach out to us if you have any questions!

The team at Revelwood has been recognized by Adaptive for its thought leadership in the space, commitment to its Adaptive Insights practice, and its rapid achievements of milestones. 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.

Read more Adaptive Insights Tips & Tricks:

Adaptive Insights Tips & Tricks: How to Override Default Lookups

Adaptive Insights Tips & Tricks: Leveraging your Testing Model

Adaptive Insights Tips & Tricks: Finding Missing Formulas

Home » Adaptive Insights » Page 4

Filed Under: Workday Adaptive Planning Tips & Tricks Tagged With: Adaptive Insights, adaptive insights tips & tricks, Analytics, Financial Performance Management, Revelwood

FP&A Done Right: The Victors of the Decade Combine Agility and Resilience

December 20, 2019 by Ken Wolf Leave a Comment

FP&A Done Right

As we near the end of the decade, it’s a good time to think back about what businesses have learned from an FP&A perspective, and how they can fortify and position themselves for the next decade and for future decades.

The beginning of this decade saw the evolution of online analytical processing (OLAP) systems, such as our beloved TM1, grow into comprehensive and sophisticated platforms for holistic financial and operational performance management. In theory we had the tools to empower Finance to reveal the secrets of business success locked in our systems and in our data.

The last few years of the decade have seen our imaginations captured by the disruptors, the unicorns and those who have seemingly mastered the elusive “digital transformation.” But as we’ve learned over the last quarter, some of those “darlings” of the business world may not be the successes they first appeared to be. Take WeWork for example: the company has not managed growth effectively. They are at a point (or possibly past it) where Finance could step in, do some serious analysis and revisit the company’s business model. Other headline catching companies are growing exponentially, but struggle with delivering profits. This too, points to where Finance can be playing a larger role.

Business Resilience? Or Agility?

These musings were prompted by a recent article by McKinsey on business resilience. When we think about disruptors and unicorns, we might associate them more with the popular FP&A theme of business agility. One of our business partners, Adaptive Insights, frequently talks about business agility in the context of needing to make faster and more informed decisions. The backbone of this is continuous planning, which is spearheaded by the Office of Finance.

In one sense, perhaps, business agility is the young business, the quick, rookie running back on the football field – dodging and weaving and making stellar plays, with end zone celebrations when the offense is in control of the game.

But where does resiliency come in? To me, the resilient business is the more established, mature defensive linebacker, whose job is to thwart the competition, and who is less likely to be celebrating in the end zone, but just as important to winning the game.

The question for all of us, on the precipice of a new decade is, “Will we be playing a mostly offensive game in the next few years, or a mostly defensive game? Perhaps both.” And furthermore, how do we, the CFOs and the leaders in the Office of Finance, best prepare, plan and enable our organizations for what’s to come?

Facing the Future

McKinsey mentions that while we are still in “the largest global economic expansion in history, the outlook is uncertain.” Isn’t it always? The article states that in the company’s latest survey on economic conditions, “executives’ views on the current global economy and expectations of future global growth are less favorable than they have been in years.” I’d posit a good executive is outwardly optimistic and inwardly financially, cautiously pessimistic.

It is in this context that McKinsey examines what makes a company resilient. The article defines resilient organizations as those that exhibit a “willingness to take decisive action to strengthen their balance sheets and improve cash flow before the [previous] downturn hit, often by divesting non-core assets, reducing debt, and improving the efficiency of working capital.” To become a resilient business, McKinsey recommends the following three steps:

  1. Enhance the role of the finance team. They recommend doing this in strategic planning, business analytics and decision-making at all levels of the organization. As the article states, “The best way to do this is to embed finance managers alongside business unit leaders and empower them to be partners in running the business.” Think about that for a moment – take the traditional “bean counter” out of Finance and put her or him with the business unit leader. Imagine the possibilities: the finance professional knows where the data is, how to get answers from that data, and how to slice and dice that data in different ways. The business leader knows what questions to ask – questions urgent for today’s business challenges and vital for tomorrow’s business opportunities and threats.
  2. Pressure test capital structure and scenario plan. McKinsey recommends doing this with both capital structure and cash flow, and using a range of scenarios, “from an economic crisis to other disruptive events.” You might feel somewhat certain your industry will not have a massive disruption like that of Uber on the taxi industry. But what if you are a sports arena? How much overall revenue could, for example, MetLife Stadium lose should there be an NFL strike? Over how many games? While that is not a global crisis, it is an economic crisis with impact far beyond ticket sales. On a global level, are companies pressure testing and scenario planning for the potential impact of Brexit, of various international tariffs and trade disputes that, significantly increase the price of French cheeses and wines served at the high-end luxury suites at a stadium?
  3. Take immediate action to harvest hidden value from their balance sheet. McKinsey research shows “that working capital management is surprisingly variable, even among companies in the same industry.” The organization has found that “large companies that make a focused effort can typically free up more than $100 million from working capital and redeploy it to priority projects.” This argues for going beyond traditional budgeting and embracing more flexible planning methodologies, such as rolling forecasting or active planning. For example, McKinsey revealed that they saw “upside realized by companies that consistently track cash returns on an asset level and that make an ongoing effort to reevaluate and mitigate their liabilities.” With traditional budgeting and planning, you are assessing your balancing sheet in the past. By adopting rolling forecasting or active planning – where you have the tools and skill sets to assess and adjust your balance sheet proactively – you have the power to gain this upside.

As McKinsey states, “While most CFOs have a role in setting company strategy, the rest of the finance organization are sometimes viewed as passive scorekeepers. Best-in-class organizations, in contrast, expect their finance professionals to play a substantial role with business-unit leaders to set strategic priorities.”

Your Game Plan: Find Your Enabling Technology

So, what’s your best game plan for the coming years? McKinsey specifically mentions these best-in-class organizations have finance teams that “utilize innovative performance management tools to help determine how the business is actually performing and suggest steps to optimize results.” At Revelwood we’ve been consulting on and delivering solutions for financial and operational performance management for 25 years. One would think most mid-sized businesses have moved off of spreadsheets for their budgeting, planning and reporting activities. But, day-after-day, our team here speaks with not just new upstarts, but established, even large, publicly traded companies that rely on spreadsheets as the backbone of their core activities in the Office of Finance. Spreadsheets have a role in the Office of Finance and always will. But any organization that uses only spreadsheets simply can’t achieve true resiliency. And they can’t embrace agility.

Your Game Plan: Think Differently About the Office of Finance

How can you unlock the potential hidden within your finance team to add true value to the business? Think differently about how to enhance your team members’ roles. Maybe it’s even a matter of breaking up some aspects of the physical office and having finance team members sit among their associated business units. Separate their function from their strategic role. Be agile about how you think about your people and what they can do for the business.

The End Game: Resilience and Agility

As I mentioned, we think the victors of the next decade will strike a good balance between resilience and agility. Or, offense and defense. Invest in the right enabling technology, rethink the role of the Finance team, and build the skillsets and mindsets for both. That’s your best game plan.

Home » Adaptive Insights » Page 4

Filed Under: FP&A Done Right Tagged With: Adaptive Insights, agile planning, Analytics, business agility, business resilience, continuous planning, Financial Performance Management, FP&A, FP&A done right, IBM Planning Analytics, ken wolf, Rolling Forecasts, TM1

  • « Go to Previous Page
  • Page 1
  • Page 2
  • Page 3
  • Page 4
  • Page 5
  • Page 6
  • Go to Next Page »

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

World Headquarters

Florham Park, NJ | 201 984 3030

European Headquarters

London & Edinburgh | +44 (0)131 240 3866

Latin America Office

Miami, FL | 201 987 4198

Email
info@revelwood.com

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