• 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

IBM Planning Analytics

IBM Planning Analytics Tips & Tricks: Regions within Regions

January 7, 2020 by Lee Lazarow Leave a Comment

Tips & Tricks

A while back I wrote a blog post about using Regions within Planning Analytics rules. Regions allow you to make your rules easier to navigate and read when scrolling through many lines of code. But did you know that you can have regions within your regions?

Here is an example of a region, both opened and closed:

IBM Planning Analytics Tips: Regions within Regions
IBM Planning Analytics Tips: Regions within Regions

But what if you wanted to differentiate the components within the region?  You can use the exact same concept to create sub-regions:

IBM Planning Analytics Tricks: Regions within Regions
IBM Planning Analytics: Understanding Regions within Regions

Planning Analytics is smart enough to know how to group the start/end components of the region and allow the sub-regions to work within a larger region.  This approach allows us to create sub-groups to make your code even easier to navigate.

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!

Learn more about Planning Analytics Rules and working with Regions:

IBM Planning Analytics Tips & Tricks: Regions with Planning Analytics Rules

IBM Planning Analytics Tips & Tricks: Writing Rules

IBM Planning Analytics Tips & Tricks: Rule Concepts that are Often Forgotten

Home » IBM Planning Analytics » Page 26

Filed Under: IBM Planning Analytics Tips & Tricks Tagged With: Analytics, Financial Performance Management, IBM Cognos TM1, IBM Planning Analytics, lee lazarow, TM1

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

December 20, 2019 by Ken Wolf Leave a Comment

FP&A Done Right

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

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

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

Business Resilience? Or Agility?

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

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

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

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

Facing the Future

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

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

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

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

Your Game Plan: Find Your Enabling Technology

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

Your Game Plan: Think Differently About the Office of Finance

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

The End Game: Resilience and Agility

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

Home » IBM Planning Analytics » Page 26

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

IBM Planning Analytics Tips & Tricks: The New Planning Analytics Admin Approach

December 17, 2019 by Lisa Minneci Leave a Comment

Video

In our latest IBM Planning Analytics Tips & Tricks video, Lee Lazarow, Revelwood’s FP&A Technology Director, shows you a new, single location in Planning Analytics where you can perform all your administrative tasks. This saves Planning Analytics admins time and simplifies your maintenance activities by enabling you to do all the tasks you would normally do through Windows services.

With this new approach to administration, Planning Analytics now combines server maintenance, database configuration and user definitions all into a single dashboard.

Watch this video to learn how to:

  • Get the status of your servers
  • Look at log files
  • Examine processes
  • Look at and control individual threads
  • Manipulate configuration settings, including your MTQ – multi-threaded querying setting

Planning Analytics new approach to administration saves you time and simplifies maintenance. This video will show you how to take advantage of this new feature.

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!

Want to get our Planning Analytics Tips & Tricks delivered to your inbox every Tuesday? Sign up to get our weekly email of just the week’s tip!

Check out our IBM Planning Analytics Tips & Tricks video series:

Dimension Maintenance in IBM Planning Analytics

Regions with Rules in IBM Planning Analytics

Bookmarking in IBM Planning Analytics

Snap Commands in IBM Planning Analytics

Pivoting & Selecting Shortcut in IBM Planning Analytics

Home » IBM Planning Analytics » Page 26

Filed Under: IBM Planning Analytics Tips & Tricks, Videos Tagged With: Analytics, Financial Performance Management, IBM Cognos TM1, IBM Planning Analytics, lee lazarow, Planning Analytics admin, Planning Analytics maintenance, TM1, video

IBM Planning Analytics Tips & Tricks: Rule Timestamps

December 10, 2019 by Lee Lazarow Leave a Comment

Tips & Tricks

TM1’s print report wizard still exists in Perspectives and many clients continue to use this approach. I recently came across an issue where a client wanted to “burst” a report and include a time stamp on a report that is being snapshot (e.g., set the cells to contain actual values and not TM1 functions that retrieve values).  Easy peasy … just use the =NOW function to generate a time stamp. Right?

Wrong. =NOW is not a TM1 formula. This means that the cell will not get converted and the timestamp would therefore refresh each time the report was opened/refreshed.

Ok, no problem. We can create a numeric value in a control cube that uses TM1’s NOW function. The time stamp will refresh each time the cell is referenced and we can then zap that value. Again, easy peasy. Right?

