• 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

Planning & Forecasting

FP&A Done Right: FP&A Tips for Scenario Modeling During COVID-19

July 24, 2020 by Revelwood Leave a Comment

FP&A Done Right

This is a guest blog post from our partner Adaptive Insights, written by Steve Dunne. It is a unique Q&A with Kinnari Desai, Workday’s senior director of corporate finance, on how Workday responded to the FP&A impact of COVID-19.

Kinnari Desai, Workday’s senior director of corporate finance, has deep insight into scenario modeling and how Workday approached this following the outbreak of COVID-19. We spoke with her to get more best practices and tips for financial planning and analysis (FP&A) teams.

How did Workday have to adapt its business planning process following the start of the crisis?

We were coming off the back of our annual planning cycle and thanking our teams for their efforts in delivering “Plan A.” Then of course, everything changed with COVID-19. We had to spring right back into action, modelling scenarios in an environment that was so new—and seemingly changing hour by hour.

I believe that in an uncertain environment like this, it’s very important the FP&A team aligns with the leadership team, understands the context of what’s happening, and looks at a small number of relevant scenarios. It can be easy to get carried away producing several scenarios, but the goal is to provide the leadership with a range of likely outcomes and provide data, in a simple way, that would enable decision making.

In these situations, I’d imagine speed is of the essence, but you have to get it right if scenario modeling data is going to be valuable to your business leadership?

I do think it’s important to execute quickly, but in order to achieve our objectives, we had to be thoughtful in our approach.

As a business, you have to agree on your priorities. Are you going to focus on top-line growth, cash, the impact of employee relief programs, hiring pauses, and so on? Then you should consider the impact of those on the P&L and cash flow.

The next big thing is getting input from the business. While we are always in lock-step with our business partners since we can’t model in a vacuum, it’s more important than ever to meet with the operational business leaders, gather their perspectives, and understand what’s top-of-mind for them. You should be meeting with leaders multiple times to quickly narrow down focus areas that are a priority for them, such as support for employees, availability of equipment, and hiring direction.

From there, how do you start thinking about how you’ll use scenario modeling to drive decision making and elements such as forecasting?

In our case we had to adapt our scenario modeling frequency to help us make decisions faster. This impacts things like forecasting —we could no longer rely entirely on a monthly forecast process, so we adjusted the process slightly. This has led our FP&A team to a more continuous approach to planning, versus point-in-time or quarterly updates.

There are areas like revenue and cash that we are visiting on a weekly or even a daily basis. Then there are other areas that we may not review daily, but look at more frequently than before. We also discussed as a team that at times, the level of guidance we can give to other internal teams may not be as detailed or defined as it has historically been, since the situation is constantly evolving. As a result, we all need to remain agile.

Last but not least, we also identified drivers of large spend, and cost levers that can be pulled should the need arise.

Technology obviously plays a key part in enabling scenario modeling. Can you tell us a bit about how you used Workday Adaptive Planning to drive the whole process?

Part of our job is to provide a sense of calm amidst chaos, and the Workday tools and data model enabled us to do just that. We spun up different versions in Workday Adaptive Planning, and adjusted the drivers like new business and renewal rates for revenue. For expenses, for example, we tweaked the timing of hiring, and the related impact on other expenses like benefits and employee relations costs were updated right away since they are based on timing of hire.

We were able to leverage actuals data from Workday Financial Management into our forecasts. This enabled us to see the resulting impact on the P&L and cash flow right away. All in all, we were able to speed up the process and operate 50% faster versus using spreadsheets. And the ability to use one data model and driver-based forecasting was very valuable.

What is the magic number when it comes to scenario modeling?

We modeled three different scenarios, and I think that’s a good number to work with during a fluid situation like this. I strongly recommend for my friends and colleagues in FP&A that they don’t drive themselves crazy doing 15 different scenarios! We don’t know everything yet, and spinning up more scenarios isn’t necessarily going to provide the answers.

