• 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: Update on Planning Analytics’ Deprecation

February 4, 2025 by Revelwood

IBM recently made the End of Support dates for Planning Analytics 2.0.9.x official.

As we mentioned in our previous blog post on the deprecation of Planning Analytics 2.0.9.x, IBM is extending the general support period for Planning Analytics 2.0.9.x until October 31, 2025. This includes IBM Planning Analytics Local, IBM Planning Analytics Advanced and IBM Planning Analytics Express.

Now is the time for you to start thinking about your migration plan. The next ten months will pass by quickly.

Our team has created a few resources for you regarding the upcoming changes. They include:

  • IBM Planning Analytics Tips & Tricks: Upcoming Changes to Planning Analytics
  • IBM Planning Analytics Tips & Tricks: A Resolution You Should Actually Keep – Upgrade Your IBM Planning Analytics Environment
  • Understanding the Migration from Legacy TM1 to Planning Analytics (on-demand webinar)

We’re happy to work with you on your migration. Email us at info@revelwood.com.

Revelwood is an IBM Gold Business Partner with 25+ years of experience designing, developing, implementing and maintaining IBM Planning Analytics environments. Revelwood has helped clients in all sizes across all industries optimize and grow their use of Planning Analytics. Revelwood’s Planning Analytics team consists of experienced PA experts, including a multi-year IBM Champion.

Stay up to date with PA – sign up for our weekly Planning Analytics Tips & Tricks newsletter, subscribe to our YouTube channel, and join our IBM Planning Analytics All-Stars group on LinkedIn.

Home » IBM Planning Analytics » Page 2

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

IBM Planning Analytics Tips & Tricks: Unpivot

January 21, 2025 by Ivan Cepero

Did you know you can unpivot data in IBM Planning Analytics?

Sometimes you’ll find yourself in a situation where you need to change the layout of data from a grid format to a vertical table format, this is called unpivoting the data.

I’ll show you how to do this via some new Excel formulas.

Consider this sample data set:

A screenshot of a spreadsheet

Description automatically generated

The goal is to have a table with three columns: Invoice, Month, Data. Here’s how to do that step-by-step.

Step 1

Use the EXPAND formula to create an array of Invoices.  In this case, we are creating a 5 x 12 array (5 rows x 12 columns).

=EXPAND($A$2:$A$6,5,12)

This will generate this:

A white grid with black and green text

Description automatically generated

Step 2

EXPAND doesn’t know what to do with the other columns, so we can use IFERROR to fill in the errors with a specified value. In this case, if there’s an error then we want to replace the error with the first column value.

=IFERROR(EXPAND($A$2:$A$6,5,12),$A$2:$A$6)

Now we have this:

A screenshot of a computer

Description automatically generated

Step 3

Now we use the TOCOL function to make the grid of invoice numbers into a column

=TOCOL(IFERROR(EXPAND($A$2:$A$6,5,12),$A$2:$A$6))

That generates:

A number of binary code

Description automatically generated with medium confidence

Step 4

We repeat the previous steps for the months. We want an array of 12 x 5 for the months. The end formula is:

=TOCOL(IFERROR(EXPAND($B$1:$M$1,5),$B$1:$M$1))

Step 5

Use TOCOL on the data points to pivot them into a columnar format.

=TOCOL($B$2:$M$6)

Now we have a live, formula-based unpivot model that will refresh when the data is changed.

A screenshot of a spreadsheet

Description automatically generated

Bonus Tip!

You can make the formulas more dynamic by using COUNTA instead of hard coding the number of rows/columns in the EXPAND function.

Revelwood is an IBM Gold Business Partner with 25+ years of experience designing, developing, implementing and maintaining IBM Planning Analytics environments. Revelwood has helped clients in all sizes across all industries optimize and grow their use of Planning Analytics. Revelwood’s Planning Analytics team consists of experienced PA experts, including a multi-year IBM Champion.

Stay up to date with PA – sign up for our weekly Planning Analytics Tips & Tricks newsletter, subscribe to our YouTube channel, and join our IBM Planning Analytics All-Stars group on LinkedIn.

Read more IBM Planning Analytics Tips & Tricks:

IBM Planning Analytics Tips & Tricks: PAW Export Data

A Resolution You Should Actually Keep: Upgrade Your IBM Planning Analytics Environment

Popular IBM Planning Analytics Videos of 2024

Home » IBM Planning Analytics » Page 2

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

IBM Planning Analytics Tips & Tricks: PAW Export Data

January 14, 2025 by Lee Lazarow

Tips & Tricks from Revelwood

While IBM Planning Analytics is an excellent database that allows you to easily slice and dice your data, there may be situations where you want to export data from the model.  Maybe you want to share information with someone who uses different software or maybe you want to use your data in another tool? PAW version 99 introduced the ability to export a data set from the PAW interface.

