• 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

lee lazarow

IBM Planning Analytics Workspace (PAW) Version 2.0.57 Release

October 16, 2020 by Lee Lazarow Leave a Comment

Tech Bulletins

IBM recently released Version 2.0.57 of Planning Analytics Workspace (PAW). Version 2.0.57 is currently offered as a local-only release and will soon be available on the cloud (as version 2.0.58). This update contains many significant changes, including both new functionality and a different look and feel.

Some of these changes include:

Overall Interface

An updated Planning Analytics Workspace user interface provides a more consistent experience with other IBM products. This includes a new home page that is customized for your role within PAW and new icons that can be used to simplify the user experience.

Planning Analytics Workspace_v2.0.57

Predictive Forecasting

The introduction of Predictive forecasting allows you to easily model trends, seasonality, and time dependence in your data. If you are familiar with time series modeling then you can view details associated with the model type, model parameters, and accuracy measures. If you are not familiar with time series modeling, then AI driven model selection and tuning will assist you. The resulting data will provide both forecasted values and confidence boundaries.

IBM Planning Analytics Workspace (PAW) v2.0.57

New Organizational Approaches

Applications help you easily group together PAW assets such as books, views, and websheets. This approach can be used to help you organize assets in ways related to the structure of your organization. This is like the legacy Applications folder that exists in TM1.

IBM releases Planning Analytics Workspace v2.0.57

New Workflow Approaches

Plans allow an administrator to create a step by step walk through of your business processes. This will help end users better understand and follow the steps within your process. This will also minimize the times for users to find their required reports and templates.

Learn about IBM Planning Analytics Workspace (PAW) v2.0.57

Book and Visualization Improvements

New properties and drag-and-drop approaches give you more control over the objects within a book while still offering an easy way to create each component. IBM has also expanded the available set of visualizations, including the addition of waterfall charts and multi-line column charts.

Get info on IBM Planning Analytics Workspace (PAW) v2.0.57

Updated Administration

An updated administration page allows you to quickly see an overview of your databases, users, and groups on a single page.

Understanding IBM Planning Analytics Workspace (PAW) v2.0.57

The Ability to Enable the New Features

Version 58 will allow administrators and users to preview the new features.  Administrators will be able to enable preview mode and users will be able to “Return to Classic Experience.” Books created in the classic experience can be opened in the new experience and users can then use a “Save As” approach to update books with the new features.

Tech Bulletin: IBM Planning Analytics Workspace (PAW) v2.0.57

Further details about these new items can be found on IBM’s website.

If you have questions or would like to speak with us about these changes, please contact John Pra Sisto at jprasisto@revelwood.com.

Home » lee lazarow » Page 2

Filed Under: Tech Bulletins Tagged With: Financial Performance Management, IBM Cognos TM1, IBM PAW, IBM PAW v 2.0.57, IBM planning analytics tech bulletin, IBM Planning Analytics Workspace, IBM Planning Analytics Workspace v 2.0.57, lee lazarow, Revelwood, tech bulletin, TM1

IBM Planning Analytics Tips & Tricks: Sort Elements within a Subset

October 6, 2020 by Lee Lazarow Leave a Comment

Tips & Tricks

Did you know that there are two different ways to sort elements within a subset in IBM Planning Analytics?

Below is an example of a subset which shows a standard time dimension:

Subset sort options in IBM Planning Analytics

One approach sorts all elements either ascending or descending, regardless of level. These are done via the following icons:

IBM Planning Analytics Tips & Tricks: Subset sort options

The result of this type of ascending sort will put all elements in alphabetical order, regardless of level:

Understanding subset sort options in IBM Planning Analytics

The other approach also sorts elements either ascending or descending, but this approach takes levels into consideration. These are done via the following icons:

Subset sort options in IBM Planning Analytics

The result of this type of ascending sort will put all elements in alphabetical order while keeping the levels intact:

Learn subset sort options in IBM Planning Analytics

This approach will allow you to sort your list of elements in various ways, which offers different opportunities based on the elements within the dimension.

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: Editing Chores While Active