We aligned on three possibilities and reasoned why these are important. This allowed us to focus on what matters, keeping it manageable so important decisions can be made without data overload.

What would your advice be to other FP&A professionals looking at ways to improve their business planning models today?

I’d start with “over-communicate.” I really can’t emphasize enough the importance of communication. We’ve moved to a remote, digital world, so hallway conversations are no longer a possibility. We needed to ensure emails are not misinterpreted, so we checked in via Slack or had quick Zoom calls. We provided financial guidelines on how to operate in the near term and why these are key.

For publishing updated forecasts to finance, accounting, and lines of business, we heavily leveraged our management reporting capability in Workday. Keeping these stakeholders informed on the approach and current thinking, even when all decisions have not been made yet, goes a long way.

Educate the business as well as accounting. In a changing environment, accounting also needs to be informed of the latest plan so they know what to expect (actuals) relative to the plan. This helps them as they prepare for and move through a remote close —with confidence and in concert with FP&A. The business will also need guidance to understand the latest plan and take action accordingly. Keep an eye on the fundamentals of the business, and take this as an opportunity to rethink some of the processes and outputs.

And lastly, remain agile. As the market continues to shift, we will need to remain flexible so that we can continue to pivot as needed. This is not a one-time shift in light of COVID-19, but a new and more agile way of operating that will allow finance to continuously adapt to change.

This blog post was originally published by Adaptive Insights and appeared here.

Read more guest posts from Adaptive Insights:

FP&A Done Right: 3 Words for a COVID-19 World –“Flexible Budget Variance”

FP&A Done Right: What FP&A Must Do Differently to Make Planning a Success

FP&A Done Right: Modernize your Budget Process to Anticipate Change

Home » Planning & Forecasting » Page 10

Filed Under: FP&A Done Right Tagged With: Adaptive Insights, Analytics, Budgeting, Budgeting Planning & Forecasting, cloud financial performance management, COVID-19, Financial Performance Management, Planning & Forecasting, Planning & Reporting, scenario modeling, Workday, Workday Adaptive Planning

IBM Planning Analytics Tips & Tricks: Edit Action Button

July 21, 2020 by Thanh Chau Leave a Comment

Tips & Tricks

Action buttons in IBM Planning Analytics are a great utility that allow users to recalculate a sheet, navigate to another location, or run a TurboIntegrator process. As your models evolve, you may need to periodically revise your templates to maintain their functionality. This sometimes include the action buttons.

In Perspectives, updating an action button was as simple as right-clicking on it and selecting the Properties option. In Planning Analytics, the approach is a little different.

From the task pane, click on the tab labeled “Workbook.”

IBM Planning Analytics Tips & Tricks: Edit Action Button

This section will show you all the different Planning Analytics objects that exist in your workbook.  Expand the folder labeled “Action buttons.”

Edit action buttons in IBM Planning Analytics

The name of each action button will be prefixed with the sheet name in which it is located.  Find the action button that you’d like to edit, right-click it and select the “Edit” option.

Learn how to edit action buttons in Planning Analytics

This will open the properties window where you can make changes to the action button.

How to edit action button in IBM Planning Analytics

This approach will allow you to quickly edit all of your action buttons at the same time instead of having to navigate through your workbook and search for each button.

IBM Planning Analytics, which TM1 is the engine for, is full of new features and functionality. Not sure where to start? Our team here at Revelwood can help. Contact us for more information at info@revelwood.com. And stay tuned for more Planning Analytics Tips & Tricks weekly in our Knowledge Center and in upcoming newsletters! You can also sign up to get our Planning Analytics Tips & Tricks sent directly to your inbox!

Read more IBM Planning Analytics Tips & Tricks:

IBM Planning Analytics Tips & Tricks: Merge an Icon and a Button, Part 1

IBM Planning Analytics Tips & Tricks: Merge an Icon and a Button, Part 2