Wrong again! TM1 only refreshes numeric rules when the rule is re-processed. In order to keep updating the result (e.g., show the current time and date), the user would need to reprocess the rule each time.

Again, no problem. TM1 may not re-evaluate the numeric value, but it will re-evaluate a string rule like this each time the cell is queried. So we can just switch this into a string value and simply use a STR formula against the NOW command. Right?

Wait for it … wait for it …

Wrong once more! Remember that date stamps within TM1 and Excel vary by 21,916 days (well, maybe). As a result, we need to add these days to the formula. The end result gives us a formula that uses a combination of STR, NOW, 21916, lots of digits and decimals, and a trim of the wasted space.

IBM Planning Analytics Tips & Tricks: Rule Timestamps

… and this end result gives the client the ability to have a time stamp using a TM1 formula that can be snapshot and then converted into a date format!

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! Or, sign up to get our Planning Analytics Tips & Tricks delivered directly to your inbox!

Read more IBM Planning Analytics Tips & Tricks:

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

IBM Planning Analytics Tips & Tricks: Writing Rules

IBM Planning Analytics Tips & Tricks: Rule Concepts that are Often Forgotten

Home » IBM Planning Analytics » Page 26

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, Revelwood, TM1, TM1 Perspectives

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

December 3, 2019 by Lee Lazarow Leave a Comment

Tips & Tricks

Excel is, and always will be, a powerful tool for the financial team. With so much power, there are many great Excel formulas that rarely get used. I recently had a situation where I wanted to easily replicate a sheet and have each sheet use an MDX expression that referenced a different dimension name. I wanted to use a formula to determine the sheet name and used the CELL function.

The CELL function returns information about a specific cell within an Excel file. The syntax of the function is

CELL( info_type, reference ) 

The info_type defines the type of information to be returned and reference is associated with a specific cell. Some examples of info_type include “col” to define the column, “row” to define the row, “address” to define the cell refence and “filename” to return the full path and filename of the workbook and the worksheet.

The resulting format of the info_type called filename is

path[workbook.xlsm]sheetname

I took the approach of naming the sheet with the same name as the dimension. For example, one sheet was called “Account” and another sheet was called “Company.” By using a combination of the FIND function, the MID function and the TRIM function I was able to isolate the sheet name.

=TRIM(MID(CELL("filename",A1),FIND("]",CELL("filename"))+1,99))

I created this formula in cell B10 and then used the result within my MDX expression.

="{ TM1DRILLDOWNMEMBER( { ["&B10&"].[Orphans] }, ALL, RECURSIVE ) }"

This approach allows me to replicate an Active Form report by simply copying the entire sheet and then renaming the new sheet to be the same as the dimension name.

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 Excel-related tips & tricks:

IBM Planning Analytics Tips & Tricks: Recalculating Excel Worksheets

IBM Planning Analytics Tips & Tricks: Workarounds for Unsupported Excel Functions in TM1 Web

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

Home » IBM Planning Analytics » Page 26

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

IBM Planning Analytics Tips & Tricks: Trimming Picklists

November 26, 2019 by Lee Lazarow Leave a Comment

Tips & Tricks

Did you know that IBM Planning Analytics includes a feature that helps trim the list of choices in a picklist as you type? There are many different ways to create picklists in TM1/Planning Analytics and Revelwood has previously written about creating picklist cubes.

Here is an exploration that uses a picklist. This list entails all base level elements of a dimension. As you can see, there are six options to choose from.

IBM Planning Analytics Tips & Tricks: Trimming Picklists

I can select a value by clicking on an element from the list, which is great when I have a small list like this. But what if I have hundreds of elements in the list? The list can quickly become hard to navigate.

I can instead type in the “Search” area. If I type the letter “F” then my list is reduced to the only elements that contain the letter F.

IBM Planning Analytics Tips: Trimming Picklists

You can see that the list does not just look at the first character … it instead looks at all characters. As another example, if I instead type the letters “ment” then the list will trim down to anything that contains these letters within the full string.

IBM Planning Analytics Tricks: Trimming Picklists

This approach can help your end users when selecting cost centers, employee names, or other long lists.

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!

Want to get our Planning Analytics Tips & Tricks delivered to your inbox every Tuesday? Sign up to get our weekly email of just the week’s tip!

Learn more about picklists in IBM Planning Analytics:

