• 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: Finance as the Conductor

February 8, 2019 by Brian Combs Leave a Comment

FP&A Done Right

Music has been a large part of my life for many years now. I have played drums and percussion in multiple bands, orchestras and jazz ensembles, and I have sung in several choirs and barber shop quartets. The one constant through all of them has been a talented conductor or director at the helm. A band doesn’t simply get together and decide to play a famous concerto. The conductor chooses a piece that speaks to him or her, works with each section of the orchestra on their specific notes and rhythms and ensures that each part fits seamlessly together to make beautiful music. Your Finance department should be no different.

Finance should be at the center of your planning, analysis and reporting processes and solution. You need to direct the process so you can craft and tell your “story.” Picture a hub and spoke model which has Finance in the middle so all roads lead to FP&A. To be clear, every function (Sales, Marketing, IT, HR, Shared Services, Operations) needs to have a seat at the table so you all stay aligned and support the overall story while each group writes its own chapter. You need to make it a priority to reach out to all groups and understand what their needs are and learn how they operate. Ultimately, however, you own the overall three statement reporting (P&L, BS and CF) and you need to make sure that the functions support your story.

FP&A Done Right: Finance as the Conductor

As you become more sophisticated, your journey will take you into the other functions. Follow every number/metric back to its source and work with that group to create a better, more inclusive process.  If you make them part of the process, you will gain their buy-in and ownership. In the past, I have worked in an organization that had Finance Business Partners embedded in each function. Those resources reported directly to FP&A but had a dotted line to the functional leadership. You may not have the luxury of additional headcount so just make sure to create a structure that includes everyone in the process.

As each section (department or function) improves, you will be able to play increasingly more difficult compositions and songs. The end product will be more concise and accurate and your entire organization will be aligned. Good luck and enjoy the music!

Did you miss previous posts on FP&A Done Right? Check them out:

FP&A Done Right: Introduction

FP&A Done Right: You Can’t “System” Your Way out of This

Home » Planning & Forecasting » Page 16

Filed Under: FP&A Done Right Tagged With: Analytics, Budgeting, Budgeting Planning & Forecasting, Financial Performance Management, FP&A, Planning & Forecasting, Planning & Reporting

BPM Partners Predictions for Performance Management in 2019

February 6, 2019 by Lisa Minneci Leave a Comment

News & Events

BPM Partners, a privately held advisory services firm with an exclusive focus on business performance management, recently released “Predictions for Performance Management in 2019.” Among those predictions are two that stand out to us.

Prediction: Many More Companies will be Upgrading from Legacy Systems

BPM Partners writes, “We have seen a recent surge of companies looking to replace their legacy on-premise performance management systems with a more modern version and this will continue to grow.” This is something we are certainly seeing as most TM1 users are upgrading to IBM Planning Analytics over the next few quarters. Much of this is due to support for TM1 10.2.2 ending on September 30, 2019.

As TM1 users upgrade to Planning Analytics, they are taking the time to evaluate their current environments, and assess if they want to remain with an on-premise version, move to the cloud, or select a hybrid environment.

Prediction: Company-wide Planning will Gain Traction

BPM Partners writes, “Integrated business planning has been a goal for many years. Most organizations have fallen short when it comes to achieving this goal because of two issues: difficulty in coordinating major cross-functional initiatives and lack of technology support.

“Who drives and oversees this cross-functional initiative (integrated business planning) and makes sure the company doesn’t end of up a collection of disconnected point solutions? … The consensus seems to be that it is the CFO who should oversee coordinated and connected company-wide planning.”

We’ve long seen performance management solutions such as TM1 be used for both financial and operational planning and analysis. Our partner, Adaptive Insights, offers a range of solutions for integrated planning throughout the enterprise. While we focus on Adaptive Insights for Finance, Adaptive Insights also provides Adaptive Insights for Sales and Adaptive Insights for Workforce Planning.

Regardless of whether a company is upgrading from TM1 to Planning Analytics, or looking to expand planning beyond finance, the picture looks bright. As BPM Partners says, “In 2019, there will be more reasons than ever for those that have remained on the sidelines to get on board with performance management.”

Read additional blog posts discussing industry analyst reports on performance management:

BPM Partners Vendor Landscape Matrix for Financial, Strategic, and Operational Business Performance Management

Home » Planning & Forecasting » Page 16

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

Revelwood’s Top 15 IBM Planning Analytics Tips & Tricks of 2018, Part 1

January 29, 2019 by Lisa Minneci Leave a Comment

Tips & Tricks