IBM Planning Analytics Tips & Tricks: Creating Buttons in IBM Planning Analytics Workspace (PAW)

Home » Planning & Forecasting » Page 10

Filed Under: IBM Planning Analytics Tips & Tricks Tagged With: Analytics, Budgeting Planning & Forecasting, Financial Performance Management, IBM Cognos TM1, IBM Planning Analytics, Planning & Forecasting, Planning & Reporting, Planning Analytics Tips & Tricks, Revelwood, TM1

IBM Planning Analytics Tips & Tricks: Merge an Icon and a Button, Part 1

June 30, 2020 by Lee Lazarow Leave a Comment

Tips & Tricks

User experience is an important factor when designing any system. One of the most important aspects of the experience is the ease in which users can navigate from one page to another.

In situations where an IBM Planning Analytics Workspace (PAW) book has multiple sheets, the navigation is as easy as clicking on the applicable sheet at the top of the page (just like you would do in Excel). However, in situations where there are multiple books, the navigation may require the use of a button.

Buttons are easy to create via the icon at the top of the screen.

IBM Planning Analytics Tips & Tricks: Merge Icon and Button Invisible

The resulting button appears as a rectangle and can be formatted to change things such as the text, the color and the border.

Merge an icon in IBM Planning Analytics

But did you know that you can make your own button by merging an image with a button? For example, maybe you want a “home” button that looks like a house. You can do this by using an image from the shapes icon and formatting it to your desired color and size.

Learn how to merge an icon and a button in IBM Planning Analytics

You can then drag a button on top of the image.

IBM Planning Analytics: Learn how to merge an icon and a button

By changing the text to a blank value, the button becomes “invisible.” Users will then be able to click on the house to navigate back to the home page.

This approach offers an easy way to create an good user experience for navigation throughout your PAW books.

IBM Planning Analytics, which TM1 is the engine for, is full of new features and functionality. Not sure where to start? Our team here at Revelwood can help. Contact us for more information at info@revelwood.com. And stay tuned for more Planning Analytics Tips & Tricks weekly in our Knowledge Center and in upcoming newsletters!

Read more IBM Planning Analytics Tips & Tricks:

IBM Planning Analytics Tips & Tricks: Create New Books with the Diamond Icon

IBM Planning Analytics Tips & Tricks: Using Words and Numbers Together

IBM Planning Analytics Tips & Tricks: The Data Load Process

Home » Planning & Forecasting » Page 10

Filed Under: IBM Planning Analytics Tips & Tricks Tagged With: Analytics, Budgeting, Budgeting Planning & Forecasting, Financial Performance Management, IBM Cognos TM1, IBM PAW, IBM Planning Analytics, IBM Planning Analytics Workspace, Planning & Forecasting, Planning & Reporting, Revelwood, TM1

FP&A Done Right: What Must FP&A Do Differently to Make Planning a Success

June 5, 2020 by Revelwood Leave a Comment

FP&A Done Right

This is a guest blog post from our partner Adaptive Insights, written by Anders Liu-Lindberg. Lui-Lindberg explains why FP&A can no longer take a narrow view of its own role.

FP&A is obviously concerned with financials; however FP&A can no longer take a narrow view of its own role. FP&A must go way beyond the financials to where the business happens to succeed in making planning a success!

We discussed in my previous post the notion of active planning and made it concrete using a specific example. Now we’ll take it one step further and discuss how you can only realize active planning if you integrate your planning process with business operations.

In the end we’ll tie it all together by explaining how you can now build a driver-based planning process that ties your strategic intent together with your daily execution. I know that’s a stretch to most FP&A professionals, but with active planning it doesn’t make sense any other way than to make your planning driver-based.

External factor to business drivers to financial drivers

