• 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

Revelwood

IBM Planning Analytics Tips & Tricks: Comparing Sandboxes

July 14, 2020 by Lee Lazarow Leave a Comment

Tips & Tricks

Many of you know that you can create personal what-if scenarios in IBM Planning Analytics via the sandbox feature. This approach allows you quickly replicate an entire environment which includes all of the data, rules, input templates, and reports from your existing models. But did you know that you can also easily compare data from the various sandboxes? This is done by creating a virtual dimension that contains your sandbox elements.

Creating the virtual dimension is as simple as adding a setting into your Planning Analytics configuration called EnableSandboxDimension and setting the value to true. By default, this parameter is set to false. This is a dynamic parameter, so a server restart is not required to enable this setting.

Once enabled, your cube will now show a new dimension called “Sandboxes.”

IBM Planning Analytics Tips & Tricks: Comparing Sandboxes

You can add this dimension to your PAW books as a selector widget. Once added, you can synchronize your views and reports to the sandbox selector.

Comparing sandboxes in IBM Planning Analytics

This approach offers an easy way to check your data before submitting a sandbox entry back into the base model.

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: 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: Using Words and Numbers Together

Home » Revelwood » Page 4

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

Technical Bulletin: Earlier Security Change Impacting MDX Reverted

July 10, 2020 by Lee Lazarow Leave a Comment

Tech Bulletins

IBM is undoing a recent security change in the next release of IBM Planning Analytics.

In late June we issued a technical bulletin about version 2.0.9 of Planning Analytics that changed the way MDX expressions are generated for dimensions that have security defined.

IBM received feedback from Planning Analytics customers and recognizes this change has broader implications than originally expected. As a result, IBM is going to undo the change impacting MDX expressions in the next release of Planning Analytics.

Version 2.0.9.2 of Planning Analytics will revert changes in the way MDX expressions are generated for dimensions that have security defined. This version of Planning Analytics is expected to be released by the end of July 2020. [Update: this version of Planning Analytics was released on July 27, 2020.]

Recommended Next Steps for Planning Analytics Users

If you recently upgraded your local environment to version 2.0.9 or 2.0.9.1 and have experienced a negative impact on your model, Revelwood recommends upgrading to version 2.0.9.2 as soon as it is available.

If you are using Planning Analytics on the cloud, your system will be updated automatically and there are no further steps you need to take.

If you are unsure about how the change impacted your model, you can run a test on your model. Revelwood has created a TurboIntegrator script that will help you assess potential conflicts by analyzing combinations of element security and dynamic subsets. You can download the script for free at https://revelwood.com/ti-processes/. You do not need to be an existing Revelwood customer to download this script.

Please contact John Pra Sisto at jprasisto@revelwood.com if you have any questions regarding this bulletin or the TurboIntegrator script.

Home » Revelwood » Page 4

Filed Under: Tech Bulletins Tagged With: IBM Cognos TM1, IBM Planning Analytics, lee lazarow, Revelwood, TM1

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

July 7, 2020 by Lee Lazarow Leave a Comment

Tips & Tricks

In an earlier post, I showed how to merge a button onto an image in IBM Planning Analytics to create an easy-to-navigate user experience. However, as a developer I may forget which images are just images and which images contain buttons.

To get around this, I sometimes add small reminders to my images to let me know there are two things merged into a single image. In the previous post, I recommended changing the text to a blank value. This result gives you the house image below.

Merging icons and buttons in IBM Planning Analytics

However, if you change the text into something small (such as a period) then you can easily make it fit into part of the image.

Merging icons and buttons in Planning Analytics Workspace

To the end user, the house now looks like it has a door. But as a developer, I now know that there are two components … an image and a button.

Hiding “dots” in your image is an easy way for you to remember the components in your PAW pages.

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: Merge an Icon and a Button, Part 1

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

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

Home » Revelwood » Page 4

Filed Under: IBM Planning Analytics Tips & Tricks Tagged With: Analytics, Budgeting, Budgeting Planning & Forecasting, Financial Performance Management, IBM Cognos TM1, IBM Planning Analytics, IBM Planning Analytics Workspace, Planning Analytics tips, 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 » Revelwood » Page 4

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

IBM Planning Analytics Tips & Tricks: Excel’s FILTER Function

June 23, 2020 by Lee Lazarow Leave a Comment

Tips & Tricks

