• 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

TM1

IBM Planning Analytics Tips & Tricks: 2022’s Top 3 Tips & Tricks Videos

December 20, 2022 by Revelwood

The Revelwood team has created many IBM Planning Analytics Tips & Tricks videos. Which ones made it into the top 3 with the most views on YouTube? [Drumroll please!]

They are (in order of the most views):

1. Shortcuts in PAW Models

In this video, we demonstrate how to save time when creating dimensions, cubes, processes and chores. We explain how to use a shortcut to create the components in your model. In legacy tools, such as Architect, you had to create these components piece by piece. With Planning Analytics you can create multiple components without having to navigate back and forth.

2. Color in Planning Analytics Workspace Charts

This video shows you how to add color to your multidimensional charts in IBM Planning Analytics Workspace (PAW). We demonstrate how to do this using an Exploration. You’ll learn how to easily add/change colors to make your charts easier to read and understand.

3. Filtering in Planning Analytics Editor

In this video, we demonstrate some approaches to filtering your elements when defining a subset in the Planning Analytics editor. You’ll learn how to:

  • Filter dimensions
  • Use descriptors such as “contains,” “equal,” and “start.” This eliminates the need to use *ZYX.
  • Filter elements
  • Reset filters
  • Add a second filter

Want to learn more? Take a look at all our IBM Planning Analytics Tips & Tricks videos. Get notified when we have a new video by subscribing to our Youtube channel.

Revelwood has worked with IBM Planning Analytics / TM1 for more than 27 years. We’ve partnered with hundreds of companies on the design, development, maintenance and updates of IBM Planning Analytics applications, across every industry. Have a challenge with Planning Analytics / TM1? We can help you!

Watch more IBM Planning Analytics Tips & Tricks Videos:

IBM Planning Analytics Tips & Tricks: How to Set Up Action Buttons in Planning Analytics for Excel

IBM Planning Analytics Tips & Tricks: How to Set Up Synchronizations in IBM Planning Analytics Workspace

IBM Planning Analytics Tips & Tricks: Global Settings in Overview Area of Exploration

Home » TM1 » Page 10

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

IBM Planning Analytics Tips & Tricks: Excel TEXTBEFORE & TEXTAFTER

December 13, 2022 by Lee Lazarow

A while back, I wrote a blog about using Excel to manipulate text. The functions in that blog allow you to rip text apart and put the pieces together so you can parse out pieces of your text strings. Since that writing, Microsoft has introduced two additional functions that can help you search for specific text values. These functions are TEXTBEFORE and TEXTAFTER.

  • TEXTBEFORE will return text before the characters you are searching for
  • TEXTAFTER will return text after the characters you are searching for

Both functions have two required parameters:

=TEXTBEFORE(text,delimiter)

=TEXTAFTER(text,delimiter)

  • The text parameter defines the string value you are searching for
  • The delimiter parameter defines the point after you want to extract

In addition, there are optional parameters that can be used to determine case sensitivity and what to do if no match if found.

The following example shows how to use these functions:

Graphical user interface, text, application, chat or text message

Description automatically generated

This approach will simplify your searches by eliminating the need to merge functions such as FIND, and LEN and LEFT/RIGHT together.

Revelwood has worked with IBM Planning Analytics / TM1 for more than 27 years. We’ve partnered with hundreds of companies on the design, development, maintenance and updates of IBM Planning Analytics applications, across every industry. Have a challenge with Planning Analytics / TM1? We can help you!

Read more IBM Planning Analytics Tips & Tricks:

IBM Planning Analytics Tips & Tricks: How to Set Up Action Buttons in Planning Analytics for Excel

IBM Planning Analytics Tips & Tricks: Excel SEQUENCE

IBM Planning Analytics Tips & Tricks: PAW Go To Line in Process

Home » TM1 » Page 10

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

IBM Planning Analytics Tips & Tricks: How to Set Up Action Buttons in Planning Analytics for Excel

December 6, 2022 by Dillon Rossman

