• 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: Fixing Repetitive Scripts

May 28, 2024 by Revelwood

This post is the latest post in our new blog series: How We Solve Problems. Each blog post focuses on a real-world client experience where Revelwood was presented with a unique or thorny problem.  We’ll explain our approach to how we solved it.

Revelwood Client: A financial services company specializing in retirement and life insurance.

Planning Environment: IBM Planning Analytics

Problem: A review of their existing TurboIntegrator scripts found that many of their processes used pre-built source views. Each view differed only slightly. For example, one view would define subsets in approximately eight dimensions and focus on a single time period, while a second view would contain the same subsets and focus on a different time period. This approach led to more than 50 repetitive scripts that were run via chores.

How We Helped: We changed the approach to create a source view in the prolog. This allowed a single script to be run over and over via parameters that were defined during each iteration. This resulted in faster maintenance since changes only had to be coded once.  It also ensured that changes to public views and subsets would not impact these scripts.

Do you have a challenge with your Planning Analytics environment? Let us tackle the problem! Send us a quick email!

Home » TM1 » Page 4

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

IBM Planning Analytics Tips & Tricks: PAW Border Lines

May 21, 2024 by Lee Lazarow

The great thing about explorations is that data appears in a simple grid-like format. This allows you to easily look at your data in an easy-to-read format that is similar to an Excel spreadsheet.

In the example below, it’s easy for your eyes to move up and down to see the expenses and then move left and right to see the departments. And since each data point is within its own box, it’s easy for your eyes to know when to stop.

A screenshot of a table

Description automatically generated

However, the use of boxes for the data also puts boxes in the headers. For some people, the lack of symmetry does not matter. But for those who do not like this look, you can turn off all border lines via a single click within the “Custom” properties of an exploration:

A screenshot of a computer

Description automatically generated

Disabling the border will convert the example above into a display with no lines in either the data or the headers.

A screenshot of a graph

Description automatically generated

Once completed, you can also set the formatting to shade every other line using an approach called “Zebra Strips”.

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: How We Solve Problems

IBM Planning Analytics Tips & Tricks: Identifying a Specific Dimension

IBM Planning Analytics Tips & Tricks: Asymmetrical Expand in PAW

Home » TM1 » Page 4

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

IBM Planning Analytics Tips & Tricks: How We Solve Problems

May 14, 2024 by Revelwood

This post is the first post in our new blog series: How We Solve Problems. Each blog post focuses on a real-world client experience where Revelwood was presented with a unique or thorny problem.  We’ll explain our approach to how we solved it.

Revelwood Client: A publicly traded television broadcasting company that owns and operates more than 175 stations across the United States.

Planning Environment: IBM Planning Analytics

Problem: The company’s budgeting process was very granular and plans down to the individual employee. The calculations in the model include detailed benefits and taxes, combined with multiple bonus calculations that depend on results from the core financial model. Due to the size and complexity of the process, “top of the house” reports took more than 10 minutes to properly refresh.

How We Helped: Revelwood analyzed the existing calculations and the interaction of the various models to determine an efficient order of processing. Due to the need for an order of operations, many of the live rules were converted into on-demand TurboIntegrator scripts. This approach shrunk an individual company’s refresh time from one minute down to a few seconds while also bringing the “top of the house” analysis down to under 20 seconds.

Do you have a challenge with your Planning Analytics environment? Let us tackle the problem!

Send us a quick email!

Home » TM1 » Page 4

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

IBM Planning Analytics Tips & Tricks: Identifying a Specific Dimension

May 7, 2024 by Lee Lazarow

Tips & Tricks from Revelwood

Have you ever wanted to change (or delete) a dimension, but first wanted to know how this action will impact your model?  IBM Planning Analytics Workspace (PAW) allows you to quickly identify all the cubes in a database that include a specific dimension.

Since this is a development task, this approach is defined within a modeling workbench.  You can access this option by right-clicking anywhere you see a dimension name within the databases tree (cubes, dimensions, control cubes, and control dimensions) and selecting the option to “View related cubes.”  

The resulting list will define the full dimension name (e.g., not the caption) and show all the cubes that include the selected dimension.  

A screenshot of a computer

Description automatically generated

If you want to better understand the data in the cube, you can then review any of them by clicking on the cube name and then selecting the option to Open the cubes. An exploration view for each cube will open on separate tabs in the modeling workbench.

This approach will give you a fast way to determine the overall impact of a dimension change.

Read more IBM Planning Analytics Tips & Tricks:

IBM Planning Analytics Tips & Tricks: Asymmetrical Expand in PAW

IBM Planning Analytics Tips & Tricks: PAW Greenbar

IBM Planning Analytics Tips and Tricks: Excel’s ARRAYTOTEXT Function

Home » TM1 » Page 4

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

IBM Planning Analytics Tips & Tricks: Asymmetrical Expand in PAW

April 30, 2024 by Marc Assenza

Have you ever been in a situation where you have stacked dimensions in your view and only want to expand one section of it? In legacy Perspectives, an expansion of one area equates to an expansion of all areas. IBM Planning Analytics Workspace (PAW), version 87, introduced functionality that allows you to expand just one piece at a time.

Here is an example of a simple view that shows Actual Finance expenses by Company.

Table

Description automatically generated

By default, an expansion of the Finance department would show an expansion for all three companies.

Table

Description automatically generated

A new icon has been added that will allow you to determine how you want to expand and collapse the elements within your view.  

When clicked, you will have two options: Symmetrical and Asymmetrical.  

Text

