• 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

IBM Planning Analytics Tips & Tricks: Show Members

October 27, 2020 by Lee Lazarow Leave a Comment

Tips & Tricks

Did you know that while you are doing dimension maintenance, you can quickly view an element’s parents or children in IBM Planning Analytics Workspace (PAW) via a single click? Here’s how you can do this:

Step 1: Select the dimension to be edited. This is done by either right clicking on a dimension and selecting the option to “Edit Dimension” or by dragging the dimension onto a sheet.

Step 2: Right click on an element and select the option to “Show Member.” You will then see two sub-options: one for Parents and one for Children.

IBM Planning Analytics Tips & Tricks: Show Members
  • If you select the option for Parents then you will see all of the parents associated with the selected element. In this example, there is only one parent within the dimension structure.
Show members in IBM Planning Analytics
  • If you select the option for Children then you will see all of the children associated with the selected element. In this example, there are three elements in the consolidation.
How to show members in IBM Planning Analytics

Once defined, you can then perform dimension maintenance to each of the elements on your screen.

This approach allows you to easily traverse up or down your dimension while minimizing the amount of extra elements on the 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!

Read more IBM Planning Analytics Tips & Tricks:

IBM Planning Analytics Tips & Tricks: Sort Elements within a Subset

IBM Planning Analytics Tips & Tricks: Editing Chores While Active

IBM Planning Analytics Tips & Tricks: Creating Groups in PAW

Home » Planning & Forecasting » Page 8

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

IBM Planning Analytics Tips & Tricks: An Approach to Strengthening your MDX Skills

October 20, 2020 by Lee Lazarow Leave a Comment

Tips & Tricks

Are you new to IBM Planning Analytics and looking for a good way to learn about the various commands associated with MDX? The Planning Analytics subset editor offers a great way to teach you about MDX expressions that can be used to define elements within a dimension.

The example below shows the results of a subset that includes all descendants of Total Department. The subset was created by simply dragging Total Departments into the current set while having the member insertion defined as descendants.

IBM Planning Analytics Tips & Tricks: Subset MDX Button

Once created, I can see the MDX expression that is used by clicking the MDX button at the top, right corner of the screen. The resulting expression is:

IBM Planning Analytics Tips: Subset MDX button

However, this button is not only used to view your newly created MDX expressions. The button also allows you to edit the expression. In this case, I can change the root element to be Sales and Marketing by simply typing over the existing MDX expression.

IBM Planning Analytics Tricks: Subset MDX button

After clicking the OK button, the elements in the current set are updated.

Subset MDX button in IBM Planning Analytics

This approach can help you to learn the fundamentals of MDX expressions, which are helpful for many different components of Planning Analytics.

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: Sort Elements Within a Subset

IBM Planning Analytics Tips & Tricks: Editing Chores While Active

IBM Planning Analytics Tips & Tricks: Creating Groups in PAW

Home » Planning & Forecasting » Page 8

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

IBM Planning Analytics Tips & Tricks: Sort Elements within a Subset

October 6, 2020 by Lee Lazarow Leave a Comment

Tips & Tricks

Did you know that there are two different ways to sort elements within a subset in IBM Planning Analytics?

Below is an example of a subset which shows a standard time dimension:

Subset sort options in IBM Planning Analytics

One approach sorts all elements either ascending or descending, regardless of level. These are done via the following icons:

IBM Planning Analytics Tips & Tricks: Subset sort options

The result of this type of ascending sort will put all elements in alphabetical order, regardless of level:

Understanding subset sort options in IBM Planning Analytics

The other approach also sorts elements either ascending or descending, but this approach takes levels into consideration. These are done via the following icons:

Subset sort options in IBM Planning Analytics

The result of this type of ascending sort will put all elements in alphabetical order while keeping the levels intact:

Learn subset sort options in IBM Planning Analytics

This approach will allow you to sort your list of elements in various ways, which offers different opportunities based on the elements within the dimension.

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: Editing Chores While Active

IBM Planning Analytics Tips & Tricks: Creating Groups in PAW

IBM Planning Analytics Tips & Tricks: Control Space

Home » Planning & Forecasting » Page 8

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

IBM Planning Analytics Scores 13 Top Rankings and 21 Leading Positions in BARC’s The Planning Survey 20

October 5, 2020 by Lisa Minneci Leave a Comment

News & Events

IBM Planning Analytics, which is built on the well-known and proven TM1 engine, received numerous high marks in this year’s annual Planning Survey from BARC. The survey provides a “detailed quantitative analysis of why customers buy planning tools, what they use them for, they everyday problems that users experience with the tools and how successful they are.”