IBM Planning Analytics Tips & Tricks: Creating Groups in PAW

IBM Planning Analytics Tips & Tricks: Control Space

Home » lee lazarow » Page 2

Filed Under: IBM Planning Analytics Tips & Tricks Tagged With: Budgeting, Budgeting Planning & Forecasting, Financial Performance Management, IBM Cognos TM1, IBM Planning Analytics, lee lazarow, Planning & Forecasting, Planning & Reporting, Planning Analytics Tips & Tricks, Revelwood, TM1

IBM Planning Analytics Tips & Tricks: Editing Chores While Active

September 29, 2020 by Lee Lazarow Leave a Comment

Did you know that IBM Planning Analytics Workspace (PAW) allows you to edit chores while they are active? Perspectives required you to de-activate a chore, make your modifications, and then re-activate it. However, the two “bookend” steps of this approach have been eliminated in the PAW environment.

To edit a chore, right click on the name of the chore and select the option to “Edit Chore.”

IBM Planning Analytics Tips & Tricks: Editing Chores

The chore will open to show you information about the chore.  You will then be able to edit the details associated with the schedule and the specific processes to run.

You have the option to disable the schedule at any time, but this is no longer a requirement.

Editing chores in IBM Planning Analytics Workspace

This approach allows you to quickly modify your chores without having to perform the mundane steps of de-activating it and then re-activating it. This also means that you no longer need to remember to turn the chore back on after making your changes!

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: Home Button

IBM Planning Analytics Tips & Tricks: Edit Action Button

IBM Planning Analytics Tips & Tricks: Comparing Sandboxes

Home » lee lazarow » Page 2

Filed Under: IBM Planning Analytics Tips & Tricks Tagged With: Analytics, Budgeting Planning & Forecasting, Financial Performance Management, IBM Cognos TM1, IBM Planning Analytics, lee lazarow, Planning & Forecasting, Planning & Reporting, Planning Analytics Tips & Tricks, Revelwood, TM1

IBM Planning Analytics Tips & Tricks: Creating Groups in PAW

September 22, 2020 by Lee Lazarow Leave a Comment

Did you know that you can create new groups and delete groups directly in IBM Planning Analytics Workspace (PAW)?  This is done within the dimension editor via the same screen that you use to edit dimensions and attributes.

Step 1: Select the dimension to be edited.  This is done by either right clicking on a dimension and selecting the option to “Edit Dimension” or by dragging the dimension onto a sheet.

Step 2: Switch to member security mode.  This is done by clicking the Member Security Mode icon:

IBM Planning Analytics Tips & Tricks: Creating Groups in PAW

Step 3: You can now modify groups by selecting the icon to either create or delete a group:

Creating groups in IBM Planning Analytics Workspace

If you choose the option to create a group then you will be prompted for the group name.

How to create groups in IBM Planning Analytics Workspace

Once created, you can then set security by right clicking on the applicable areas:

  • Right click on the group name to define security for all elements within the group
  • Right click on a specific element to define security only for that element

This approach will save you time by allowing you to perform all aspects of dimension maintenance within a single area.

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 Cell Comments

IBM Planning Analytics Tips & Tricks: New Features in PAW – Data Refresh

IBM Planning Analytics Tips & Tricks: PAW Pass Context

Home » lee lazarow » Page 2

Filed Under: IBM Planning Analytics Tips & Tricks Tagged With: Analytics, Budgeting Planning & Forecasting, Financial Performance Management, IBM Cognos TM1, IBM Planning Analytics, lee lazarow, Planning & Forecasting, Planning & Reporting, planning analytics tips & tricks video, Revelwood, TM1

IBM Planning Analytics Tips & Tricks Video: Using Drag & Drop to Change Selector Elements in PAx Reports

September 15, 2020 by Lisa Minneci Leave a Comment

Video

In our latest IBM Planning Analytics Tips & Tricks video, Lee Lazarow, Revelwood’s FP&A technology director demonstrates how to change selector elements within IBM Planning Analytics for Excel (PAx) using drag and drop functionality. This new feature enables you to do this without having to open the set editor.