IBM Planning Analytics Tips & Tricks: Creating TM1/Planning Analytics Picklist Cubes

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

Home » IBM Planning Analytics » Page 26

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

IBM Planning Analytics Tips & Tricks: Simplifying Dimension Maintenance

November 19, 2019 by Lisa Minneci Leave a Comment

Videos

Watch our latest IBM Planning Analytics Tips & Tricks video to learn how to simplify dimension maintenance in Planning Analytics. Once you master these easy techniques, you’ll be able to do all of your dimension maintenance from the Planning Analytics Workspace (PAW) administration screen.

In this video, Lee Lazarow, Revelwood’s FP&A technology director, demonstrates how to maintain your dimensions in PAW. Lee shows you how to move elements using both a standard drag-and-drop approach and a wizard-based approach. You’ll also see how to create new hierarchies and how to manipulate your dimension structure without going to a different screen.

By merging all aspects of a dimension together, you can do all your dimension maintenance from the PAW administration screen.

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!

Want to get our Planning Analytics Tips & Tricks delivered to your inbox every Tuesday? Sign up to get our weekly email of just the week’s tip!

Check out our IBM Planning Analytics Tips & Tricks video series:

Regions with Rules in IBM Planning Analytics

Bookmarking in IBM Planning Analytics

Snap Commands in IBM Planning Analytics

Pivoting & Selecting Shortcut in IBM Planning Analytics

Home » IBM Planning Analytics » Page 26

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

IBM Planning Analytics Tips & Tricks: PAx Control Objects

November 12, 2019 by Lee Lazarow Leave a Comment

Tips & Tricks

IBM Planning Analytics uses cubes to store metadata information such as security and attribute information. These automatically generated cubes are called control cubes (which I sometimes call “squiggle cubes”) and begin with a prefix of a right curly brace.

Server Explorer used a toggle approach within the View menu to allow users to either view or hide these cubes. Planning Analytics for Excel (PAx) also includes a toggle approach that can be used via the following steps:

1) Ensure that the task pane is showing by selecting the icon within the IBM Planning Analytics ribbon

IBM Planning Analytics Tips & Tricks: PAX Control Objects

2) Click on the icon for “show and hide”

Understanding PAx Control Objects - IBM Planning Analytics Tips & Tricks

3) Select the option for “show control objects”

How to use PAx Control Objects - IBM Planning Analytics Tips & Tricks

Once selected, the list of cubes will expand and will display the control cubes. This list can be controlled via cube security to limit which control cubes can be seen 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!

Read more IBM Planning Analytics Tips & Tricks:

IBM Planning Analytics Tips & Tricks: Troubleshooting Planning Analytics for Excel (PAx)

IBM Planning Analytics Tips & Tricks: The Ranked Report

IBM Planning Analytics Tips & Tricks: The Replace and Close Feature in PAx

Home » IBM Planning Analytics » Page 26

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

IBM Planning Analytics Tips & Tricks: Learn How to Use the Pivoting and Selecting Shortcut

November 5, 2019 by Lisa Minneci Leave a Comment

Video

Our latest IBM Planning Analytics Tips & Tricks tutorial video explains how and why you should use the pivoting and selecting shortcut. In this short video, Revelwood’s FP&A Technology Director, Lee Lazarow, demonstrates how to pivot in exploration and select an element in one move – saving yourself a keystroke.

By combining these tasks into one single action, it’s now faster to navigate through your data!

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!

Watch more of Lee’s tips in our IBM Planning Analytics Tips & Tricks video series:

IBM Planning Analytics Tips & Tricks: Learn how to use Snap Commands in IBM Planning Analytics

IBM Planning Analytics Tips & Tricks: Bookmarks in IBM Planning Analytics Workspace

IBM Planning Analytics Tips & Tricks: Regions with Rules

Home » IBM Planning Analytics » Page 26

Filed Under: IBM Planning Analytics Tips & Tricks, Videos Tagged With: Analytics, demo, Financial Performance Management, IBM Cognos TM1, IBM Planning Analytics, lee lazarow, pivoting, planning analytisc tips & tricks, Revelwood, TM1, tutorial, video

  • « Go to Previous Page
  • Page 1
  • Interim pages omitted …
  • Page 24
  • Page 25
  • Page 26
  • Page 27
  • Page 28
  • Interim pages omitted …
  • Page 39
  • 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.