The survey findings include:

  • 954% of surveyed users rate IBM Planning Analytics’ coverage of planning-specific requirements as excellent or good, compared to 89% for the average planning tool
  • 50% of surveyed users chose IBM Planning Analytics because of its flexibility, compared to 48% for the average planning tool
  • 43% of surveyed users chose IBM Planning Analytics because of its convincing performance, compared to 31% for the average planning tool.

“Besides planning, customers mainly use IBM Planning Analytics for ad hoc query and reporting (91 percent), standard/enterprise reporting (77 percent) and basic data analysis (72 percent). 51 percent of respondents plan to use it for advanced analysis in the future … 67 percent of Planning Analytics users are planning users – just above the survey average of 65 percent – reflecting the fact that Planning Analytics is essentially a planning tool with complementary BI and analytics functionality.” – BARC Comment

BARC Planning Survey 20

Download the highlights to learn details on IBM Planning Analytics’ rankings, read customer quotes, and more.

Home » Planning & Forecasting » Page 8

Filed Under: News & Events Tagged With: analyst report, Analytics, BARC, BARC Planning Survey 20, Budgeting Planning & Forecasting, Financial Performance Management, IBM Cognos TM1, IBM Planning Analytics, Planning & Forecasting, Planning & Reporting, TM1

IBM Planning Analytics Tips & Tricks: Editing Chores While Active

September 29, 2020 by Lee Lazarow Leave a Comment

Did you know that IBM Planning Analytics Workspace (PAW) allows you to edit chores while they are active? Perspectives required you to de-activate a chore, make your modifications, and then re-activate it. However, the two “bookend” steps of this approach have been eliminated in the PAW environment.

To edit a chore, right click on the name of the chore and select the option to “Edit Chore.”

IBM Planning Analytics Tips & Tricks: Editing Chores

The chore will open to show you information about the chore.  You will then be able to edit the details associated with the schedule and the specific processes to run.

You have the option to disable the schedule at any time, but this is no longer a requirement.

Editing chores in IBM Planning Analytics Workspace

This approach allows you to quickly modify your chores without having to perform the mundane steps of de-activating it and then re-activating it. This also means that you no longer need to remember to turn the chore back on after making your changes!

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

IBM Planning Analytics Tips & Tricks: Edit Action Button

IBM Planning Analytics Tips & Tricks: Comparing Sandboxes

Home » Planning & Forecasting » Page 8

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

Office of Finance Benchmark Data

September 28, 2020 by Lisa Minneci Leave a Comment

News & Events

Do you know how your Office of Finance compares to others? A recent report from Ventana Research looks at change in the Office of Finance and provides benchmarks against which senior finance executives can compare their departments against their peers.

Ventana has researched the performance of the finance organization for 15 years. The report provides a comprehensive look at how the Office of Finance is transforming, the importance of Finance IT, key insights for the Office of Finance, and 10 best practice recommendations.

Benchmark data

Ventana shares plenty of interesting benchmark data in this report, including:

  • 76% of finance leaders surveyed cite analytics as critical for improving their performance
  • The share of companies that have a Finance IT group has increased to 59% from 45% in 2014
  • More than one in five said their process for creating finance analytics works very well
  • 32% said they use analytics to improve performance, compared to 14% in 2014
  • 46% of senior executives report full availability of finance analytics
  • 72% report reviewing their close process either monthly or quarterly
  • Companies that close their books within six days after the end of the quarter are more likely to provide executives with timely information
  • 66% report their budgets remain relevant through the period
  • 52% review their actual to budgets within six days; 19% do it within three business days
Home » Planning & Forecasting » Page 8

Filed Under: News & Events Tagged With: Analytics, Budgeting Planning & Forecasting, Financial Performance Management, Office of Finance, Planning & Forecasting, Planning & Reporting, Ventana Research

IBM Planning Analytics Tips & Tricks: Creating Groups in PAW

September 22, 2020 by Lee Lazarow Leave a Comment

Did you know that you can create new groups and delete groups directly in IBM Planning Analytics Workspace (PAW)?  This is done within the dimension editor via the same screen that you use to edit dimensions and attributes.

Step 1: Select the dimension to be edited.  This is done by either right clicking on a dimension and selecting the option to “Edit Dimension” or by dragging the dimension onto a sheet.

Step 2: Switch to member security mode.  This is done by clicking the Member Security Mode icon:

IBM Planning Analytics Tips & Tricks: Creating Groups in PAW

Step 3: You can now modify groups by selecting the icon to either create or delete a group:

Creating groups in IBM Planning Analytics Workspace

If you choose the option to create a group then you will be prompted for the group name.

