• 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 Cognos TM1

IBM Planning Analytics Tips & Tricks: Change Element Type in PAW

December 22, 2020 by Thanh Chau Leave a Comment

Most users of IBM Planning Analytics Workspace (PAW) are familiar with the dashboarding and reporting capabilities for front-end users. However, IBM has built-in features that allow administrators to manage their models from PAW as well. Managing the dimension structure is one such feature. Though most of it is intuitive, updating the element type is a bit hidden.

To access the dimension editor, first open a workbook in PAW. Then in the left navigation pane, expand the “Dimensions” node to find the dimension that you would like to edit.

IBM Planning Analytics Tips & Tricks: Change Element in PAW

Drag the dimension to the work area pane on the right. You’ll see a warning stating that any changes will apply instantly unless you have reserved the dimension. Reserving the dimension locks the dimension so that no one else can make changes.

IBM Planning Analytics Tips: Change Element Type in PAW

In the PAW dimension editor, click on the paw iconicon to show the properties window. Select a member to show or change its properties. Please note that PAW doesn’t have “Consolidated” as a selectable type in the dropdown. PAW will automatically convert an element to a consolidation when you add children to it.  Conversely, it will change a consolidation to a simple element when you remove all children.

IBM Planning Analytics Tricks: Change Element Type in PAW

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: Asymmetric Axis in PAW

IBM Planning Analytics Tips & Tricks: Change Connection used by Quick Report

IBM Planning Analytics Tips & Tricks: Edit Action Button

Home » IBM Cognos TM1 » Page 16

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

IBM Planning Analytics Tips & Tricks: Rule Editor Keyboard Shortcuts

December 15, 2020 by Lee Lazarow Leave a Comment

Are you an “old school” keyboard person that still presses Ctrl-S to save your Excel workbooks? Do you flip through windows by pressing Alt-Tab? Do you remember Lotus backslash macros that used commands such as /FS for File, Save? If so, did you know that you can still do things like this within the new IBM Planning Analytics rules editor?

The easiest way to get started with keyboard commands is to press Ctrl-K within a rules window. This will open an area that shows a list of keys that can be used within the rule.

Here are some of the combinations that I use regularly when writing rules:

Ctrl-F then Ctrl-G: Ctrl-F will find a specific word or phrase and Ctrl-G will then allow you to scroll through the rule to find the next instance of that phase. This is helpful when you have a long rule and want to go directly to a section (example: quickly go to the FICA calcs in a comp model).

Ctrl-Shift-R: Ctrl-Shift-F will allow you to find and replace a single instance of text, but Ctrl-Shift-R allows you to do a find and replace within the entire rule (example: I have ‘Plan’ in the left side of many rules, but I want to replace it with ‘Plan2’).

Ctrl-Home and Ctrl-End: These combinations allow you quickly navigate to the start or the end of the rule. It’s an easy way to look for your SKIPCHECK command or go directly to your feeders section.

Ctrl-Z and Ctrl-Y: Ctrl-Z is the equivalent of the undo button and Ctrl-Y is the undo of the undo (or a redo). I sometimes get careless with Ctrl-Z and undo too much. This is where Ctrl-Y comes into play.

Ctrl-A: This will select the entire rule. I used this a lot with Perspectives since I often had to bring my rule into another text editor, but PA’s new formatting and line numbering has minimized the amount of times I use this combination.

If you are a keyboard person then it is good to know that Planning Analytics’ rule editor still allows you to use these combinations. And if you are not a keyboard person then maybe some of these will help improve your efficiency.

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: Log Lock Notification

IBM Planning Analytics Tips & Tricks: Alternative Row Formats for Excel Reports

IBM Planning Analytics Tips & Tricks: Minimizing the Subset Area

Home » IBM Cognos TM1 » Page 16

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

IBM Planning Analytics Tips & Tricks: Log Lock Notification

December 8, 2020 by Lee Lazarow Leave a Comment

Have you ever tried to move or download log files and then realize that some of the files cannot be modified since they are in use? IBM Planning Analytics Workspace (PAW) recognizes this and now offers notifications to let you know which files are locked.

You can download log files by first selecting the PA Administration button at the top of your screen.

IBM Planning Analytics Tips & Tricks: Log Lock Notification

One inside the administration area, you can view the logs by clicking on the three dots at the top, right corner of your server and selecting the option called “Download logs.”

IBM Planning Analytics Tips: Log Lock Notification

