• 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: Edit Action Button

July 21, 2020 by Revelwood 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 » Revelwood » Page 4

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

  • « 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.