How to create groups in IBM Planning Analytics Workspace

Once created, you can then set security by right clicking on the applicable areas:

  • Right click on the group name to define security for all elements within the group
  • Right click on a specific element to define security only for that element

This approach will save you time by allowing you to perform all aspects of dimension maintenance within a single area.

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: PAW Cell Comments

IBM Planning Analytics Tips & Tricks: New Features in PAW – Data Refresh

IBM Planning Analytics Tips & Tricks: PAW Pass Context

Home » Planning & Forecasting » Page 8

Filed Under: IBM Planning Analytics Tips & Tricks Tagged With: Analytics, Budgeting Planning & Forecasting, Financial Performance Management, IBM Cognos TM1, IBM Planning Analytics, lee lazarow, Planning & Forecasting, Planning & Reporting, planning analytics tips & tricks video, Revelwood, TM1

FP&A Done Right: Planning for What’s Next in Uncertain Times

September 18, 2020 by Revelwood Leave a Comment

FP&A Done Right

This is a guest blog post from our partner Workday Adaptive Planning, written by Michael Magaro. The blog post was originally published on FEI Daily.

The COVID-19 pandemic changed our world, almost overnight, and businesses are having to adjust. The unprecedented nature of the pandemic means no one knows how deep the economic downturn will be, or how long it will last, which makes financial planning for businesses especially difficult.

Fitch Ratings’ “Global Economic Outlook” states that global economic activity will decline by 1.9% this year with the U.S., Eurozone and UK GDP down by 3.3%, 4.2% and 3.9%, respectively. Some industries will be more impacted than others, and next to no one has historical experience with pandemic conditions.

Companies are clearly having a hard time planning. A survey from Gartner of 99 CFOs and finance leaders taken April 14-19 revealed that 42% of CFOs have not incorporated a second wave outbreak of COVID-19 in the financial scenarios they are building for the remainder of 2020, a finding dubbed “surprising,” by Alexander Bant, practice vice president, research, for the Gartner Finance.  Many public companies have also withdrawn guidance due to lack of visibility.

So how do companies plan when visibility is so cloudy, and unknowns are so numerous?

For the finance team at Workday, we are embracing scenario planning—basically harnessing the power of “what if”—to respond to COVID-19, and so are many of our customers. Our cloud planning platform is processing up to 30 times more forecasts and build-out scenarios for customers than in a typical, pre-pandemic week. And given the volatility and unpredictability we’ve seen, it’s not likely to ease up soon.

But the reality is that agility starts with planning. Not long before the pandemic hit, we, like many companies, had our plan in hand and were evaluating many different potential outcomes, including whether the long-running economic expansion would begin to show signs of slowing. As the realities of the pandemic came into view, we stepped up scenario planning in order to adapt to changing market conditions–and achieve the level of agility our business demands. And, while we continue to adjust and adapt like all companies, we identified five critical steps for successful scenario planning.

Step One: Assess potential impact to the top line

How will what’s happening impact revenue and the various revenue streams that feed the top line number? For many companies, this will include impacts to new business activity, customer retention, and assumptions that went into the impact of new product launches — if any exist.

Each business faces a different situation. During the pandemic, many hospitality businesses are struggling. Meanwhile, many online retailers are going strong. Each industry’s history can be instructive. During the 2002 Dotcom crash and the 2008 financial crisis, for instance, software companies with a higher percentage of SMB customers took a bigger hit to monthly renewal rates.

Because no one has historical data for a pandemic, it’s important to start off fairly basic with scenario planning. Model some elements from the top line, such as new sales, business renewal activity, and up-sell to existing customers by quarter throughout the year. Consider a range of scenarios possible for your business, perhaps 50%, 65% and 80% of a pre-pandemic plan. This gives a good view into what could happen to the income statement and balance sheet and help businesses understand variances on metrics that matter most to them. For organizations similar to Workday, that’s subscription revenue growth, non-GAAP operating margin, and, ultimately, cash flow.

Step Two: Identify levers on the investment side of the business

What levers do you have to pull? For most companies, people are the biggest cost. Do you hire as planned before the pandemic? What are the differences between hiring as planned, freezing hiring for the rest of the year, and the range of options in between? No business wants to cut job cuts at any time, so it’s important to understand other cost levers at your disposal, and the various outcomes possible when you pull them. To understand your big levers, you have to really understand your business.

Step Three: Align leadership

The finance team alone should not decide steps one and two. Involve all leaders so you get the right picture and analysis, and make sure you’ve identified the right levers. Involving leaders keeps everyone aligned and thinking about the right things. For many companies this may take the form of dashboards shared across the leadership team or creating regular review meetings.