Every Tuesday we publish a new IBM Planning Analytics Tips & Tricks blog post. Today’s post is the first in a series of three highlighting our 15 most popular blog posts of 2018.

  1. IBM Planning Analytics Tips & Tricks: The Ranked Report

IBM Planning Analytics for Microsoft Excel (PAx) provides several tools to view, maintain, and report on your Planning Analytics data. Dynamic Reports, one of the PAx reporting tools, allows you to create flexible reports with personalized formatting. An example of this is a ranked report, which will display and sort the top set of rows. Read the full blog post to learn how to insert a TM1RPTFILTER formula into a cell on the Excel worksheet containing the Dynamic Report.

  1. IBM Planning Analytics Tips & Tricks: Asymmetrical Axis in PAx

IBM Planning Analytics for Excel (PAx) gives you the ability to use an asymmetrical approach that allows you to display combinations of elements without the repetition. IBM Cognos TM1 and IBM Planning Analytics gives you the ability to quickly create views of your existing data.  The views are symmetrical, which means that any rows or columns that contain multiple elements will include all possible combinations of the selected elements.  But sometimes you may not want to see all combinations.

Read the full blog post for an example of a symmetrical view that will be converted into an asymmetrical view.  The example will use a Financial GL cube.

  1. IBM Planning Analytics Tips & Tricks: New Parameters for TurboIntegrator

IBM Planning Analytics enables you to create a temporary VIEW or SUBSET TurboIntegrator function. This blog post explains why you may need to, and how to do so. IBM has gone to great lengths to ensure that the transition to Planning Analytics is a seamless process and has added some new functionality to help make your system more efficient.

Two commonly used TurboIntegrator (TI) functions are SUBSETCREATE and VIEWCREATE.  These processes are used to create a new component in your process, but they sometimes can cause an issue.  If you create a new subset or view in the prolog but then have the process fail with the DATA tab then the process will end without removing the new components.  This is most likely because VIEWDESTROY and SUBSETDESTROY are most likely within the Epilog.

There are ways to code around this in the existing version of TM1, but Planning Analytics now offers the ability to create a temporary VIEW or SUBSET as of version 10.2.2 FP4.  This is done by adding a flag at the end of the command.

  1. IBM Planning Analytics Tips & Tricks: Ensuring Cube Logging is Reset in TM1

Did you know you can easily reset cube logging in TM1? A previous tech tip was written to discuss when to enable and disable logging. As stated in that posting, it is best practice to turn cube logging off while processing TurboIntegrator processes. Typically, logging is turned off in the Prolog and turned back on in the Epilog. But if an error occurs when the process is run, it never reaches the Epilog and logging never gets turned back on.

  1. IBM Planning Analytics Tips & Tricks: TM1 Web Write-back Protection

There are several ways to prevent data entry to TM1 in TM1 Web websheets. The first approach can be used for input templates. Use this approach when you want your users to be able to enter data for certain cells/columns, but not others. By default, every cell in an Excel worksheet has the ‘Locked’ property set. This property has no effect on the cell unless the sheet or workbook is protected. In this example, we can select certain cells of an input template to be enterable and certain cells to be locked down or protected. To unlock certain cells in the template, right click the cells and select Format Cells. In the Format Cells dialogue box, select the Protection tab, uncheck the Locked checkbox, and select OK. Read the full blog post to learn the details.

Come back next week to read about the next five most popular blog posts of 2018.

Home » Planning & Forecasting » Page 16

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

FP&A Done Right: You Can’t “System” Your Way Out of This

January 25, 2019 by Brian Combs Leave a Comment

FP&A Done Right

Are you preparing to move from Excel to a new planning and reporting solution? Perhaps you are changing to a new solution or simply upgrading the current one you have. Are you planning to implement your current process in the new system or are you going to take this opportunity to make changes and updates? I can help with that last one!

Avoid the dreaded “lift and shift.” It will always be easier to recreate the same processes, templates, schedules and reports in your new solution but you will be cheating yourself. When we do this, we often place a governor on the new software and we implement processes that make it impossible to get all the benefits from the latest system functionality. Opportunities to change the way we do things do not come up often and you need to take advantage of this while you can.

It’s all about People, Process and Technology. While very important, the Technology component is simply an enabler to support your People and Process. Technology does not create or drive process, you do. Implementing a “best in class” system is not a cure-all. You need “best in class” people following “best in class” processes to get the true benefit from your FP&A solution.

I challenge you to make the time to rethink your processes. If you are anything like I was during my FP&A days, you make constant “quick fixes” to your files so you don’t get burned in the immediate fire. Of course, I always planned on going back to update the file to include those changes. Sound familiar?  (I didn’t go back to make the changes either!) That pile of “fixes” on the corner of my desk continued to grow. Wait until the next person inherits that gem of an Excel file…good luck.