To export data, right-click on a cube within a modeling workbench, select the option to Import/Export and then select the option to Export Data.  

Once selected, you will be prompted to define the name of the .csv file that will be created.  You then can define the data to be exported by using an existing view and/or by defining the dimension details. For each dimension, you can define a hierarchy to use, a subset to use, or an element to use.

A screenshot of a computer

Description automatically generated

You also have the ability to define filters for your numeric and string data (example: only show values greater than or equal to 100) and the ability to skip consolidated values, rule calculated values, and zero/blank values.

Revelwood is an IBM Gold Business Partner with 25+ years of experience designing, developing, implementing and maintaining IBM Planning Analytics environments. Revelwood has helped clients in all sizes across all industries optimize and grow their use of Planning Analytics. Revelwood’s Planning Analytics team consists of experienced PA experts, including a multi-year IBM Champion.

Stay up to date with PA – sign up for our weekly Planning Analytics Tips & Tricks newsletter, subscribe to our YouTube channel, and join our IBM Planning Analytics All-Stars group on LinkedIn.

Read more IBM Planning Analytics Tips & Tricks:

A Resolution You Should Actually Keep: Upgrade Your IBM Planning Analytics Environment

Popular IBM Planning Analytics Videos of 2024

IBM Planning Analytics Tips & Tricks: PAW Export Dim Structure

Home » IBM Planning Analytics » Page 2

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

A Resolution You Should Actually Keep: Upgrade Your IBM Planning Analytics Environment

January 7, 2025 by Revelwood

Did you know that almost 80% of all New Year’s resolutions are associated with health?  As an IBM Planning Analytics user, it’s important to also think about your system’s health! This is why you should put “upgrading Planning Analytics” on your list of resolutions. Here’s why …

IBM recently announced some changing timelines to the forthcoming deprecation of Planning Analytics 2.0.9.x. For background, read our blog post, IBM Planning Analytics Tips & Tricks: Upcoming Changes to Planning Analytics, or watch our on-demand webinar, Understanding the Migration from Legacy TM1 to Planning Analytics. 

Key Updates

  • IBM is extending the general support period for Planning Analytics 2.0.9.x until October 31, 2025.
  • Users can purchase extended support from IBM for an additional year through October 31, 2026.
  • Planning Analytics 2.1.x is now supported until April 30, 2027.

Implications for Users

Staying on unsupported versions can expose organizations to security vulnerabilities, lack of technical support and missed opportunities for leveraging new functionalities. You should assess your current Planning Analytics environment and develop a roadmap for upgrading to supported versions.

Recommended Actions

  1. 1. Evaluate Current Usage: Understand how your organization uses Planning Analytics and identify any customizations or dependencies that may affect the upgrade process.
  2. 2. Plan the Upgrade: Develop a comprehensive plan that includes timelines, resource allocation and testing phases to ensure a smooth transition.
  3. 3. Engage with Revelwood: We can help you access support resources and documentation to assist with the upgrade process and address any challenges that come up.

By proactively addressing these end-of-support dates, organizations can maintain the integrity of their financial planning systems and continue to benefit from IBM’s advancements in Planning Analytics.Need help?

Send a quick note to: info@revelwood.com.

Home » IBM Planning Analytics » Page 2

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

Popular IBM Planning Analytics Videos of 2024

December 31, 2024 by Revelwood

We all love analytics, right? We took a look at the analytics on our videos to see which ones you and your peers watched the most. Here are our most popular IBM Planning Analytics videos – both on-demand webinars and Tips & Tricks:

1. Understanding the New Planning Analytics Engine in IBM Planning Analytics

Planning Analytics Engine is the next version of IBM’s cloud-based Planning Analytics environment. The Engine uses Planning Analytics’ existing modeling and reporting approaches while also simplifying administrative functionality such as backups and database resource maintenance. Watch this on-demand webinar to learn about the new Planning Analytics Engine.

2. IBM Planning Analytics Tips & Tricks: Create Database

Learn how to create a database efficiently. This video provides a step-by-step guide to setting up your database, ensuring a solid foundation for your data analysis and planning activities. Whether you are a beginner or are looking to refine your skills, these tips will help you create a robust and organized database.

3. IBM Planning Analytics Tips & Tricks: File Manager

In this video, we guide you through efficiently managing your files, streamlining your workflow and enhancing your data organization.

4. IBM Planning Analytics Tips & Tricks: Backups

Watch this video to learn effective backup strategies to ensure your valuable information is always safe and recoverable.

5. IBM Planning Analytics Tips & Tricks: High Availability

Ensure uninterrupted access and seamless performance with our high availability tips to IBM Planning Analytics. Watch this video to learn essential strategies to maintain system resilience and reliability, which helps you to avoid downtime and keep your data secure.

