• 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

Financial Performance Management

IBM Planning Analytics Tips & Tricks: Excel TYPE Function

January 12, 2021 by Lee Lazarow Leave a Comment

Have you ever referenced a list in Excel and needed to know whether each value was a number or a string? This may be required when another function depends on the type of value in each cell.

Excel has a function called TYPE that will give you this information. The function contains a single parameter, which is simply the cell you want to check. The formula will output a number that defines the type of value such as number, text, logical value or an error.

Here are results from four iterations of the TYPE formula:

IBM Planning Analytics Tips & Tricks: Excel Type

You can then use the type result within an IF statement to perform various functions.

The TYPE function will not determine whether a cell contains a formula. TYPE only determines the type of the resulting, or displayed, value. If value is a cell reference to a cell that contains a formula, TYPE returns the type of the formula’s resulting value.

This approach will help you when determining the use of IBM Planning Analytics formulas such as DBS vs. DBSS.

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 Excel tips & tricks:

IBM Planning Analytics Tips & Tricks: Excel Keyboard Navigation

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

IBM Planning Analytics Tips & Tricks: Excel’s CONCAT and TEXTJOIN Functions

Home » Financial Performance Management » Page 17

Filed Under: IBM Planning Analytics Tips & Tricks Tagged With: enterprise performance management, Excel, Excel tips & tricks, Financial Performance Management, IBM Cognos TM1, IBM Planning Analytics, lee lazarow, Planning Analytics tips, Planning Analytics Tips & Tricks, Revelwood, TM1

IBM Planning Analytics Tips & Tricks: Excel Keyboard Navigation

January 5, 2021 by Lee Lazarow Leave a Comment

Have you ever wanted to quickly go to the last used cell within a spreadsheet but did not know how? Have you ever wanted to determine where the next available row or column resides? Have you ever wondered why a spreadsheet with only a few cells of data may appear as a large file? All these answers can be provided with a single keystroke combination.

Pressing Ctrl and End at the same time will bring you to the last cell within a spreadsheet that Excel is referencing. The definition of “last” entails the rightmost column and the lowest used row on the worksheet. The last cell may not always contain data, but it will always be registered by Excel as something that is utilizing memory.

Here are some other keystroke combinations that will help you quickly navigate around your spreadsheet:

  • Ctrl and Home at the same time: this will bring you to the first cell (A1) in the worksheet.
  • End then an arrow key: this will bring you to the next empty value in any direction. For example, pressing End and then the down arrow will bring you to next empty cell in the column where your cursor currently resides.
  • Ctrl and PageUp : this will bring you to the previous sheet in the workbook.
  • Ctrl and PageDn: this will bring you to the next sheet in the workbook.

Keyboard shortcuts can easily help you navigate your Excel files and help you determine the “ending” cell within a spreadsheet.  This will be useful in situations such as dynamic reports where rows and columns are automatically generated via automation.

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 Excel Tips & Tricks:

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

Home » Financial Performance Management » Page 17

Filed Under: IBM Planning Analytics Tips & Tricks Tagged With: enterprise performance management, Excel, Excel tips & tricks, Financial Performance Management, IBM Cognos TM1, IBM Planning Analytics, lee lazarow, Planning Analytics tips, Planning Analytics Tips & Tricks, Revelwood, 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 » Financial Performance Management » Page 17

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 » Financial Performance Management » Page 17

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 » Financial Performance Management » Page 17

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

FP&A Done Right: Rolling Forecasts for More Strategic FP&A

December 4, 2020 by Revelwood Leave a Comment

This is a guest blog post from our partner Workday Adaptive Planning, written by Bob Hansen. Hansen makes the case for dynamic planning, which is better suited for complexity.

When it comes to FP&A forecasting, most companies base their long-range forecasts on static planning processes, rather than more relevant, dynamic plans that reflect the complexities of the business.