Revelwood’s latest IBM Planning Analytics Tips & Tricks video features Dillon Rossman, a consultant with our IBM Planning Analytics practice, demonstrating how to set up action buttons in IBM Planning Analytics for Excel (Pax).

In this video, Dillon shows your three approaches: 

  • Default approach
  • Creating the action button in a different workbook or sheet
  • Run a process and then go to another worksheet

Revelwood has worked with IBM Planning Analytics / TM1 for more than 27 years. We’ve partnered with hundreds of companies on the design, development, maintenance and updates of IBM Planning Analytics applications, across every industry. Have a challenge with Planning Analytics / TM1? We can help you!

Watch more IBM Planning Analytics Tips & Tricks:

IBM Planning Analytics Tips & Tricks: How to Set Up Synchronizations in IBM Planning Analytics Workspace

IBM Planning Analytics Tips & Tricks: Filtering in IBM Planning Analytics Editor

IBM Planning Analytics Tips & Tricks: Global Settings in Overview Area of Exploration

Home » TM1 » Page 10

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

IBM Planning Analytics Tips & Tricks: How to Set Up Synchronizations in IBM Planning Analytics Workspace

November 29, 2022 by Dillon Rossman

Revelwood’s latest IBM Planning Analytics Tips & Tricks video features Dillon Rossman, a consultant with our IBM Planning Analytics practice, demonstrating how to set up synchronizations in Planning Analytics Workspace (PAW).

In this video, Dillon walks you through how to:

  • Change an exploration to a pie chart
  • Edit the synchronization properties
  • Select the dimensions you want to be synchronized
  • Perform synchronizations on both a sheet and a book

Revelwood has worked with IBM Planning Analytics / TM1 for more than 27 years. We’ve partnered with hundreds of companies on the design, development, maintenance and updates of IBM Planning Analytics applications, across every industry. Have a challenge with Planning Analytics / TM1? We can help you!

Watch more IBM Planning Analytics Tips & Tricks:

IBM Planning Analytics Tips & Tricks: Filtering in Planning Analytics

IBM Planning Analytics Tips & Tricks: Global Settings in Overview

IBM Planning Analytics Tips & Tricks: Color in Planning Analytics

Home » TM1 » Page 10

Filed Under: IBM Planning Analytics Tips & Tricks Tagged With: IBM Cognos TM1, IBM Planning Analytics, Planning & Forecasting, TM1

IBM Planning Analytics Tips & Tricks: Excel SEQUENCE

November 22, 2022 by Lee Lazarow

Have you ever needed to quickly generate a list of numbers? Maybe you need to create a list from 1-100. Maybe you want to create a list of the first 100 even numbers. Maybe you want to create those same lists in descending order. Did you know that Excel has a function called SEQUENCE which allows you to quickly create these lists?

The SEQUENCE function is used to generate an array of sequential numbers.  The syntax of the function is:

=SEQUENCE (rows, [columns], [start], [step])

  • Rows (required)
    • This is the number of rows to be filled
  • Columns (optional)
    • This is the number of columns to be filled
    • If skipped, this defaults to 1
  • Start (optional)
    • This is the starting number in the sequence
    • If skipped, this defaults to 1
  • Step (optional)
    • This is the increment for each subsequent value
    • If skipped, this defaults to 1
    • This can be negative to provide a descending list

The following example shows a single column list from 1-10

Chart

Description automatically generated with medium confidence

The same formula doubles the result when the column parameter is defined. Note that the results read from right to left (e.g., the entire row) and then goes down.

Table

Description automatically generated with medium confidence

Here is the same formula when adding both a starting value and an increment.

Table

Description automatically generated

Not only can this formula be used to quickly generate lists, but it can also be used as part of a combination:

  • With the DATE formula to define a calendar
  • With the TIME formula to create a daily schedule
  • With data from another column to create unique IDs for items like products or employees

Read more IBM Planning Analytics Tips & Tricks:

IBM Planning Analytics Tips & Tricks: Creating Control Objects from the Modeling Workbench

IBM Planning Analytics Tips & Tricks: Shortcuts in PAW Models