Revelwood is an IBM Gold Business Partner with 25+ years of experience designing, developing, implementing and maintaining IBM Planning Analytics environments. Revelwood has helped clients in all sizes across all industries optimize and grow their use of Planning Analytics. Revelwood’s Planning Analytics team consists of experienced PA experts, including a multi-year IBM Champion.

Stay up to date with PA – sign up for our weekly Planning Analytics Tips & Tricks newsletter, subscribe to our YouTube channel, and join our IBM Planning Analytics All-Stars group on LinkedIn.

Read more IBM Planning Analytics Tips & Tricks:

IBM Planning Analytics Tips & Tricks: PAW Export Dim Structure

IBM Planning Analytics Tips & Tricks: PAW Selector Menu

IBM Planning Analytics Tips & Tricks: PAW Thumb Cell Formatting

Home » IBM Planning Analytics » Page 2

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

Meet Emery Sinclair, Revelwood’s Vice President of Client Success

December 19, 2024 by Revelwood

Emery Sinclair recently rejoined Revelwood as our new vice president of client success. Previously, he spent eight years serving as Revelwood’s director of solutions and strategy. We sat down with Emery to learn his vision for this new role and why he returned to Revelwood.

Q: Welcome back! Tell us about your new role.

Emery: Thanks. I’m responsible for overseeing and expanding our Client Success team. Our goals are to optimize the client experience by expanding our service offerings and driving product adoption. We want to make sure our clients get the full benefits they expect from their investments in technology for the Office of Finance. 

Currently our clients receive complimentary training, free system performance tune-ups, access to open Q&A sessions and exclusive content. We plan on expanding our offerings. At Revelwood we say – and we mean it – that we have our clients’ backs. Our Client Success team will put even more processes and thought around how we do that.

Q: What have you been doing in between your time with us?

Emery: I’ve focused on client success. I’ve had the opportunity to work with startups that were headquartered outside of the U.S. This has given me an interesting perspective on how to work with organizations of all sizes to partner for success. Success not just in selling software, but in actually working toward long-term relationships with our clients. As one Revelwoodian recently said, “We don’t just deliver [an implementation] and run away. In fact, we do the opposite of that. 

Q: Why did you decide to return to Revelwood?

Emery: Revelwood has nearly quadrupled in size since I left in 2014. There’s a significant amount of growth in the financial planning software market and related technologies for the Office of Finance. Revelwood has the right people and the right experience to capitalize on this fast-growing market.

Revelwood also has a client base of raving fans. That’s a great starting point for my goals for the Client Success team. We’re not just a service provider, we are a vested advocate that helps them achieve their goals for transforming the Office of Finance. 

And, they are great people!

Learn more about Emery – read the press release and connect with him on LinkedIn.

Home » IBM Planning Analytics » Page 2

Filed Under: News & Events Tagged With: BlackLine, Financial Performance Management, IBM Planning Analytics, Workday, Workday Adaptive Planning

Meet Dino Daddona, Revelwood’s New Vice President of Sales, Americas

December 18, 2024 by Revelwood

Dino Daddona was recently named Revelwood’s vice president of sales, Americas. We sat down with him to learn more about his thoughts on Revelwood.

Q: Why did you choose to join Revelwood?

Dino: The majority of my career has been in roles selling to the Office of Finance. So it was functionally a good fit. More importantly, though, Revelwood is in a unique position in the market. The company is on a rapid growth trajectory and has a legacy of success helping clients transform financial performance and operations. That makes Revelwood a rare find.

Many Revelwoodians have been with the company for many years. That is a sign of a great company. It is a testament to the quality of the leadership, the commitment to individuals’ success and its commitment to the company’s Core Values. 

Q: What do you see as Revelwood’s opportunity in the market?

 Dino: There is a massive opportunity to help companies transform their Office of Finance. According to Gartner’s Magic Quadrant for Financial Planning Software, “Organizations are increasingly seeking efficient, agile planning and management to respond to market changes.” Frankly, nearly every organization now faces “market changes” on a regular basis. This means that companies – and they are many of them – that still use spreadsheets for budgeting and planning need to modernize their finance operations now. 

Workday Adaptive Planning is one of the best financial planning solutions on the market. Revelwood is the leading Workday Adaptive Planning partner in the Americas. Additionally, Revelwood has decades of experience (and awards to prove it!) partnering with IBM. We’ve also received awards from our partner BlackLine.

We are perfectly positioned for exponential growth in the market.

Q: What will you be doing in this new role?

Dino: I’m Revelwood’s first vice president of sales, Americas. I oversee our Sales and Pre-sales teams. These teams are a mix of Revelwood veterans and new team members, some of whom are just entering the workplace. Having a diverse team means that we can leverage both experience and new ideas. 