We continue to circumvent the process until the workaround becomes the process. Don’t carry that over to your new solution. Take a holistic look at your processes and decide what to keep, what to throw away, and what to improve. Spending the requisite time upfront to improve your processes will pay back a multi-fold dividend in the future. You can’t system your way out of this.

Read more blog posts about FP&A Done Right:

New Blog Series: FP&A Done Right

Are you Ready for your Finance Transformation?

Home » Planning & Forecasting » Page 16

Filed Under: FP&A Done Right Tagged With: Analytics, Beyond Budgeting, Budgeting, Budgeting Planning & Forecasting, Financial Performance Management, FP&A, Planning & Forecasting, Planning & Reporting

IBM Planning Analytics Tips & Tricks: Navigate Back to the Source

January 22, 2019 by Lee Lazarow Leave a Comment

Tips & Tricks

Have you ever been in a situation where you are looking at an IBM Planning Analytics Workspace (PAW) view and quickly want to go back to that view? Did you know that PAW allows you to quickly navigate back to the source with a single click?

PAW allows you to easily define the database and cube associated with a cube view by pointing to the top, left corner of the view.

IBM Planning Analytics Tips & Tricks: Navigate back to the source

Once the view is selected, you can then click on the corner to go directly to the source cube.

IBM Planning Analytics Tips & Tricks: Navigating back to the source

This approach allows you to quickly navigate through your Planning Analytics environment with a single click.

IBM Planning Analytics 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 blog posts in the IBM Planning Analytics Tips & Tricks Series:

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

IBM Planning Analytics Tips & Tricks: Customizing Planning Analytics Workspace (PAW) Directory Installation on Windows Server 2016

IBM Planning Analytics Tips & Tricks: Hiding Dimensions in Planning Analytics Workspace

Need more help? Learn about our Customer Care options for IBM Planning Analytics & TM1 users. 

Home » Planning & Forecasting » Page 16

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

IBM Planning Analytics Tips & Tricks: The Collect Feature in Planning Analytics Workspace

January 15, 2019 by Lee Lazarow Leave a Comment

Tips & Tricks

Did you know that you can easily copy Planning Analytics Workspace (PAW) components across sheets or books?

PAW allows you to use a feature called “Collect” that serves as the equivalent of copying. You can collect an item by selecting the item and then choosing the Collect option on the shortcut bar.

Learn about the collection feature in Planning Analytics Workspace

This option is available for views, visualizations, selectors, images, videos and other items on your PAW sheets.

Once collected, Planning Analytics will give you quick access to use the item again. You can view the items in your collection by selecting the collection button at the top, right corner of your screen and then choosing the option for Collection.

Understanding the collection feature in Planning Analytics Workspace

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 about Planning Analytics & Planning Analytics Workspace:

IBM Planning Analytics Tips & Tricks: Hiding Dimensions in Planning Analytics Workspace

IBM Planning Analytics Tips & Tricks: Creating Selectors in Planning Analytics Workspace

IBM Planning Analytics Tips & Tricks: Video Demo – Hierarchies in Planning Analytics Workspace

Home » Planning & Forecasting » Page 16

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

New Blog Series: FP&A Done Right

January 11, 2019 by Brian Combs Leave a Comment

News & Events

I am an “FP&A guy.” I love this stuff. I love every part of it – from the last-minute changes to the long range planning sessions and everything in between. Throughout my career, I’ve had the opportunity to be involved in all aspects of global FP&A and want to share some of my insights and tips and tricks with you all. It has certainly not always gone as planned and I have had my share of missteps. At times, I was convinced that we simply swapped the “What Not to Do” page with the “What to Do” page! That of course, is one way to learn and I will definitely share some of those stories with you.

When colleagues or clients ask questions about best practices or want me to give them some advice on their processes, I have been fond of saying, “Well, FP&A done right is…” So, I thought I would pull together a series of blog posts to share with you several ways that you can do FP&A right. This will include stories from my past experiences, tips and tricks that you can use with your FP&A teams, thoughts on how to organize your department, ways to prepare for a new implementation and other miscellaneous topics.  It will focus primarily on People and Process, as I feel those should be the key areas of focus for every FP&A team.

Hopefully, my thoughts will strike a chord with you and you will find something that you can use immediately in your job or it will cause you to take pause and rethink your process to see if there are different actions you could take. As we move through the series, I would love to hear you about how you do FP&A right. What do you think are the keys to success for FP&A? What mistakes have you made that others should avoid?  What tips do you have that we could all learn from? If you have a question or a topic for my next blog, please reach out to me.

