• 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: Popular Posts, Part 1

May 16, 2023 by Revelwood

Revelwood’s IBM Planning Analytics team covers a wide range of topics in their weekly IBM Planning Analytics Tips & Tricks posts. We’ve decided to share some of the most popular posts over the past 12 months.

IBM Planning Analytics Tips & Tricks: Dynamic Subsets Based on a Cube

Did you know you can use MDX to create dynamic subsets based on cube values in IBM Planning Analytics? Read this post as we explain an example where we will only show companies with net sales greater than 30,000,000 in the selected year.

IBM Planning Analytics Tips & Tricks: Garbage Memory

A client asked us why Windows was showing a much larger memory footprint than expected from their cube sizes. We analyzed the model and found a large amount of garbage memory. Which leads to the question “what is garbage memory?”

IBM Planning Analytics uses various approaches to minimize the amount of RAM needed for a model. Read this post to learn how much memory is being used by your cubes. 

IBM Planning Analytics Tips & Tricks: Adding and Editing Connection URLs in Planning Analytics for Excel

Read this post to learn how to add a new Connection URL or to edit an existing Connection URL in Planning Analytics for Excel (PAx).

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

IBM Planning Analytics Tips & Tricks: On-Demand Webinars, Part 1

IBM Planning Analytics Tips & Tricks: Excel Tips, Part 2

Home » IBM Planning Analytics » Page 9

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

Leveraging IBM Planning Analytics for xP&A

May 12, 2023 by Revelwood

FP&A Done Right: Finance’s Role in ESG Reporting

This is a guest post from our partner IBM. In this post, Michael McGeein, program director and product management leader – IBM Planning Analytics, showcases how organizations use IBM Planning Analytics for Extended Planning and Analysis (xP&A). 

Extended Planning and Analysis (xP&A), is not a new concept for IBM clients who use IBM Planning Analytics with Watson, formerly known as Cognos TM1. For the past several years, clients have embraced the need to tie operational decisions to the financial impact from both planning and analysis perspectives. For instance, a Director of Operations may want to increase production for the upcoming selling season, but they must first understand the impact on the business overall.

There are many operational considerations, from labor, staffing and production capacity — such as machinery and warehousing — to ensuring the business has the capital needed. All these factors need to be considered, and fortunately, IBM Planning Analytics with Watson has helped clients do this for years.

Financial and supply planning for a national blood service organization

A national blood service, and long-time Planning Analytics client, has started implementing a financial planning solution to better plan, forecast and analyze the cash flow needs and improve reporting to the leadership team and Board of Directors. Once the team fully understood the capabilities of Planning Analytics, they saw an opportunity to improve salary planning, a key part of the financial planning process. 

From that, the HR team expanded the salary plan to include the components of staff planning, including hiring and attrition.

Another way the team used Planning Analytics was to plan for the supplies needed for the collection of blood from donors. They created a planning application that schedules nurses and technicians who collect specimens and accounts for the supplies needed, from orange juice, bottled water, and cookies to medical supplies like tourniquets, blood bags, type testing kits and more.

As this company can attest, extending beyond the core finance function to plan for people, activities, and other areas has been part of Planning Analytics for years.

Financial and HR planning for a television production company

Another great example of Planning Analytics in action is with a television production company that, like many clients, was initially focused on financial planning. After the team had their financial planning and forecasting running well, they turned their focus on how to better run their business. As a ‘job shop,’ where each TV program is a job, one area of focus was cost planning by job. The team created a job planning application, starting with staff planning as one of the largest cost components. Then they extended to include overhead and expense allocations, and eventually created a weekly Show Cost planning module to understand the contribution of each show to the overall production company’s results.

Supply chain planning for a global contract specialty manufacturer