Watch this video and you’ll learn how to:

  • Select the element you want and drag it
  • Drag an existing set of elements to a selector

This approach enables Planning Analytics administrators the ability to change the values in a subset without having to train your users or learn anything about the subset editor.

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!

Watch more IBM Planning Analytics Tips & Tricks videos:

IBM Planning Analytics Tips & Tricks Video: Formatting Views in Planning Analytics Workspace

IBM Planning Analytics Tips & Tricks Video: Creating Multi-Level Dimensions

IBM Planning Analytics Tips & Tricks Video: The Hold Feature

Home » lee lazarow » Page 2

Filed Under: IBM Planning Analytics Tips & Tricks, Videos Tagged With: Budgeting, Budgeting Planning & Forecasting, Financial Performance Management, IBM Cognos TM1, IBM Planning Analytics, lee lazarow, Planning & Forecasting, Planning & Reporting, Planning Analytics for Excel, Planning Analytics tips, Revelwood, TM1

IBM Planning Analytics Tips & Tricks: Control Space

September 1, 2020 by Lee Lazarow Leave a Comment

Tips & Tricks

Have you ever been deep in thought while writing a rule or a process only to realize that you forgot the parameters for a specific command?  IBM Planning Analytics Workspace (PAW) has solved this dilemma by giving you the ability to determine those parameters with a simple set of keystrokes.

PAW’s rule editor and process editor allows you to use Ctrl-Space (e.g., press the control key and the space bar at the same time) to determine the required values associated with any rule or TI command. For example, if I type ATTRS and then press Ctrl-Space, the following will appear on the screen:

IBM Planing Analytics Tips & Tricks: Control Space

I now know the parameters that are required to complete the code.

Ctrl-Space will also help you determine which function to use.  For example, if I type ATTR and then press Ctrl-Space, the following will appear on the screen:

IBM Planning Analytics Tips: Control Space

I am now aware of all the possible attribute functions that are available and can double click on one of the results to have it automatically inserted for me.

If I do not know anything about the name of the functions to use, I can click on the fx button to see a list of the available functions, all grouped by category.

IBM Planning Analytics Tricks: Control Space

This approach allows you to quickly remember the functions and parameters that can be used in your code without having to shift your focus to another screen or manual.

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: Home Button

IBM Planning Analytics Tips & Tricks: Subset Control Dimension

IBM Planning Analytics Tips & Tricks: PAW Pass Context

Home » lee lazarow » Page 2

Filed Under: IBM Planning Analytics Tips & Tricks Tagged With: Analytics, Budgeting Planning & Forecasting, Financial Performance Management, IBM Cognos TM1, IBM Planning Analytics, lee lazarow, Planning & Forecasting, Planning & Reporting, Planning Analytics Tips & Tricks, Planning Analytics Workspace, Revelwood, TM1

IBM Planning Analytics Tips & Tricks: New PAx Feature – Double Click

August 25, 2020 by Lee Lazarow Leave a Comment

Tips & Tricks

IBM Planning Analytics for Excel (PAx) contains a task pane that shows the cubes within your model. Double clicking on a specific cube expands the information associated with the cube, including public views, private views, and the dimensions. Version 49 introduced a new feature to the double click … the ability to launch an exploration browser within your Excel environment.

When double clicking for the first time, you will be promoted to define what happens upon double click. There are two options to select from: Expand and Launch

IBM Planning Analytics Tips & Tricks: PAx double click
  • Expand will show the nodes associated with the cube
  • Launch will open a view editor
  • Note: as of this writing, at least one view must be defined for the launch option to properly work.  IBM is currently working to change this requirement.

After launching and modifying your view, you can then bring the results back to Excel by clicking on the Reports button and selecting the type of report that you want to convert your view into.

New IBM Planning Analytics PAx feature - double click

If you want to reset the action associated with double click, you can change it within the options dialog box.