My role also includes strengthening relationships with our partners. Our partnerships are not just traditional technology “Barney hugs.” We invest in training and certifications from our partners. We’re not generalists – we are experts in technology for the Office of Finance. It’s important that our partners understand how committed we are to mutual success.Learn more about Dino.

Read the press release and check him out on LinkedIn.

Home » IBM Planning Analytics » Page 2

Filed Under: News & Events Tagged With: BlackLine, Financial Performance Management, IBM Planning Analytics, Workday, Workday Adaptive Planning

IBM Planning Analytics Tips & Tricks: PAW Export Dim Structure

December 17, 2024 by Lee Lazarow

Have you ever wanted to export a dimensional structure to an ASCII based text file in IBM Planning Analytics Workspace (PAW)? PAW version 99 introduced the ability to export a dimension with a single click.

To export a dimension, right-click on the dimension name within a modeling workbench and select the option to Export members.  

Once selected, you will be prompted to define which hierarchy to export and the name of the csv file that will be created. The resulting file will contain the following information for each element:

  • Name
  • Parent (root elements will have a blank parent field)
  • Type
  • Weight
  • All defined attribute names and values (the attribute name will be prefixed with ATTR_N or ATTR_S to define the attribute as numeric or string)

Here is a snippet of an export file that shows a header record, a consolidated element, and two children:

“Member”,”Parent”,”Type”,”Weight”,ATTR_S_Manager”,”ATTR_S_Currency”

“Total Company”,””,”Consolidated”,”0″,”Total”,””

“001”,”Total Company”,”Numeric”,”1″,”John Smith”,”USD”

“002”,”Total Company”,”Numeric”,”1″,”Jane Doe”,”USD”

This feature will allow you to export your dimensional structures to files that can be used for reporting, auditing, and other areas where you need to display your structural information.

Revelwood is an IBM Gold Business Partner with 25+ years of experience designing, developing, implementing and maintaining IBM Planning Analytics environments. Revelwood has helped clients in all sizes across all industries optimize and grow their use of Planning Analytics. Revelwood’s Planning Analytics team consists of experienced PA experts, including a multi-year IBM Champion.

Stay up to date with PA – sign up for our weekly Planning Analytics Tips & Tricks newsletter, subscribe to our YouTube channel, and join our IBM Planning Analytics All-Stars group on LinkedIn.

Read more IBM Planning Analytics Tips & Tricks:

IBM Planning Analytics Tips & Tricks: PAW Selector Menu

IBM Planning Analytics Tips & Tricks: PAW Thumb Cell Formatting

IBM Planning Analytics Tips & Tricks: PAW Exploration Icons

Home » IBM Planning Analytics » Page 2

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

IBM Planning Analytics Tips & Tricks: PAW Selector Menu

December 10, 2024 by Lee Lazarow

Tips & Tricks from Revelwood

You may already know that you can create a selector widget in IBM Planning Analytics Workspace (PAW) by simply dragging a context dimension outside your existing view. Once synchronized, this approach provides an easy way to create independent selectors that can be used with your existing PAW data pulls.

But what do you do in a situation when you have already hidden your exploration overview or converted your exploration into a chart? One approach is to reset the visualization into a fully expanded exploration, drag the dimension, and re-format the visualization. But did you know that an easier way exists?

PAW version 99 introduced an option to add a selector directly from the data tree (e.g., the left pane). This can be accessed by simply right-clicking on a dimension in the tree. Once selected, there will be two options: add selector tile and add selector list.

There are three types of tiles: single tile, multiple tiles, and range selection tile. There are three types of lists: single list, multiple lists and multiple selection list.

Once created, the properties area will allow you to define appearance aspects such as colors, fonts, and header information.

This approach will allow you to create easy-to-use selectors without having to undo any existing formatting that has been created.

Revelwood is an IBM Gold Business Partner with 25+ years of experience designing, developing, implementing and maintaining IBM Planning Analytics environments. Revelwood has helped clients in all sizes across all industries optimize and grow their use of Planning Analytics. Revelwood’s Planning Analytics team consists of experienced PA experts, including a multi-year IBM Champion.

Stay up to date with PA – sign up for our weekly Planning Analytics Tips & Tricks newsletter, subscribe to our YouTube channel, and join our IBM Planning Analytics All-Stars group on LinkedIn.

Read more IBM Planning Analytics Tips & Tricks:

IBM Planning Analytics Tips & Tricks: PAW Thumb Cell Formatting

IBM Planning Analytics Tips & Tricks: PAW Exploration Icons

IBM Planning Analytics Tips & Tricks: High Availability in Version 12

Home » IBM Planning Analytics » Page 2

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

  • « Go to Previous Page
  • Page 1
  • Page 2
  • Page 3
  • Page 4
  • 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.