A global contract specialty manufacturer, with deep expertise in manufacturing know-how, supply chain insights, and product design, uses Planning Analytics for nearly every ‘non supply chain’ use case in their organization. From financial analysis and reporting, forecasting, reserves reporting, aged accounts receivables, and treasury cash balance and forecasting to working capital, HQ allocations, local tax adjustments, and income tax in interim periods, all of these Planning Analytics solutions are integrated to ensure changes in one area, like cash forecasting, can be reflected in the overall working capital analysis.

No matter the industry, Planning Analytics is a continuous, integrated business planning solution that helps run some of the best companies in the world. Those who use IBM Planning Analytics with Watson understand the benefits of integrated planning that are not realized when doing ‘connected’ planning in spreadsheets or other traditional tools. 

Are you interested in expanding your use of IBM Planning Analytics? Let us know – we can help!


This blog post was originally published on the IBM Journey to AI blog.

Home » IBM Planning Analytics » Page 9

Filed Under: FP&A Done Right Tagged With: FP&A, IBM Cognos TM1, IBM Planning Analytics, xP&A

IBM Planning Analytics Tips & Tricks: Run TI Processes from PAx Task Pane

May 9, 2023 by Revelwood

Did you know that you can run TurboIntegrator (TI) processes via the task pane in Planning Analytics for Excel (Pax)? Within the task pane, you can choose to display processes by clicking on the “Show and Hide” button and selecting the option to “Show processes.”

Once enabled, the processes will appear at the bottom of the task pane.

You can run the scripts by right-clicking on a process and selecting the option to “Run process.”

If any parameters are needed, a popup box will appear.  

After the process has completed, you can expand the details by hitting the drop-down symbol on the right. This will summarize whether the process ran successfully or whether there were any errors. You can then get further details about the error(s) via the message log. 

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: UNIQUE Function in Excel

IBM Planning Analytics Tips & Tricks: On-Demand Webinars, Part 2

IBM Planning Analytics Tips and Tricks: Upgrading to Planning Analytics for Excel 2.0.65 or later

Home » IBM Planning Analytics » Page 9

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

IBM Planning Analytics Tips & Tricks: TI Dimension Functions

May 2, 2023 by Marc Assenza

Have you ever updated a dimension in the Prolog of your TurboIntegrator (TI) script and then received errors when making further changes to the dimension in the Metadata section? This is because certain dimension altering functions such as DIMENSIONELEMENTINSERT are not evaluated until the Data Procedure runs.  

Dimension updates in IBM Planning Analytics / TM1 follow a specific pattern: duplicate the current dimension, make changes to the duplicated dimension, and then apply the changes to the actual dimension. The applied changes to the actual dimension do not occur until the Data procedure begins (e.g., when all Metadata scripting is completed).

Let’s say that you placed code in the Prolog to add elements using the DIMENSIONELEMENTINSERT function. If you then try to interrogate or manipulate those elements in the Metadata tab, the script would not be successful because the changes have not been fully completed. This can be resolved by instead using the DIRECT version of dimension manipulation functions, such as DIMENSIONELEMENTINSERTDIRECT. The direct version of the functions applies changes immediately to the current dimension and does not require the entire Metadata processing to be completed.

This approach will allow you to properly manipulate dimension in both the Prolog section and the Metadata section of the same script.

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: Excel Tips, Part 4

IBM Planning Analytics Tips & Tricks: PAW Users and Groups

IBM Planning Analytics Tips & Tricks: Excel Tips, Part 3

Home » IBM Planning Analytics » Page 9

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

Revelwood Partners IBM and Workday Named Market Leaders in BARC Score – Integrated Planning & Analytics 2023

April 28, 2023 by Revelwood

Revelwood’s partners IBM and Workday have been named Market Leaders in the recent BARC Score – Integrated Planning & Analytics 2023.

BARC defines Market Leaders as “well-established vendors that drive strong market adoption, supported by technology innovation and strategic acquisitions and by leveraging robust account management and a solid track record. Their portfolio enjoys high brand awareness in the market and covers an extensive range of technologies and services with only few gaps. Market Leaders typically have a large market share, making them a viable contender in almost all implementation scenarios.”