New double click feature in IBM Planning Analytics for Excel

This feature allows you to quickly analyze data via a drag-and-drop approach and then bring the results back into a Planning Analytics for Excel worksheet.

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: The Collect Feature in Planning Analytics Workspace

IBM Planning Analytics Tips & Tricks Video: The Hold Feature

IBM Planning Analytics Tips & Tricks Video: How to Reorder Cubes in TM1

Home » lee lazarow » Page 2

Filed Under: IBM Planning Analytics Tips & Tricks Tagged With: Analytics, Budgeting Planning & Forecasting, Financial Performance Management, IBM Cognos TM1, IBM Planning Analytics, lee lazarow, Planning & Forecasting, Planning & Reporting, Planning Analytics Tips & Tricks, Revelwood, TM1

IBM Planning Analytics Tips & Tricks: Home Button

August 18, 2020 by Lee Lazarow Leave a Comment

Tips & Tricks

IBM Planning Analytics Workspace (PAW) offers an easy to use navigation menu that will quickly allow you to navigate to any open book. This is done by clicking on the menu at the top, center of your screen. Here is a sample menu that shows three open workbooks.

IBM Planning Analytics Tips & Tricks: Home Button

But did you know that you can also go back to PAW’s opening screen via a single click? A “home” button exists at the top, left corner that takes you directly to the welcome page.

The home button in IBM Planning Analytics

This approach will allow you to save time by quickly navigating back to the start via a single click.

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! You can also sign up to get our Planning Analytics Tips & Tricks sent directly to your inbox!

Read more IBM Planning Analytics Tips & Tricks:

IBM Planning Analytics Tips & Tricks: Create New Books with the Diamond Icon

IBM Planning Analytics Tips & Tricks Video: Formatting Views in Planning Analytics Workspace

IBM Planning Analytics Tips & Tricks: The Collect Feature in IBM Planning Analytics Workspace

Home » lee lazarow » Page 2

Filed Under: IBM Planning Analytics Tips & Tricks Tagged With: Analytics, Budgeting Planning & Forecasting, Financial Performance Management, IBM Cognos TM1, IBM Planning Analytics, lee lazarow, Planning & Forecasting, Planning & Reporting, Planning Analytics Tips & Tricks, Revelwood, TM1

Technical Bulletin: Earlier Security Change Impacting MDX Reverted

July 10, 2020 by Lee Lazarow Leave a Comment

Tech Bulletins

IBM is undoing a recent security change in the next release of IBM Planning Analytics.

In late June we issued a technical bulletin about version 2.0.9 of Planning Analytics that changed the way MDX expressions are generated for dimensions that have security defined.

IBM received feedback from Planning Analytics customers and recognizes this change has broader implications than originally expected. As a result, IBM is going to undo the change impacting MDX expressions in the next release of Planning Analytics.

Version 2.0.9.2 of Planning Analytics will revert changes in the way MDX expressions are generated for dimensions that have security defined. This version of Planning Analytics is expected to be released by the end of July 2020. [Update: this version of Planning Analytics was released on July 27, 2020.]

Recommended Next Steps for Planning Analytics Users

If you recently upgraded your local environment to version 2.0.9 or 2.0.9.1 and have experienced a negative impact on your model, Revelwood recommends upgrading to version 2.0.9.2 as soon as it is available.

If you are using Planning Analytics on the cloud, your system will be updated automatically and there are no further steps you need to take.

If you are unsure about how the change impacted your model, you can run a test on your model. Revelwood has created a TurboIntegrator script that will help you assess potential conflicts by analyzing combinations of element security and dynamic subsets. You can download the script for free at https://revelwood.com/ti-processes/. You do not need to be an existing Revelwood customer to download this script.

Please contact John Pra Sisto at jprasisto@revelwood.com if you have any questions regarding this bulletin or the TurboIntegrator script.

Home » lee lazarow » Page 2

Filed Under: Tech Bulletins Tagged With: IBM Cognos TM1, IBM Planning Analytics, lee lazarow, Revelwood, TM1

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