From there, you can simply select the logs that you want to download and then select the “download” button at the bottom of the screen. Any locked log files will show the word “locked” on the screen and will also prevent you from selecting that log. The example below shows the tm1server.log file checked and shows the tm1s.log file as locked.

IBM Planning Analytics Tricks: Log Lock Notification

This approach will help you easily remember which files are accessible and which are not.

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: Alternative Row Formats for Excel Reports

IBM Planning Analytics Tips & Tricks: Show Members

IBM Planning Analytics Tips & Tricks: An Approach to Strengthening Your MDX Skills

Home » IBM Cognos TM1 » Page 16

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

IBM Planning Analytics Tips & Tricks: Asymmetric Axis in PAW

December 1, 2020 by Thanh Chau Leave a Comment

One of the helpful features of IBM Planning Analytics is the ability to create explorations using asymmetric axes. This is useful when you have stacked column or row dimensions, and only want to display certain combinations of elements instead of all combinations of the stacked dimensions.

To do this in Planning Analytics Workspace (PAW), open a workbook in PAW and open an exploration. Click on the Icon in PAW icon to make the row dimensions asymmetric or the icon in PAW_2 icon for the column dimensions. Next, hold down the CTRL key and select the rows or columns you want to keep or hide.

IBM Planning Analytics Tips & Tricks: Asymmetric axis in PAW

Right-click on one of the selected columns and select “Keep” or “Hide.”

Asymmetric axis in PAW

If you need to revert back to the normal view, right-click on any row or column and select “Unhide All.”

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: PAW Pass Context

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

IBM Planning Analytics Tips & Tricks: Navigating Back to the Source

Home » IBM Cognos TM1 » Page 16

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

IBM Planning Analytics Tips & Tricks: Convert Existing View Directly to Reports

November 24, 2020 by Nina Inverso Leave a Comment

Did you know that Planning Analytics for Excel (PAx) provides the ability to convert an existing view directly to a report in Excel? Without opening the view as an Exploration, you can start building your report directly from the Task Pane.

Just right-click on the view in the Task Pane to display the available options.

IBM Planning Analytics Tips & Tricks: Convert Existing View to Reports

You will see the following options by hovering over the Quick report, Dynamic report, and Custom report items:

How to convert existing views into reports in Planning Analytics

In this example, each of the items does the following:

  • On this sheet: This will open the existing Planning Analytics view as a Quick report on the current Excel sheet at cell $A$1.
  • On new sheet: This will open the view as a Quick report on a new sheet at cell $A$1.
  • At current location: This will open the view as a Quick report at the cell that is currently active.
  • At specified location: This will open a pop-up window that allows you to input the cell at which you would like the Quick report to appear. You can then enter the cell address and click OK to generate the Quick report, as shown in the following image.
Learn how to convert existing views to reports in Planning Analytics

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 posts:

IBM Planning Analytics Tips & Tricks: PAx Task Pane Workbook Tab

IBM Planning Analytics Tips & Tricks: PAx Control Objects

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

Home » IBM Cognos TM1 » Page 16

Filed Under: IBM Planning Analytics Tips & Tricks Tagged With: Analytics, Budgeting, Budgeting Planning & Forecasting, Financial Performance Management, IBM Cognos TM1, IBM Planning Analytics, Nina Gordy, Planning & Forecasting, Planning & Reporting, Planning Analytics tips, Planning Analytics Tips & Tricks, TM1

IBM Planning Analytics Tips & Tricks: PAx Task Pane Workbook Tab

November 17, 2020 by Nina Inverso Leave a Comment

Did you know that Planning Analytics for Excel (PAx) automatically keeps track of the Planning Analytics objects you have open in an Excel workbook?

Simply click on the Workbook tab of your Task Pane to view the list of Dynamic reports, Action buttons, Explorations, and Quick reports that are currently in use.

IBM Planning Analytics Tips & Tricks: PAx Task Pane Workbook Tab

These folders will be populated as you work with your Planning Analytics environment. Whether you manually add these items to a worksheet, or they are included in an existing view or report, they will appear here.

For example, clicking the Exploration button in the PAx ribbon will create an Exploration on a new worksheet.

The PAx task pane workbook tab in IBM Planning Analytics

This will also add an item to the Explorations folder on the Workbook tab of the Task Pane. When you right-click on the name of the new Exploration, you will see the following options:

Learn about the PAx task pane workbook tab in IBM Planning Analytics