IBM Planning Analytics Tips & Tricks: Customizing Background Colors for Data and Header Cells

Home » TM1 » Page 10

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

IBM Planning Analytics Tips & Tricks: PAW Go To Line in Process

November 15, 2022 by Lee Lazarow

Sometimes your TurboIntegrator scripts can become very long. While it’s nice to be able to scroll up and down throughout your code, there are times that you may want to go directly to a specific line. IBM Planning Analytics Workspace (PAW) version 79 allows this via the “Go to Line” button.

Once clicked, you are prompted to select a section and a line within the section.  

When defining a line, note that the line numbers restart within each section. In the example below, each set of generated statement lines begin at line 2 (since I like to skip a line for easy reading) and the first line of code in the Data section begins at line 5.

This approach will help you speed up your navigation as you write code in TurboIntegrator.

Revelwood has worked with IBM Planning Analytics / TM1 for more than 27 years. We’ve partnered with hundreds of companies on the design, development, maintenance and updates of IBM Planning Analytics applications, across every industry. Have a challenge with Planning Analytics / TM1? We can help you!

Read more IBM Planning Analytics Tips & Tricks:

IBM Planning Analytics Tips & Tricks: Planning Analytics Workspace Borders in Preview

IBM Planning Analytics Tips &Tricks: Rounded Buttons in Planning Analytics Workspace

IBM Planning Analytics Tips & Tricks: MDX Syntax Explained

Home » TM1 » Page 10

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

FP&A Done Right: Approaches to Long-Term Planning

November 14, 2022 by Lee Lazarow

“If you fail to plan, you are planning to fail.” – Ben Franklin

In our collective rush to react to ever-changing marketplace dynamics and shifts in the economy, it’s easy to focus on short-term plans, to the neglect of long-term planning. Today’s leaders need to have several plans – short-term, medium-term, and long-term.

Different plans for different needs

How do these plans differ? A short-term plan is designed to show granular details for a limited time frame. This is often updated monthly, although we have some clients updating their plans on a weekly basis. One of our clients follows a process where local managers update their plans on Mondays and Tuesdays, have the regional managers review the data on Thursdays, and allow senior management to analyze and assess the data on Fridays. Each Monday they start the process over.

Most organizations utilize a medium-term plan that looks out anywhere from a few quarters to a full year. Most people will think of this as a standard monthly forecast with data at a bit more of a higher level, but still somewhat details.

A long-term plan often goes out multiple years. Many companies create a 5-year plan, although some industries such as entertainment and pharmaceutical often create 20-25 year plans. A long-term plan is a high-level view of the business. It’s not nearly as granular as short, or even medium-term plans. The plan does not get down to the level of looking at a GL account or a customer. It’s a measuring tool and a defined way of reviewing the progress of the company. In short, long-term planning helps to set the company’s direction.

The essentials of long-term planning

The long-term plan gives you guidance on how to answer several questions, including:

  • How can we expand the company?
  • How can we look into acquisitions?
  • What products, geographies, and verticals can we or should we add?
  • What products no longer make sense?
  • How do debt payments impact cash flow?
  • What type of labor, buildings, locations, and equipment do we need?

A long-term plan can be considered a proactive approach to risk mitigation, enabling companies to plan, think ahead, prepare for, and lessen the impact of potential negative effects. At Revelwood, we recommend two approaches to long-term planning: the growth percent approach and a driver-based approach.

We often see both of these methods used when performing long-term planning in IBM Planning Analytics with Watson:

Growth percent approach

The growth percent approach allows you to adjust groups of data (accounts, departments, etc.) by increasing or decreasing the values from the previous year. Some clients prefer to simply use a single percentage (example: reduce all expenses by 2% each year for the next five years) whereas some clients prefer to include more variation (example: reduce utilities expenses by 2% next year, by 3% the following year, and by 4% for the next three years). But no matter what level of detail is used, Planning Analytics’ powerful scripting tool will perform the entire long term plan in a matter of seconds.

Driver-based approach

