• 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: Using the Subset Editor in Planning Analytics Workspace

December 12, 2023 by Revelwood

In the past, manipulating subsets in IBM Planning Analytics Workspace (PAW) involved a convoluted process of copying, creating new sets, and pasting elements. The subset editor solves this problem. The subset editor enables you to perform multiple tasks with a single click.

Watch this short IBM Planning Analytics Tips & Tricks video to see Lee Lazarow, Revelwood’s IBM Planning Analytics practice leader, demonstrate how to easily grab an element, its children, siblings, parents and descendants. 

Previously, manipulating subsets focused on the left side of navigation. Inserting elements or expanding to children or descendants was confined to this area, creating limitations in functionality. Planning Analytics, version 88, extended the subset editor’s manipulation functionality. Now users can easily expand or keep elements with a single click!

By right-clicking on an element, users can choose between options like “expand to” or “keep with.” This newfound flexibility allows for expanding to descendants, ancestors, parents, siblings, or any combination, all with a single click.

This new functionality makes the process of manipulating subsets more intuitive and efficient. You can easily work with children, siblings, parents, or any combination of them.

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: Planning Analytics Workspace (PAW) Region Expansion

IBM Planning Analytics Tips & Tricks: How to Determine when Users Logged in to Planning Analytics Workspace

IBM Planning Analytics Tips & Tricks: Excel Substitute Function

Home » TM1 » Page 6

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: Planning Analytics Workspace (PAW) Region Expansion

November 28, 2023 by Lee Lazarow

A while back I wrote a blog about regions within regions in IBM Planning Analytics. This approach allows you to make your rules easier to navigate and read when scrolling through many lines of code.  

As you create regions, you can expand and contract lines of code by clicking the arrow next to the applicable lines. Here is an example of a contracted region (line 1) and an expanded region (line 6):

Text

Description automatically generated

But did you know that Planning Analytics Workspace allows you to expand or contract all regions at the same time? The workbench ribbon contains icons to expand (called “unfold”) and contract (called “Fold”) all regions with a single click.The left icon below is used for expansion and the right icon below is used for contraction.

Here is an example of 15 lines of code with the use of regions.

Text

Description automatically generated with medium confidence

This approach will allow you to reduce your screen footprint and make it even easier to quickly navigate through your code.  

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: Cell Security in Planning Analytics Workspace

IBM Planning Analytics Tips and Tricks: Trusting the Directory where the Planning Analytics for Excel xll file resides

IBM Planning Analytics Tips & Tricks: Planning Analytics Workspace (PAW) Process Error Logs

Home » TM1 » Page 6

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

IBM Planning Analytics Tips & Tricks: How to Determine when Users Logged in to Planning Analytics Workspace

November 14, 2023 by Revelwood

Have you ever wanted to learn when a user last logged in to IBM Planning Analytics Workspace (PAW)? Or to generate a list of dates and times when users logged in?

IBM Planning Analytics version 87 includes a feature to easily figure out the last login time of your PAW users.

Watch this short video from Lee Lazarow, Revelwood’s Planning Analytics practice lead. You’ll see Lee demonstrate how to:

  • Find ‘Users and Groups’, which contains the date and time of logins.
  • Download that information into a CSV file you can save
  • Learn the roles, dates and times of logins

This approach gives us the ability to quickly create a list of all of our users and for each one of our users, a date and time associated with the last login.

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: Cell Security in Planning Analytics Workspace

IBM Planning Analytics Tips and Tricks: Trusting the Directory where the Planning Analytics for Excel xll file resides

IBM Planning Analytics Tips & Tricks: Planning Analytics Workspace (PAW) Process Error Logs

Home » TM1 » Page 6

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

IBM Planning Analytics Tips & Tricks: Excel Substitute Function

October 31, 2023 by Ivan Cepero

Are you familiar with the SUBSTITUTE function in Excel? The SUBSTITUTE function in Excel replaces one value with another. This is similar to the REPLACE function, but SUBSTITUTE provides more flexibility.

The syntax of the SUBSTITUTE function is:

=SUBSTITUTE(text,old_text,new_text,instance_num)

  • Text: This is the text to be evaluated and changed
  • Old_text: This is the subtext to be replaced.
  • New_text: This will be used as the replacement.
  • Instance_num (optional): This defines which occurrence of old_text to replace.  If this value is blank then all occurrences of old_text will be replaced.

Here are two examples of the substitute function:

Example 1:

This formula removes the second dash from the account string.

Graphical user interface, application

Description automatically generated

Example 2:

To count the number of dashes in a cell, this formula subtracts the length of the cell without dashes from the original length of the cell.

Graphical user interface, application

Description automatically generated

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: Planning Analytics Workspace (PAW) Process Error Logs

IBM Planning Analytics Tips & Tricks: Adding Images to Charts

IBM Planning Analytics Tips & Tricks: Popular Video Tips, Part 3

Home » TM1 » Page 6

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

IBM Planning Analytics Tips & Tricks: Cell Security in Planning Analytics Workspace

October 17, 2023 by Revelwood

In our latest IBM Planning Analytics tips & tricks video, Lee Lazarow, Revelwood’s IBM Planning Analytics practice lead, explains and demonstrates cell security in IBM Planning Analytics (PAW). Cell security is a critical aspect of data management, providing control access to specific data points within PAW cubes. 

Watch this video and learn how to:

  • Determine the cube you want to add security to
  • Choose the dimensions
  • Create the cell security
  • Define security manually
  • Automate security with rules
  • Save and apply rules
  • Make modifications