Description automatically generated with medium confidence

If we change the approach to Asymmetrical and then expand the departments within company 2, only a subset of the full view is expanded.

Table

Description automatically generated

This approach will allow you to tighten your analysis and let your users focus on a subsection of your view while still easily having the ability to see the big picture.

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 “Spacers”

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

IBM Planning Analytics Tips & Tricks: Excel Switch Function

Home » TM1 » Page 4

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

IBM Planning Analytics Tips & Tricks: PAW Greenbar

April 16, 2024 by Lee Lazarow

Have you ever generated an IBM Planning Analytics Workspace (PAW) exploration and struggled to read the values in the grid? For example, how easy is it to define the travel cost for department 55 in the screenshot below?

A screenshot of a graph

Description automatically generated

A few years ago, I wrote a blog post about solving this in Excel by using formulas to shade every other row. This approach is built into PAW via an option called “Zebra strips.” You can enable this option within the Custom properties of an exploration:

A screenshot of a computer

Description automatically generated

Once enabled, PAW will lightly shade every other row to allow you to quickly navigate through your exploration. Using the example from earlier, it is now much easier to define the travel cost for department 55.

A table with numbers and a number of sales

Description automatically generated with medium confidence

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 “Spacers”

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

IBM Planning Analytics Tips & Tricks: Excel Switch Function

Home » TM1 » Page 4

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

IBM Planning Analytics Tips and Tricks: Excel’s ARRAYTOTEXT Function

April 2, 2024 by Ivan Cepero

Have you ever needed to export Excel data in a format that can be read by other systems?  Although csv files are widely accepted, many legacy systems expect data in an array format. This can be done using the ARRAYTOTEXT formula in Excel.

The syntax of the ARRAYTOTEXT formula is:

=ARRAYTOTEXT(array, format)

  • Array: the text to convert to an array
  • Format: the format to apply on conversion
    • The only valid values for this parameter are 0 and 1

A standard array format uses a set structure:

  • The array enclosed by curly braces. 
  • All items in the same row are separated by commas
  • The end of a row is indicated by a semicolon

For example, this data set …

A screenshot of a computer

Description automatically generated

 

… would appear like this in array notation:

{“Row1Col1″,”Row1Col2″;”Row2Col1″,”Row2Col2”}

However, the function does not force you to use the standard array format.  Using the following table as an example:

A screenshot of a computer

Description automatically generated

Format = 0 (also called the concise format) will join all the data into a single comma delimited list, similar to the TEXTJOIN formula.

A screenshot of a computer

Description automatically generated

Format 1 (also called strict format) will convert the data into an array format.  Every item on the same row is separated by a comma and the end of a row is indicated by a semicolon.

A screenshot of a computer

Description automatically generated

As an added feature, the ARRAYTOTEXT formula detects data types and does not convert the numbers to text (numbers are not enclosed by quotation marks).

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 “Spacers”

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

IBM Planning Analytics Tips & Tricks: Excel Switch Function

Home » TM1 » Page 4

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

IBM Planning Analytics Tips & Tricks: PAW “Spacers”

March 19, 2024 by Lee Lazarow

Tips & Tricks from Revelwood

Have you ever created an exploration in IBM Planning Analytics Workspace (PAW) that contains a lot of data and wish that you could separate the information? PAW allows you to insert blank rows and columns called “spacers” into your exploration.

Here is an example of a grid that shows expenses by company:

A screenshot of a graph

Description automatically generated

This subset of data is not very large, but it’s somewhat difficult to differentiate the totals from the details within the grid. This is an example where spacers can help.

You can insert a space by simply right-clicking on the area where you want to insert the blank row or column and then selecting the option to “Add spacers.” You can insert the spacer before or after the area that was clicked.

Here is the same example after inserting a blank row that separates the total expense value from the account values:

A screenshot of a computer screen

Description automatically generated

From there, we can adjust the size of the spacer and update the formatting of the top row to make the total values stand out. 

This approach will help make it easier for you to create easy-to-read explorations for your users.

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 Switch Function

IBM Planning Analytics Tips & Tricks: PAW Generated Statements

IBM Planning Analytics Tips & Tricks: PAW Pie Chart Total

Home » TM1 » Page 4

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

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

March 5, 2024 by Lee Lazarow

Most standard financial reports round to some form of a large value. For example, the report may show numbers in millions or rounded to the nearest 100,000.

This is done in Excel via the ROUND function. The function has two parameters:

=ROUND(number, num_digits)

  • The number defines the initial value to be rounded
  • The number of digits determines how many digits to round the number

Here is an example of a large value with various rounding results:

Table

Description automatically generated

But did you know that you have a variety of options for the number of digits?  

  • A positive value rounds to the nearest applicable decimal
  • A zero value rounds to the nearest integer
  • A negative value rounds to the left of the decimal point

Here is the same example using negative rounding:

Graphical user interface, table, Excel

Description automatically generated

This approach could also be used to round to the nearest thousand (-3) or the nearest million (-6).  

In addition, Excel offers two other options: ROUNDUP and ROUNDDOWN.  

  • ROUNDUP will always round away from zero (e.g., round up)
  • ROUNDDOWN will always round toward from zero (e.g., round down)

By using a combination of the appropriate ROUND function and a positive/negative number, you can ensure that all your reports show the values you want users to see.

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 Switch Function

IBM Planning Analytics Tips & Tricks: PAW Generated Statements

IBM Planning Analytics Tips & Tricks: PAW Pie Chart Total

Home » TM1 » Page 4

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

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