A driver-based approach uses operational activity to calculate key variable revenues and expenses. This approach allows you to simplify the input by defining a set of drivers and creating calculations that use the drivers.  For example, a single driver of “units sold” can be used to immediately calculate revenue, COGS, and some of your variable expenses using the tool’s efficient calculation engine.

Mitigate risk with long-term planning

Long-term planning is your company’s assurance against planning to fail. There’s a reason why Franklin’s quote has lasted through the years. And it should be the motto of every planning team.

Learn more about long-term planning by watching our on-demand webinar – Long-Term Planning in IBM Planning Analytics.

This post originally appeared on IBM’s Journey to AI blog.

Home » TM1 » Page 10

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

IBM Planning Analytics Tips & Tricks: Filtering in IBM Planning Analytics Editor

November 8, 2022 by Revelwood

Did you know there are different approaches to filtering elements when defining a subset in the IBM Planning Analytics editor? Lee Lazarow, Revelwood’s FP&A technology director and IBM Planning Analytics practice leader, demonstrates some ways to filter elements in our latest IBM Planning Analytics Tips & Tricks video.

Watch the video and you’ll learn how to:

  • Filter dimensions
  • Use descriptors such as “contains,” “equal,” and “start,” eliminating the need to use *ZYX
  • Filter elements
  • Reset filters
  • Add a second filter

Revelwood has worked with IBM Planning Analytics / TM1 for more than 27 years. We’ve partnered with hundreds of companies on the design, development, maintenance and updates of IBM Planning Analytics applications, across every industry. Have a challenge with Planning Analytics / TM1? We can help you!

Watch more IBM Planning Analytics Tips & Tricks Videos:

IBM Planning Analytics Tips & Tricks: Global Settings in Overview Area of Exploration

IBM Planning Analytics Tips & Tricks: Add Color to Multidimensional PAW Charts

IBM Planning Analytics Tips & Tricks: Shortcuts in PAW Models

Home » TM1 » Page 10

Filed Under: IBM Planning Analytics Tips & Tricks Tagged With: filter + planning analytics, Financial Performance Management, TM1

IBM Planning Analytics Tips & Tricks: Planning Analytics Workspace Borders in Preview

November 1, 2022 by Lee Lazarow

Tips & Tricks

IBM Planning Analytics Workspace (PAW) allows you to easily create selector widgets that can be used for updating the data in your PAW book. This is done by adding a dimension as a selector widget.

You can edit the list of elements (e.g., the set) and the way the list appears. The selector widget allows you to easily select an element that is synchronized to your charts and explorations. When selecting the element, a border appears around the widget.

Diagram

Description automatically generated with low confidence

While this border offers features such as the ability to expand the screen, it clearly makes the list into a separate section of the page. You can remove the border by using the property called “Show selected border in preview” (within the area called General, Appearance). Here is the same list without the border enabled:

Text

Description automatically generated

This property will allow you to create the perception of a single page and not a set of independent objects.

Revelwood has worked with IBM Planning Analytics / TM1 for more than 27 years. We’ve partnered with hundreds of companies on the design, development, maintenance and updates of IBM Planning Analytics applications, across every industry. Have a challenge with Planning Analytics / TM1? We can help you!

Read more IBM Planning Analytics Tips & Tricks:

IBM Planning Analytics Tips &Tricks: Rounded Buttons in Planning Analytics Workspace

IBM Planning Analytics Tips & Tricks: MDX Syntax Explained

IBM Planning Analytics Tips & Tricks: Global Settings in Overview Area of Exploration

Home » TM1 » Page 10

Filed Under: IBM Planning Analytics Tips & Tricks Tagged With: IBM Cognos TM1, IBM Planning Analytics, IBM Planning Analytics Tips & Tricks, Planning & Forecasting, TM1

  • « Go to Previous Page
  • Page 1
  • Interim pages omitted …
  • Page 8
  • Page 9
  • Page 10
  • Page 11
  • Page 12
  • Interim pages omitted …
  • Page 37
  • 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.