In conclusion, cell security in IBM Planning Analytics is a powerful tool for managing data access. By following these steps, you can efficiently define and implement security measures that align with your specific needs. PAW offers a versatile platform for ensuring data integrity, whether through manual adjustments or automated rules.

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: Planning Analytics Workspace (PAW) Process Error Logs

IBM Planning Analytics Tips & Tricks: Adding Images to Charts

IBM Planning Analytics Tips & Tricks: Popular Video Tips, Part 3

Home » TM1 » Page 6

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 and Tricks: Trusting the Directory where the Planning Analytics for Excel xll file resides

October 3, 2023 by Marc Assenza

Have you ever received a notification from Excel stating that it was having an issue trusting the Planning Analytics for Excel (PAfe) Add-In?  If so, you are not alone! 

From time to time, it seems Excel needs to be reminded that the .xll file is a trusted file. To do this you will need to take the following steps:

Open Microsoft Excel and click on File, Options.

When the next screen appears, select “Trust Center” on the left-hand side pane and then “Trust Center Settings” on the right-hand side.

A screenshot of a computer

Description automatically generated with medium confidence

Next, click on the link that reads “Trusted Locations.”

A screenshot of a computer error message

Description automatically generated with low confidence

On the bottom right of the screen, click the button that says “Add new location.”

A yellow box with black text

Description automatically generated with low confidence

Browse to the drive and folder where your PAX xll file is located and define this as your path. Within the same window, also click the checkbox that allows subfolders to also be trusted.

A screenshot of a computer error message

Description automatically generated with medium confidence

Once complete, your Planning Analytics for Excel .xll file will be trusted. 

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: Planning Analytics Workspace (PAW) Process Error Logs

IBM Planning Analytics Tips & Tricks: Adding Images to Charts

IBM Planning Analytics Tips & Tricks: Popular Video Tips, Part 3

Home » TM1 » Page 6

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

IBM Planning Analytics Tips & Tricks: Planning Analytics Workspace (PAW) Process Error Logs

September 26, 2023 by Lee Lazarow

Do you know how to use IBM Planning Analytics Workspace (PAW) to access error logs from your TurboIntegrator (TI) processes? It’s as simple as a single click!

To access your logs, right-click on the Processes node in the workbench and select the option for Error logs.

Once selected, a popup window will appear with a list of the existing logs. This window allows you to sort the list by process name or by date created.

There are two ways to view a log file:

  • Click on the box to the left of the process name
  • Click on the three vertical dots to the right of the date

Both methods will then let you view the log file or download the file.

This feature, when combined with PAW’s development tools, will allow you to fully develop and debug TurboIntegrator scripts using the PAW interface.

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: Adding Images to Charts

IBM Planning Analytics Tips & Tricks: Popular Video Tips, Part 3

IBM Planning Analytics Tips & Tricks: Counting Hidden Rows in Excel

Home » TM1 » Page 6

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

IBM Planning Analytics Tips & Tricks: Adding Images to Charts

September 12, 2023 by Ivan Cepero

Charts are an excellent way to use visuals to convey information. Did you know that you can increase the effect of charts in Excel by adding custom images?

Consider this plain pie chart.

Chart, pie chart

Description automatically generated

We can insert a corporate logo to give the chart a greater visual appeal and branding.

1 – Click on the chart to select it

2 – Right click and select “Format Chart Area”

3 – Select “Picture or texture fill”

A screenshot of a phone

Description automatically generated with medium confidence

4 – Select “Insert” to insert an image from your computer or “Clipboard” to insert a previously copied image

When clicking “Insert” you will see a pop up letting you pick various image sources.

Text

Description automatically generated

5 – You can further refine the options by having the image tile, offset or scale.

Here is the updated chart with the Revelwood logo applied, tiled and set with transparency level 80%:

Chart, pie chart

Description automatically generated

You can also apply custom images to a specific data point (e.g. a pie slice in this example) by initially selecting the data point instead of the entire chart, then following the steps outlined above.

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: Popular Video Tips, Part 3

IBM Planning Analytics Tips & Tricks: Counting Hidden Rows in Excel

IBM Planning Analytics Tips & Tricks: Popular Video Tips, Part 2

Home » TM1 » Page 6

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

IBM Planning Analytics Tips & Tricks: Popular Video Tips, Part 3

August 29, 2023 by Ivan Cepero

Here are two more popular IBM Planning Analytics Tips & Tricks videos. Did you know we have an entire library of video tips & tricks for IBM Planning Analytics?

The Aggregate Function

In this video, Revelwood’s FP&A Technology Director, Lee Lazarow, demonstrates the aggregate function. The aggregate function allows you to summarize values that cannot be added up or averaged. 

Creating Multi-Level Dimensions

Watch this video to learn how to create multi-level dimensions in Planning Analytics. This approach will let you create brand-new dimensions by simply dragging a file onto the screen. You’ll learn how to create a brand-new dimension using a file created in Notepad. See how Planning Analytics recognizes that the list is more than a list of leaf levels and more than just a parent/child relationship. You’ll also learn how to map the levels and add attributes.

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: Expanding Sections of Stacked Dimensions

IBM Planning Analytics Tips & Tricks: Creating Charts in Planning Analytics Workspace 

IBM Planning Analytics Tips & Tricks: Excel’s Camera Tool

Home » TM1 » Page 6

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

  • « Go to Previous Page
  • Page 1
  • Interim pages omitted …
  • Page 4
  • Page 5
  • Page 6
  • Page 7
  • Page 8
  • 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.