Have you ever wanted to filter a list of data to look at a subset of the entire table? Many of you know that you can use the filter button within Excel’s data section to do this.

IBM Planning Analytics Tips & Tricks: The Excel FILTER Function

But what if you wanted to create a filter that users can change without having to navigate through ribbons? Did you know that you can do this using Excel’s FILTER function?

The FILTER function allows you to filter a range of data based on criteria you define. This allows you to create selector cells which can be used within a formula to filter the selected data. The function is written as follows:

FILTER (range, formula for inclusion, if empty)

  • The range consists of the entire table to be checked
  • The formula for inclusion consists of criteria to be filtered
  • The last parameter (optional) defines a value to be returned when no results are found

The example below shows a table on the left, an input cell, and the FILTER command in cell F5. In this case, the function is being used to look at the entire table (cells B3 through D11) and checking to see if the value in column B is the same as the value in cell G2.

Learn about Excel's FILTER Function

The formula for inclusion can use more complex approaches to check multiple values. This is done by using the multiplication operator as the “and” statement. The example below expands upon the first example by allowing the user to independently select both a state and a city.

IBM Planning Analytics Tips: Excel's FILTER Function

This functionality allows you to replicate Planning Analytics selector concepts into an existing spreadsheet.

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: The Excel FORMULATEXT Function

IBM Planning Analytics Tips & Tricks: Learn the Excel CELL Formula

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

Home » Revelwood » Page 4

Filed Under: IBM Planning Analytics Tips & Tricks Tagged With: Analytics, Excel, Excel tips & tricks, Financial Performance Management, IBM Cognos TM1, IBM Planning Analytics, Revelwood, TM1

IBM Planning Analytics Tips & Tricks: The Excel FORMULATEXT Function

June 16, 2020 by Lee Lazarow Leave a Comment

Tips & Tricks

Have you ever looked at a value on a report and wanted to know the formula that was used, even though you may not have access to the report? Have you ever wanted to easily include a formula as part of the report? Have you ever wanted to show people how complicated your calculation was as an attempt to get them to better appreciate you?

Well, all of this can be done in Excel with the use of a simple formula: FORMULATEXT.

The FORMULATEXT function is used to return a formula as a string. The single parameter of the function is the cell to be converted to text.

The following example shows the use of the formula in cell C6.

IBM Planning Analytics Tips & Tricks: The Excel FORMULATEXT Function

Not only can you now show your co-workers how complicated your nested-if formulas have become, but you can also end those recurring nightmares about your middle school math teachers who always said “show me your work” (ok, maybe that’s just me).

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: The Excel DATE Function

IBM Planning Analytics Tips & Tricks: New Excel Feature – XLOOKUP

IBM Planning Analytics Tips & Tricks: Excel’s IFS Function

Home » Revelwood » Page 4

Filed Under: IBM Planning Analytics Tips & Tricks Tagged With: Analytics, Excel, Excel tips & tricks, Financial Performance Management, IBM Cognos TM1, IBM Planning Analytics, Revelwood, TM1

IBM Planning Analytics Tips & Tricks: The Excel DATE Function

June 9, 2020 by Lee Lazarow Leave a Comment

Tips & Tricks

Many of you already know about Excel’s DATE function.  The function is used to create a date by defining specific values for the year, month and day.

DATE(2020,7,20) gives a result of 7/20/2020.

And some of you know that you can also use formulas to calculate a date.

If a value of 5 exists in cell C4 then

DATE(2020,7,20+C4) gives a result of 7/25/2020.

But did you know that the formula will also check for valid dates and, if needed, shift the month automatically?

DATE(2020,7,35) gives a result of 8/4/2020

(since there are not 35 days in July!)

and

DATE(2020,7,30+C4) gives the same result

Not only can this formula be used to calculate variable dates, but it will also ensure that you don’t incorrectly calculate a value that doesn’t exist on the calendar.  After all, we wouldn’t want Julius Caesar coming back to question our use of “his” month!

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: Map Charts

IBM Planning Analytics Tips & Tricks: Sparklines

IBM Planning Analytics: Learn the Excel CELL Formula

Home » Revelwood » Page 4

Filed Under: IBM Planning Analytics Tips & Tricks Tagged With: Excel, Excel tips & tricks, Financial Performance Management, IBM Cognos TM1, IBM Planning Analytics, 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 » Revelwood » Page 4

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

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