Read more about FP&A:

My Mission to Transform FP&A

Why Revelwood is Known as the FP&A Experts

Home » Planning & Forecasting » Page 16

Filed Under: FP&A Done Right Tagged With: Analytics, Beyond Budgeting, Budgeting, Budgeting Planning & Forecasting, Finance done right, Financial Performance Management, FP&A, Planning & Forecasting, Planning & Reporting

IBM Planning Analytics Tips & Tricks: Using Excel to get Client Information

January 8, 2019 by Lee Lazarow Leave a Comment

Tips & Tricks

Did you know that you can now easily define your client version of Planning Analytics via an Excel formula?

There are many ways to determine your version of Planning Analytics. Some of these approaches include reviewing log files, right clicking on executable files, or simply clicking on a Help/About option. Planning Analytics version 2.0.0 introduces an easy approach get your client information via the use of an Excel formula.

The formula TM1INFO can be used to return information about your current TM1 client version.  The syntax of the formula is:

TM1INFO(parameter)

The formula allows for a series of parameters:

clientversion

Returns the full client version number.

clientversionmajor

Returns the major client version number.

clientversionminor

Returns the minor client version number.

clientversionpatch

Returns fix pack and hotfix number.

For example, the formula =TM1INFO(“clientversionmajor”) may give you a result of 11 whereas  =TM1INFO(“clientversion”) would give a more detailed result of 11.0.00200.

This new approach gives you an easy way to monitor your client version and help ensure consistency throughout your organization.

IBM Planning Analytics 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 from the Revelwood team:

IBM Planning Analytics Tips & Tricks: Writing Rules

IBM Planning Analytics Tips & Tricks: Recalculating Excel Worksheets

IBM Planning Analytics Tips & Tricks: Creating Dynamic Sets in the PAx Set Editor

Home » Planning & Forecasting » Page 16

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

IBM Planning Analytics Tips & Tricks: Changes to Eight Planning Analytics Server Configuration Parameters

November 20, 2018 by Revelwood Leave a Comment

Tips & Tricks

This is a guest post from Revelwood’s Jay Apwah.

Did you know that since IBM Planning Analytics was released on the cloud, there have been changes to IBM Planning Analytics server configuration parameters? New parameters have been introduced, existing ones have had their default values changed, and the behavior upon changing has changed for some others. This blog post briefly describes the eight changes.

New Parameters:

There are a handful of new parameters that have been introduced. Here is one:

UseExcelSerialDate

Setting this parameter to T causes Planning Analytics functions to use Jan 1, 1900 as the initial serial date instead of Jan 1, 1960. Jan 1, 1900 is also the initial serial date that Microsoft Excel uses. The default value for this parameter is F. Set UseExcelSerialDate = T for Planning Analytics functions to use the Excel serial date scheme.

Changes to default value:

MTQ

In previous releases, the default value was F. The default value is now ALL. This parameter allows Planning Analytics to take advantage of multiple processor cores in order to split calculations into multiple parallel threads.

MDXSelectCalculatedMemberInputs

In previous releases, the default value was F. The default value is now T.  This parameter protects against unintended suppression of calculated members when the calculation components are not requested in the query results.

Changed from static to dynamic:

Some parameters are now dynamic, which means parameter values can be edited while the Planning Analytics server is running. It takes 60 seconds for the changed parameter value to take effect.

AuditLogOn

This is an optional parameter that enables and disables audit logging. To enable, set AuditLogOn = T

IntegratedSecurityMode

Although this parameter is dynamic, each user must be logged out of all Planning Analytics components it to take effect.

UseLocalCopiesforPublicDynamicSubsets

This parameter improves performance of public dynamic subsets by using local copies of the public subset instead of the public subset itself.

No longer used:

AuditLogMaxTempFileSize

A similar parameter still exists: AuditLogMaxFileSize. Use it to indicate the maximum audit log file size before a new one is created.

ParallelInteraction

This parameter was used for allowing read/write concurrency on the same cube object.

IBM Planning Analytics 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 additional blog posts on IBM Planning Analytics Tips & Tricks:

Top 5 IBM Planning Analytics Tips & Tricks

IBM Planning Analytics Tips & Tricks: Using Attributes

IBM Planning Analytics Tips & Tricks: Upgrading from TM1

Home » Planning & Forecasting » Page 16

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

  • « Go to Previous Page
  • Page 1
  • Interim pages omitted …
  • Page 14
  • Page 15
  • Page 16
  • 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.