I think we can all agree that business doesn’t start with financials. In fact, it ends with financials, when every transaction eventually gets recorded through debit/credit. So how could we ever start our planning process with the financials or think that by extrapolating current financials with a growth factor or similar that we would get a decent picture of what will happen in the future? No, we must flip our thoughts on planning around. Here’s how:

  • We must look at the external factors that impact our business and are documented as critical assumptions as part of our strategy
  • Next, we must look at the key business drivers that determine if we’re successful or not
  • Only then do we start to look at the financials, because they’re the most lagging indicator we have

In short, external factors are leading indicators to business drivers, which in turn are leading indicators to financial drivers. Now it’s important that you only select the most critical ones, say six to eight in each category, because otherwise you’ll have a hard time describing how each factor/driver impacts the other. You’ll also have a hard time producing any meaningful monitoring system or planning process.

It’s clear that the more variables you can add to the equation the more precise you’ll likely be; however, to exercise active planning, an 80/20 approach is much better than thinking you need 99% accuracy in everything you do.

Almost real-time driver-based planning

Now let’s connect the dots. You’ve defined six to eight drivers at each level of external, business, and financial. You should now connect these drivers so you have an idea about how a change in one will change the other. You might need to use some machine learning to build a proper model, but once it’s built, you just need to link the financial drivers to your P&L, balance sheet, and cash flow (depending on how much detail you want to plan for).

Now this is real active driver-based planning that essentially gives you an updated view on your business whenever something happens in your critical assumptions that are tied to your strategy. I can imagine an alarm bell going off in every CXO’s office every time any of the drivers moves outside the comfort zone. Luckily for the CFO though, sharing the financial impact of not acting is no longer a headache.

How does this compare to your own vision for creating an active planning process? Have you already started some sort of driver-based planning? How connected is it among the three levels? Now is the time to get this done so we can start to focus on making the right decisions given the change in assumptions. Are you on board with the needed change?

Anders Liu-Lindberg is a senior finance business partner at Maersk and the co-founder of the Business Partnering Institute. He is also the co-author of the book Create Value as a Finance Business Partner and a longtime finance blogger with more than 33,000 followers.

This blog post was originally published by Adaptive Insights.

Read more guest posts from our partner, Adaptive Insights:

FP&A Done Right: Are you Dying by the Hands of Analysis?

FP&A Done Right: The Importance of Including FP&A Early and Often in your Strategic Planning Process

FP&A Done Right: Modernize your Budget Process to Anticipate Change

Home » Planning & Forecasting » Page 10

Filed Under: FP&A Done Right Tagged With: Adaptive Insights, Analytics, driver-based planning, Financial Performance Management, FP&A, FP&A done right, Planning & Forecasting, Revelwood

IBM Planning Analytics Tips & Tricks: Using Words and Numbers Together

June 2, 2020 by Lee Lazarow Leave a Comment

Tips & Tricks

In an IBM Planning Analytics Tips & Tricks video, I demonstrated the concept of using words to manipulate your views. This approach also applies to entering data.  All of you know that you can enter data by typing a number into a writeable cell.

IBM Planning Analytics Tips & Tricks: Using Words and Numbers

Some of you know that you can use commands such as “2k” to enter a value that will be converted into a number.

IBM Planning Analytics Tips: Using Words and Numbers

And some of you also know that you can type commands such as “grow10” on an existing number to populate the rest of the year.

IBM Planning Analytics Tricks: Using Words and Numbers

But did you know that you can merge all of this together into a single entry? For example, if I type “5kgrow20” in January then 5,000 will be input into January and a 20 percent growth rate will apply to each of the other months.

Using words and numbers in IBM Planning Analytics

The combination of numbers and phrases in a single cell will help you quickly and easily create plans for multiple time periods.

IBM Planning Analytics, which TM1 is the engine for, is full of new features and functionality. Not sure where to start? Our team here at Revelwood can help. Contact us for more information at info@revelwood.com. And stay tuned for more Planning Analytics Tips & Tricks weekly in our Knowledge Center and in upcoming newsletters! You can also sign up to get our Planning Analytics Tips & Tricks sent directly to your inbox!