Step Four: Identify a good outcome

Ask what a good outcome looks like for your organization. This will differ for each organization. Is it to retain existing customers? Is it to retain your workforce, or to maintain a customer satisfaction standard? Is it to expand and win market share from distracted competitors? By identifying what matters most to your organization, you’ll better prioritize through steps one, two, and three. And in today’s climate, that desired outcome may change, further elevating the importance of a continuous approach to planning.

Step Five: Dive deeper

Once you have your various scenarios, and have received feedback on them, dive deeper. For some companies, this will mean digging into supply chain issues, for others it may be assessing risk by segment, etc. Third-party research can help you decide how to respond. For instance, if you know a number of your suppliers or customers are feeling a lot of pain, how can you be proactive in supporting them? Align various teams on this topic, too. For instance, sales and customer service hear directly from customers. Their knowledge should inform your analysis and drive your ability to help your customers, partners, and your own top line.

Scenario planning to continuous planning

Even prior to the pandemic, Workday’s finance organization was working toward a continuous planning framework. Our aim is to shift from annual planning and budgeting to continuous planning via more frequent reviews and assessment of how changing conditions impact our product roadmaps, and vice-a-versa. Along the way, we look at such things as margins and cash flow. Whenever conditions change, we anticipate being able to take action and adjust our model. For instance, if product development runs behind schedule, do we adjust by upping investment to get it back up to speed or do we adjust our top line estimates? If we’re operating correctly under the continuous planning framework, planning is not a point in time—it is continuous.

Embracing flexibility

The pandemic is challenging us as humans, as companies, and as business partners in all kinds of new ways. When any crisis hits, finance teams need to be able to seamlessly navigate the kinks that come with uncertainty. Scenario planning—and eventually continuous planning—enables us to embrace flexibility and to use it our advantage.

This blog post was also published by Workday Adaptive Planning and appeared here.

Home » Planning & Forecasting » Page 8

Filed Under: FP&A Done Right Tagged With: Budgeting Planning & Forecasting, continuous planning, COVID-19, Financial Performance Management, FP&A, FP&A done right, Planning & Forecasting, Planning & Reporting

IBM Planning Analytics Tips & Tricks Video: Using Drag & Drop to Change Selector Elements in PAx Reports

September 15, 2020 by Lisa Minneci Leave a Comment

Video

In our latest IBM Planning Analytics Tips & Tricks video, Lee Lazarow, Revelwood’s FP&A technology director demonstrates how to change selector elements within IBM Planning Analytics for Excel (PAx) using drag and drop functionality. This new feature enables you to do this without having to open the set editor.

Watch this video and you’ll learn how to:

  • Select the element you want and drag it
  • Drag an existing set of elements to a selector

This approach enables Planning Analytics administrators the ability to change the values in a subset without having to train your users or learn anything about the subset editor.

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 IBM Planning Analytics Tips & Tricks videos:

IBM Planning Analytics Tips & Tricks Video: Formatting Views in Planning Analytics Workspace

IBM Planning Analytics Tips & Tricks Video: Creating Multi-Level Dimensions

IBM Planning Analytics Tips & Tricks Video: The Hold Feature

Home » Planning & Forecasting » Page 8

Filed Under: IBM Planning Analytics Tips & Tricks, Videos Tagged With: Budgeting, Budgeting Planning & Forecasting, Financial Performance Management, IBM Cognos TM1, IBM Planning Analytics, lee lazarow, Planning & Forecasting, Planning & Reporting, Planning Analytics for Excel, Planning Analytics tips, Revelwood, TM1

  • « Go to Previous Page
  • Page 1
  • Interim pages omitted …
  • Page 6
  • Page 7
  • Page 8
  • Page 9
  • Page 10
  • Interim pages omitted …
  • Page 17
  • Go to Next Page »

Footer

Revelwood Overview

Revelwood helps finance organizations close, consolidate, plan, monitor and analyze business performance. As experts in solutions for the Office of Finance, we partner with best-in-breed software companies by applying best practices guidance and our pre-configured applications to help businesses achieve their full potential.

EXPERTISE

  • Workday Adaptive Planning
  • IBM Planning Analytics
  • BlackLine

ABOUT

  • Who We Are
  • What We Do
  • How We Help
  • How We Think
  • Privacy

CONNECT

World Headquarters

Florham Park, NJ | 201 984 3030

European Headquarters

London & Edinburgh | +44 (0)131 240 3866

Latin America Office

Miami, FL | 201 987 4198

Email
info@revelwood.com

Copyright © 2025 · Revelwood Inc. All rights reserved. Revelwood® and the Revelwood logo are registered marks of Revelwood Inc.