Relying on a forecast that doesn’t enable continuous monitoring of company performance, instead of implementing a modern, rolling forecast approach, is like using an old-school road map to guide you on a cross-country trip: Why use a paper map when you can get to your destination worry-free with a car GPS system?

Rolling forecasts—forecasts that are updated typically on a quarterly or monthly basis—can be a game changer. Especially today, amid a global pandemic. They allow organizations to better align with their strategy, perform more-effective business analysis, and derive greater ongoing value from their budgeting and planning processes. Rolling forecasts make organizations nimbler, able to seize potential opportunities, or better prepared for upcoming roadblocks.

Rolling toward a more strategic focus for FP&A

There is an increasing expectation that strategic guidance—which can be generated through rolling forecasts—emanates from the FP&A team. A CFO Indicator report affirmed that need. The survey found that CFOs expect that time spent by the FP&A team on strategic tasks will double by 2020—growing from 11-25% today to 25-50%.

Furthermore, CFOs are looking for their teams to develop the technical and strategic capabilities that support executing approaches such as rolling forecasts. According to the CFO Indicator survey, if the FP&A team could improve only one skill, 29% of CFOs want that skill to be dashboard design and report building, 25% want it to be predictive analytics capabilities, and 19% want strategic modeling of what-if scenarios.

Fortunately, with the increasingly user-friendly experience of dashboard technology, the skills gap is narrowing, which allows more FP&A teams to start instituting rolling forecasts.

FP&A … so little time

So rolling forecasts are a no-brainer? In theory, yes. Yet the near-universal challenge lies in freeing up finance teams to move toward this new approach. There is a significant gap between what CFOs want their teams to be doing and how they actually spend their days. Often-cited research by APQC shows that only 40% of 130 finance executives from very large organizations rated their FP&A capabilities as effective.

Further, our research shows that 75% of CFOs want their teams to have a significant and strong impact on their organization, yet only 46% expect that their team will have that kind of impact this year. The chief reason continues to be a lack of time for strategic planning.

The clear benefits of rolling forecasts

Despite these time-crunch challenges, the benefits of getting to rolling forecasts are clear. The APQC survey showed that organizations that use rolling forecasts are better aligned with unfolding business strategy, are more effective at business analysis, derive greater value from their budgeting and planning processes, and have more reliable forecasts than those that do not use them. The survey revealed that 94% of businesses that use rolling forecasts described their business analysis as effective. Only 50% of those that do not use rolling forecasts described their analysis that way.

Finance leaders need to clearly promote the many benefits of rolling forecasts and how they can directly impact business results. For example, you can produce a cash flow forecast at the end of a rolling financial forecast process—resulting in a consolidated balance sheet and an accurate view of cash flow for the entire enterprise. Getting C-suite buy-in helps pave the way to get the resources and time needed to develop relevant and robust rolling forecasts.

Moving to rolling forecasts is possible at organizations that have executive support and invest in new, cloud-based finance software. These solutions offer easy-to-navigate dashboards and scores of time-saving hacks that can free finance pros from transactional busywork and allow them to focus on more strategic activities that improve business performance.

Like a state-of-the-art GPS, rolling forecasts can go a long way toward helping you get where you want to go—and position FP&A to be a driver of the business, not stuck in the back seat.

This blog post was originally published on the Workday Adaptive Planning blog and appeared here.

Read more guest blog posts from Workday Adaptive Planning:

FP&A Done Right: Three Driver-based Budgeting Tips for CFOs When Change is Imminent

FP&A Done Right: Modernize your Budget Process to Anticipate Change

FP&A Done Right: Reforecasting in a COVID-19 World – Best Practices you can Implement Now

Home » Financial Performance Management » Page 17

Filed Under: FP&A Done Right Tagged With: active planning, Adaptive Insights, dynamic planning, enterprise performance management, Financial Performance Management, FP&A, FP&A done right, Planning & Forecasting, Rolling Forecasts, Workday Adaptive Planning

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 » Financial Performance Management » Page 17

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 » Financial Performance Management » Page 17

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 » Financial Performance Management » Page 17

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

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