Read more IBM Planning Analytics Tips & Tricks:

IBM Planning Analytics Tips & Tricks: Using Words Instead of Numbers

IBM Planning Analytics Tips & Tricks: Create New Books with the Diamond Icon

IBM Planning Analytics Tips & Tricks: Admin Server Recycle

Home » Planning & Forecasting » Page 10

Filed Under: IBM Planning Analytics Tips & Tricks Tagged With: Analytics, Budgeting, Budgeting Planning & Forecasting, Financial Performance Management, IBM Cognos TM1, IBM Planning Analytics, Planning & Forecasting, Planning & Reporting, TM1

IBM Planning Analytics Tips & Tricks: New Excel Feature – Map Charts

May 5, 2020 by Dillon Rossman Leave a Comment

Tips & Tricks

One of the new features in Excel is the ability to create Map Charts to compare values and show categories across geographical regions.

If you have your own set of data to use skip to step 3. Otherwise, we can accomplish this in a few easy steps using one of Excel’s preset geographical data types:

  1. Once you have your list of geographical values, navigate to the Data Tab > Data Types > Geography.IBM Planning Analytics Tips & Tricks:New Excel Feature - Map Charts
  2. An option to insert data will appear. This will offer several preset options that will be automatically populated once selected.IBM Planning Analytics Tips: New Excel Feature - Map Charts
  3. Now that data is populated the Map Chart can be created. Highlight your table, navigate to the Insert Tab > Charts > Maps > Filled Map. A Map Chart will now be createdIBM Planning Analytics Tricks: New Excel Feature - Map Charts

This is a nifty feature in Excel that will help visualize your data. Remember, this feature is already built-in to Planning Analytics Workspace! Learn more about this in our earlier blog post on displaying data in maps.

IBM Planning Analytics, which TM1 is the engine for, is full of new features and functionality. Not sure where to start? Our team here at Revelwood can help. Contact us for more information at info@revelwood.com. And stay tuned for more Planning Analytics Tips & Tricks weekly in our Knowledge Center and in upcoming newsletters!

Read more IBM Planning Analytics Tips & Tricks:

IBM Planning Analytics Tips & Tricks: Sparklines

IBM Planning Analytics Tips & Tricks: Visualizing Data in Pie Charts

IBM Planning Analytics Tips & Tricks: Creating a Simple Dashboard in Planning Analytics Workspace

Home » Planning & Forecasting » Page 10

Filed Under: IBM Planning Analytics Tips & Tricks Tagged With: Analytics, Budgeting Planning & Forecasting, Financial Performance Management, IBM Cognos TM1, IBM Planning Analytics, Planning & Forecasting, Revelwood, TM1

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 » Planning & Forecasting » Page 10

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

IBM Planning Analytics Tips & Tricks: Sparklines

April 28, 2020 by Dillon Rossman Leave a Comment

Tips & Tricks

Are you familiar with Sparklines, a rarely used feature in Excel?

What happens when you’d like to provide a visual representation of data but don’t necessarily want, or have the space, for a big chart? Sparklines may be a viable solution.

To add a Sparkline for data, follow these steps:

  1. Once you have your data, navigate to the Insert Tab > Sparklines. In this scenario a Line Sparkline will be used but there are also options for Column and Win-Loss Sparklines.IBM Planning Analytics Tips & Tricks: Sparklines
  2. Once selected, a dialogue box will show two fields:
    1. A. Data Range – Data that will appear in the Sparkline
    2. B. Location Range – Where the Sparkline will be placed
      Learn how to use Sparklines in IBM Planning Analytics
  3. After filling out the necessary fields, a Sparkline will be created, and the Sparkline Tab will appear. This provides several options to change the appearance of a Sparkline.sparklines in IBM planning analytics

Implementing Sparklines is a very easy and effective way to visualize data without the need for charts.