May 22, 2020 by Revelwood Leave a Comment

FP&A Done Right

This is a guest blog post from our partner Adaptive Insights, written by Bob Hansen. It is part of a series of blogs from Adaptive Insights designed to help customers weather the storm brought by the COVID-19 pandemic.

With the COVID-19 pandemic shredding budget forecasts and presenting FP&A professionals with actuals that are nowhere close to original expectations, now is the perfect time to get acquainted with a certain term: “Flexible budget variance.”

Sure, flexible budget variance might sound wonky. But now more than ever, it’s an essential tool for modern FP&A teams. Here’s why.

Flexible budgeting not only helps you stay current with the challenges and opportunities that surface throughout the year, but it can be a lifeline when your business is rocked by revenue shocks, drops in demand, workforce shifts, and whatever else a global event can toss your way. By updating budgets to reflect those changes, you can quickly course correct to improve efficiency or enhance performance.

What is a flexible budget variance?

Flexible budget variances are the differences between line items on actual financial statements and those that are on flexible budgets. Since the actual activity level is not available before the accounting period closes, flexible budgets can only be prepared at the end of the period. At that point, flexible budget variances can be useful in identifying any shortcomings or deviations in actual performance during a given period.

Though powerful anytime, you can imagine how useful this capability would be now, with so much disruption to normal course of business activity. And it’s a safe bet that business planning and budgeting overall will be subject to rapid and ongoing course correction for months to come.

Flexible budget variance is also beneficial during the planning stage at the beginning of the accounting period. By adjusting project budgets to a series of possible activity levels, Finance creates data that helps anticipate the impact of changes in activity levels on revenues and costs. This helps you make more informed decisions if (or when) adjustments are needed.

Taking a flexible approach to budgeting typically doesn’t mean you get a free pass when it comes to more traditional, static budgeting. In fact, the static budget is essential for establishing a baseline to measure performance and results and ultimately for calculating the variances that do occur throughout the year.

Save time by using the tools you have

The task of calculating, analyzing, and then clearly communicating budget variances and their implications can be a time-consuming task under any circumstances, and particularly stressful in times of disruption. But certain capabilities in Workday Adaptive Planning make it easier.

For instance, Workday Adaptive Planning’s data visualization software can speed much of that process. And when conditions change quickly, speed is a distinct advantage.

Even so, it’s important to keep in mind that not all line items in a budget can be flexible. For example, your company has many expenses that are likely fixed for the entire year, such as rent or contractual obligations.

Yet other expenses have considerable chance of varying to one degree or another. For instance, staffing projections may be dependent on an expected long-term contract being finalized, or economic stresses cause you to extend payment deadlines or loosen return policies. No matter what, flexibility serves you at the moment you need it—and pays dividends down the line.

Gain meaningful insights

Meanwhile, flexible budget variance analysis offers the ability to derive meaningful insights throughout the year, allowing for improved planning and budgeting for the future. The power and potential of flexible budgets are further fueled by technology platforms such as those offered by Workday that provide drill-down capabilities so you can quickly identify and analyze variances.

You can also use Workday Adaptive Planning to create a variance report that highlights the changes in dashboards, offering a range of visual options for presenting the numbers within highly accessible context.

And by relying on more timely and relevant budget numbers, you can use flexible budgets to provide senior executives and line of business managers with dynamic guidance on spending, investments, or where cost controls might be necessary based on the situation your business faces as days, weeks, and months progress.

You’ll get through this chaos by leveraging the benefits of flexible budget variance capabilities within Workday Adaptive Planning, you even might get through it in a stronger position than your competitors.

This blog post was originally published by Adaptive Insights.

Read more FP&A Done Right posts:

FP&A Done Right: The Office of Finance in the COVID-19 Economy

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

FP&A Done Right: A Future Without Spreadsheets?

Home » Revelwood » Page 4

Filed Under: FP&A Done Right Tagged With: actuals, Adaptive Insights, Analytics, Budgeting, Budgeting Planning & Forecasting, data visualization, Financial Performance Management, flexible budget variance, FP&A, FP&A done right, Revelwood, Workday Adaptive Planning

  • « Go to Previous Page
  • Page 1
  • Page 2
  • Page 3
  • Page 4
  • Page 5
  • Page 6
  • Interim pages omitted …
  • Page 8
  • 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.