BARC is one of Europe’s leading analyst firms for business software, focusing on the areas of data, business intelligence (BI) and analytics. This year’s BARC Score for Integrated Planning & Analytics assessed Anaplan, Board International, IBM, insightsoftware, Jedox, OneStream Software, Oracle, Planful, Prophix, SAP, Unit4, Wolters Kluwer and Workday.

“Today, the reality in many companies is that IP&A is an often proclaimed but seldom achieved goal,” writes BARC. “BARC research studies continuously reveal that companies consider the improvement of the software they use to be an important investment for optimizing planning, forecasting and analytics.”

BARC notes that “the software market for IP&A is highly competitive.” Read and download the full report here.

Home » IBM Planning Analytics » Page 9

Filed Under: FP&A Done Right Tagged With: BARC Score report, IBM Cognos TM1, IBM Planning Analytics, Workday, Workday Adaptive Planning

IBM Planning Analytics Tips & Tricks: Excel Tips, Part 4

April 25, 2023 by Revelwood

Revelwood’s IBM Planning Analytics team has created numerous tips & tricks focused on helping people use Excel. For the past few weeks, we’ve been highlighting some of the most popular and interesting posts on Excel. If you’ve missed our earlier posts, read part 1, part 2 and part 3.

Here are some other Excel tips and tricks from our team of experts.

IBM Planning Analytics Tips & Tricks: Excel YEARFRAC

Some Revelwood clients often build models that define the fraction of a year for a given month. For example, January is approximately 8.5% of a calendar year (31/365) and September is approximately 11.5% of a working day’s calendar (30/260). What happens in situations where you want to calculate the percentage of a year where the days are not the first or last day of the month? This is where Excel’s YEARFRAC formula can help. 

IBM Planning Analytics Tips & Tricks: Unhide Multiple Excel Sheets

As you know, an Excel workbook can consist of multiple sheets. There are many instances where you may want to hide some of the sheets. It’s very fast and easy to hide sheets, but Excel historically allowed you to unhide only one sheet at a time. Microsoft changed that approach and now allows you to unhide multiple sheets at once.

Learn how to unhide multiple Excel sheets.

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

Excel is, and always will be, a powerful tool for the finance team. With so much power, there are many great Excel formulas that are rarely used. Here’s a situation – imagine you wanted to easily replicate a sheet and have each sheet use an MDX expression that referenced a different dimension name. You want to use a formula to determine the sheet name.Excel’s CELL function returns information about a specific cell within an Excel file. Read more to learn the syntax of that function.

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 part 1, part 2, and part 3 below:

IBM Planning Analytics Tips & Tricks: Excel Tips, Part 1

IBM Planning Analytics Tips & Tricks: Excel Tips, Part 2

IBM Planning Analytics Tips & Tricks: Excel Tips, Part 3

Home » IBM Planning Analytics » Page 9

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

IBM Planning Analytics Tips & Tricks: PAW Users and Groups

April 18, 2023 by Lee Lazarow

Do you know how to manage your users and groups in IBM Planning Analytics Workspace (PAW)? As of version 84, PAW now allows you to edit this information via a single click.

To open the users and groups editor, right-click on a database within your modeling workbench and select the option for Manage users and groups.

Once selected, a grid showing the users on the rows and the groups on the columns will appear. This layout mimics the approach used in Perspectives.  

The following functions are available to maintain your user security:

  • To assign or remove a user to a group, right-click at the intersection of a user and group name, then click Assign user to group or Remove user from group.
  • To assign all users to a group, right-click the group name, then click Assign group.
  • To remove all users from a group, right-click the group name, then click Remove group.
  • To assign a user to all groups, right-click the user name and then click Assign user.
  • To remove a user from all groups, right-click the user name and then click Assign user.
  • To remove a group from the database, right-click the group name and then click Remove group.
  • To remove a user from the database, right-click the user name and then click Remove user.