IBM Planning Analytics, which TM1 is the engine for, is full of new features and functionality. Not sure where to start? Our team here at Revelwood can help. Contact us for more information at info@revelwood.com. And stay tuned for more Planning Analytics Tips & Tricks weekly in our Knowledge Center and in upcoming newsletters! You can also sign up to get our Planning Analytics Tips & Tricks sent directly to your inbox!

Read more IBM Planning Analytics Tips & Tricks:

IBM Planning Analytics Tips & Tricks: New Configuration Setting for Dates

IBM Planning Analytics Tips & Tricks: New Parameters for TurboIntegrator

IBM Planning Analytics Tips & Tricks: The New Set Editor

Home » Planning & Forecasting » Page 10

Filed Under: IBM Planning Analytics Tips & Tricks Tagged With: Analytics, Budgeting, Budgeting Planning & Forecasting, Financial Performance Management, IBM Cognos TM1, IBM Planning Analytics, Planning & Forecasting, Planning & Reporting, Planning Analytics Tips & Tricks, TM1

IBM Planning Analytics Tips & Tricks: Bulk Load Template for Cubes with Indices

April 21, 2020 by Thanh Chau Leave a Comment

Tips & Tricks

Do you have cubes in your IBM Planning Analytics (PA) model that allow for planning with line item detail? The struggle you may come across in creating a template in Excel that automatically loads to the next available line is that such a template will either not allow you to load in bulk or requires you to load to only one center or account combination at a time. Using PA’s Quick Report, you can create an input template that solves both obstacles.

In implementing a Quick Report load template solution, you must include a Count measure in your cube to track which indices are currently used.

IBM Planning Analytics Tips & Tricks: Bulk Load Templates for Cubes with Indices

Create your Quick Report so that the Index dimension and other dimensions that constitute a unique index row are in the rows and the other dimensions are in the columns. In the example below, every new item entered for a center will require its own index row. The Measure, Version, and Time dimensions are in the columns.

IBM Planning Analytics Tips: How to Bulk Load Cubes with Indices

In the first row, hard-code a dummy line that will not be included in reporting or will not receive any inputs. The reason for this is that a Quick Report always needs at least one data row to maintain the connection to the cube. You can format this row and change the row height to have it appear as a thick border to your users.

IBM Planning Analytics Tricks: Bulk Load Templates for Cubes with Indices

Lastly, for every row that you’d like to be a part of the load area, populate the Index column with a formula that will determine the next row number by pulling the Count measure of “Total Index” for the center, adding the number of times the center appears in the rows above the current row, and add one to increment to the next index.

You can hide the Index column as this column will no longer be controlled by the user.

IBM Planning Analytics, which TM1 is the engine for, is full of new features and functionality. Not sure where to start? Our team here at Revelwood can help. Contact us for more information at info@revelwood.com. And stay tuned for more Planning Analytics Tips & Tricks weekly in our Knowledge Center and in upcoming newsletters! You can also sign up to get our Planning Analytics Tips & Tricks sent directly to your inbox!

Read more IBM Planning Analytics Tips & Tricks:

IBM Planning Analytics Tips & Tricks: Clearing all Data from a Cube

IBM Planning Analytics Tips & Tricks: Cellput vs CellIncrement

IBM Planning Analytics Tips & Tricks: When to Build Multiple Cubes

Home » Planning & Forecasting » Page 10

Filed Under: IBM Planning Analytics Tips & Tricks Tagged With: Analytics, Budgeting, Budgeting Planning & Forecasting, Financial Performance Management, IBM Cognos TM1, IBM Planning Analytics, Planning & Forecasting, Planning & Reporting, TM1

  • « Go to Previous Page
  • Page 1
  • Interim pages omitted …
  • Page 8
  • Page 9
  • Page 10
  • Page 11
  • Page 12
  • Interim pages omitted …
  • Page 17
  • 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.