Similar options appear for Dynamic reports, Action buttons, and Quick reports.

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: PAx Control Objects

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

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

Home » IBM Cognos TM1 » Page 16

Filed Under: IBM Planning Analytics Tips & Tricks Tagged With: Analytics, Budgeting, Budgeting Planning & Forecasting, Financial Performance Management, IBM Cognos TM1, IBM Planning Analytics, Nina Gordy, PAx, Planning & Forecasting, Planning & Reporting, Planning Analytics for Excel, Planning Analytics Tips & Tricks, TM1

IBM Planning Analytics Tips & Tricks: Alternative Row Formats for Excel Reports

November 10, 2020 by Lee Lazarow Leave a Comment

Tips & Tricks

In the early days of computing, printers often used paper that had alternating white and green areas which allowed the reader to easily follow a line of text across the page. This was known as “green bar” paper.  While we no longer use this type of paper, the concept is still applicable for situations where your output contains many columns that are hard to follow.

You can create this approach by using alternate row formats within your Excel reports.  This is done by combining two Excel formulas:

  • The ROW formula returns the row number for a cell reference. For example, ROW(K5) returns the number 5 since the cell is in the 5th row of the spreadsheet.
  • The MOD formula returns the remainder of two numbers after division. For example, MOD(9,2) returns the number 1.

When combined, the following formula will result in either a 1 or a 0:

=MOD(ROW(cell),2)

From there, you can use conditional formatting to define the fill colors. If you are doing this in standard Excel, then you can copy the formula throughout the applicable area.  If you are doing this within a dynamic report, then you can use it within the formatting area.

This approach allows you to make your wide reports easier to read. This also means that you can recreate the green bar format while you pull out your dot matrix printer and watch classic movies such as Wargames!

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 posts:

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

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

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

Home » IBM Cognos TM1 » Page 16

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: Minimizing the Subset Area

November 3, 2020 by Lee Lazarow Leave a Comment

Tips & Tricks

Are your member names long and hard to see in the subset editor in IBM Planning Analytics? Does it get confusing to see both the available members and the current set at the same time? Both situations can be solved by hiding one side of the subset editor.

Here is an example of the subset editor which shows both the available members and the current set.

IBM Planning Analytics Tips & Tricks: Minimizing the Subset Area

Each of the two sections has an option to minimize the area. This is done by clicking on the minus symbol at the top of the applicable section.

IBM Planning Analytics: Minimizing the Subset Area

Once clicked, the applicable area will compress and the other area will expand. Note that you can only minimize one side at a time. Below are examples of what each screen will look like when compressed.

Minimized Available Members:

IBM Planning Analytics Tips: Minimizing the Subsea Area

Minimized Current Set:

Minimizing the subset area in IBM Planning Analytics

This approach will allow you to further customize your subset editor screen to allow you to focus only on the area you want 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: Maintaining Subset-Drive Consolidations

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

IBM Planning Analytics Tips & Tricks: Subset Control Dimension

Home » IBM Cognos TM1 » Page 16

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: Show Members

October 27, 2020 by Lee Lazarow Leave a Comment

Tips & Tricks

Did you know that while you are doing dimension maintenance, you can quickly view an element’s parents or children in IBM Planning Analytics Workspace (PAW) via a single click? Here’s how you can do this:

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: Right click on an element and select the option to “Show Member.” You will then see two sub-options: one for Parents and one for Children.

IBM Planning Analytics Tips & Tricks: Show Members
  • If you select the option for Parents then you will see all of the parents associated with the selected element. In this example, there is only one parent within the dimension structure.
Show members in IBM Planning Analytics
  • If you select the option for Children then you will see all of the children associated with the selected element. In this example, there are three elements in the consolidation.
How to show members in IBM Planning Analytics

Once defined, you can then perform dimension maintenance to each of the elements on your screen.

This approach allows you to easily traverse up or down your dimension while minimizing the amount of extra elements on the screen.

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: Sort Elements within a Subset

IBM Planning Analytics Tips & Tricks: Editing Chores While Active

IBM Planning Analytics Tips & Tricks: Creating Groups in PAW

Home » IBM Cognos TM1 » Page 16

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

  • « Go to Previous Page
  • Page 1
  • Interim pages omitted …
  • Page 14
  • Page 15
  • Page 16
  • Page 17
  • Page 18
  • Interim pages omitted …
  • Page 24
  • 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.