You can also use the editor to import users and groups from Planning Analytics Workspace or to create a new group on the Planning Analytics database.

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

IBM Planning Analytics Tips & Tricks: How to Make an MDX Statement Dynamic

IBM Planning Analytics Tips & Tricks: Approaches in Planning Analytics’ New Set Editor

Home » IBM Planning Analytics » Page 9

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

Revelwood’s Partners IBM and Workday Named Leaders in IDC Report

April 14, 2023 by Revelwood

FP&A Done Right

Two of Revelwood’s partners, IBM and Workday, have been named Leaders in the IDC MarketScape: Worldwide Enterprise Planning, Budgeting, and Forecasting Applications 2022 Vendor Assessment for IBM Planning Analytics and Workday Adaptive Planning. 

The report assessed 13 vendors in the market. In addition to IBM and Workday Adaptive Planning, IDC looked at Anaplan, Board International, insightsoftware, Planful, Prophix, OneStream, Oracle, SAP, Syntellis, Vena Solutions and Unit4. 

“We expect companies to continue to invest in modern enterprise planning, budgeting and forecasting applications to help them adapt to changes in the business environment and enhance agility to combat market volatility,” said Raymond Huo, senior analyst in IDC’s Business Analytics and Decisioning market research and advisory practice. 

This report is based on a “comprehensive and rigorous framework.” The vendors included in the report had to meet the following criteria:

  • Have standalone, packaged enterprise planning, budgeting and forecasting applications on the market
  • Meet the threshold of $50 million in enterprise planning, budgeting and forecasting software revenue in C&21 based on IDC’s Semiannual Software Tracker
  • Have market presence and momentum

Download this report for IDC’s viewpoint on IBM and Workday Adaptive Planning and to learn:

  • How disruption has impacted the market
  • Why differentiation in this market is challenging
  • The latest developments in software features
  • Why rapid innovation is expected to continue
Home » IBM Planning Analytics » Page 9

Filed Under: FP&A Done Right Tagged With: financial planning & analysis, IBM Planning Analytics, Workday, Workday Adaptive Planning

IBM Planning Analytics Tips & Tricks: Excel Tips, Part 3

April 11, 2023 by Revelwood

Revelwood’s IBM Planning Analytics team has created numerous tips & tricks focused on helping people use Excel. Over the next few weeks, we’ll be highlighting some of the most popular and interesting posts on Excel. If you’ve missed our earlier posts, read part 1 and part 2.

IBM Planning Analytics Tips & Tricks: Map Charts

Map charts is a nifty feature in Excel that will help visualize your data. It enables you to compare values and show categories across geographical regions.

Our blog post explains how you can use the Map Charts feature.

IBM Planning Analytics Tips & Tricks: Excel’s CONCAT and TEXTJOIN Functions

In recent years Microsoft introduced a new version of the CONCATENATE functional called CONCAT. Their purpose is similar in that the new function still combines text from multiple ranges and/or strings. CONCAT will eventually replace CONCATENATE.

The TEXTJOIN function joins text from multiple ranges and/or strings but includes two additional parameters. These parameters allow you to specific the delimiter and determine if empty cells are ignored. 

Learn more about Excel’s CONCAT and TEXTJOIN functions. 

IBM Planning Analytics Tips & Tricks: Excel’s IFS Function

Excel’s IF function has been around for quite a while. Back in 2020, Excel introduced the IFS function. This function checks whether one or more conditions are met and then returns the value associated with the first TRUE condition. The main objective of IFS is to simplify an expression that would have previously required multiple nested IF functions.Read our blog post to learn the format of the IFS function.

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: Excel Tips, Part 1

IBM Planning Analytics Tips & Tricks: Excel Tips, Part 2

IBM Planning Analytics Tips & Tricks: Excel EOMONTH

Home » IBM Planning Analytics » Page 9

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

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