• 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

Planning & Forecasting

IBM Planning Analytics Tips & Tricks: Planning Analytics Forecasting – Configuring the Time Dimension

February 16, 2021 by Nina Inverso Leave a Comment

Tips & Tricks

The new IBM Planning Analytics Forecasting feature allows you to quickly populate future time periods based on past data values. This feature is especially useful to prepopulate a data set for you or your team to then adjust as you see fit. Because it is time-based, the feature requires that a time dimension has been set up in a specific way.

  1. Ensure that the cube where you want to forecast includes a time dimension.
  2. Make sure the dimension type is set to TIME.

    a. Sign into PAW and open a new book. In the navigation pane, right-click on the Dimensions section, and click Edit settings. 

    Configuring Time Dimension in IBM Planning Analytics Forecasting Model

    b. Click on the Dimensions Attributes Mode button in the upper right-hand corner of the window.

    Learn how to configure the time dimension in IBM Planning Analytics Forecasting Model

    c. Enter TIME as the DIMENSION_TYPE if blank.

    How to configure the time dimension in IBM Planning Analytics Forecasting Model
  3. Make sure you have a flat hierarchy available.

    a. In the navigation pane, right-click on the dimension name, and click Create hierarchy.

    Understand how to configure the time dimension in IBM Planning Analytics Forecasting Model

    b. Enter a new hierarchy name and click the CREATE button.

    Learn to configure the time dimension in IBM Planning Analytics Forecasting Model

    c. Use the dimension editor to add base-level time elements to the new hierarchy. The easiest way to accomplish this is by copying element names from an existing hierarchy in the dimension.

    Your time dimension is now ready to use in a Planning Analytics Forecasting model.

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: Converting Existing View Directly to Reports

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

IBM Planning Analytics Tips & Tricks: Maintaining Subset Driven Consolidations

Home » Planning & Forecasting » Page 7

Filed Under: IBM Planning Analytics Tips & Tricks Tagged With: Budgeting Planning & Forecasting, enterprise performance management, Financial Performance Management, forecasting, IBM Cognos TM1, IBM Planning Analytics, Planning & Forecasting, Planning Analytics Forecasting model, Planning Analytics Tips & Tricks, TM1

IBM Planning Analytics Tips & Tricks: Dimension Attribute Types

February 9, 2021 by Marc Assenza Leave a Comment

Tips & Tricks

Did you know that IBM Planning Analytics dimensions can have defined types and that these defined types are necessary for certain Planning Analytics features to operate correctly? For example, the new predictive forecasting functionality within Planning Analytics Workspace (PAW) requires the use of a designated Time dimension.

To view your dimension definitions in Planning Analytics Workspace, right-click on Dimensions and click “Edit settings” from the context menu.

IBM Planning Analytics Tips: Dimension Attribute Types

The dimensions view will open in Dimensions Security Mode. To see the dimension types, switch to Dimensions Attributes Mode.

IBM Planning Analytics Tricks: Dimension Attribute Types

Attributes for each dimension are then presented. Not every dimension needs to have a defined dimension type, but some dimensions need to be defined to use specific functionality. The following types can be defined:

  • GEOGRAPHY – Used in Planning Analytics Workspace to allow the visualization of your data using geographic maps.
  • TIME – Contains specified and recognized intervals of time utilized within a budgeting, planning, forecasting, and reporting structure.
  • CALCULATION – Contains formulas used to perform intended operations against your data.
  • METRIC – Contains a group or groups of elements that will be used to measure a business’s Key Performance Indicators (KPI’s).
  • METRIC INDICATORS – Provides further information in relation to Key Performance Indicators (KPI’s), an example of this is trend.
  • VERSIONS – Contains data from multiple uses of an element, such as current budget for a department for this year compared against the department’s budgets for prior years.
  • GENERIC – Used when there is no precise type of dimension type required. These general members can include things like products and customers. Please note this can be changed at any point if you determine the dimension should have had or needs to be a defined type.
  • HIERARCHY – This type of dimension is representative of the business reporting structure and can be used in tandem with workflow within an application.

This approach can be used with functionality associated with visualizations, predictive modeling, and other uses of 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!

Read more IBM Planning Analytics Tips & Tricks:

IBM Planning Analytics Tips & Tricks: PA Modeling – The Dimension Editor

IBM Planning Analytics Tips & Tricks: Simplifying Dimension Maintenance

IBM Planning Analytics Tips & Tricks: Subset Control Dimension

Home » Planning & Forecasting » Page 7

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

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

January 26, 2021 by Lee Lazarow Leave a Comment

Have you ever wanted to define the number of working days between two calendar dates? Do you define “working days” simply as non-weekend days or do you also include holidays? Did you know that you can calculate this information using Excel’s NETWORKDAYS function?

The NETWORKDAYS function is used to determine the number of whole working days between start_date and end_date. Working days are defined as the exclusion of weekends, which in essence computes the number of Mondays through Fridays. The function also includes an optional parameter to exclude holidays and any other specific non-working days.

The syntax of the function is:

NETWORKDAYS (start_date, end_date, [holidays])
  • Start_date: This is required
  • End_date: This is required
  • Holidays: This is optional
    • This consists of a range of one or more dates to be excluded from the calendar. The list entails a range of cells that contains the dates.

Note: All dates are entered in date format or in serial number format

This information can be used to help calculate any/all of the following pieces of your model:

  • Benefit accruals and eligibility
  • Ratios such as “Revenue per day” or “Units per day”
  • Days remaining for end-of-service dates
  • Anything else that requires the number of days within the formula

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 in our IBM Planning Analytics Tips & Tricks series:

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

IBM Planning Analytics Tips & Tricks: Excel TYPE Function

IBM Planning Analytics Tips & Tricks: Excel Keyboard Navigation

Home » Planning & Forecasting » Page 7

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

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: 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 » Planning & Forecasting » Page 7

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 » Planning & Forecasting » Page 7

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 » Planning & Forecasting » Page 7

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

Workday Adaptive Planning Tips & Tricks: Override Formulas in Sheets

November 4, 2020 by Michelle Song Leave a Comment

If you want to write a formula in an account in Workday Adaptive Planning, but still want to give your team the ability to override the formula and enter different data, you can use Shared Formulas to achieve that.

The Shared Formulas function of Adaptive Planning allows users to write level-specific and version-specific formulas for GL and custom accounts. Below is a screenshot of the Shared Formula page in Adaptive.

Workday Adaptive Planning: Override Formula

First, you will select the version, account, and levels that you want to write the formula. Then, you will write the formula in the “Set formula” box. Before you save the formula, you can choose to reserve/remove the user edits in the account if any. If you reserve the user edits, the formula will not override cells that already have data and only perform the formula in the cells that are blank on sheets.

Workday Adaptive Planning: How to override formulas in sheets

You can use the “Import Shared Formulas” function to import/update the formulas in multiple accounts and levels at a time.

Overrding formulas in Workday Adaptive Planning

Unlike Master Formulas, shared formula values are not locked in sheets. You can override the formula with different data directly in a sheet cell. In the example below, I overridden the formula for account 1110 Petty Cash in Mar 2019 with a different number.

Workday Adaptive Planning Tips: Override Formulas in Sheets
Workday Adaptive Planning Tricks: Override formulas in sheets

The team at Revelwood has been recognized by Workday Adaptive Planning for our thought leadership in the space, commitment to our Workday Adaptive Planning practice, and our rapid achievements of milestones. Visit Revelwood’s Knowledge Center for our Workday Adaptive Planning Tips & Tricks or sign up here to get our Workday Adaptive Planning Tips & Tricks delivered directly to your inbox. Not sure where to start with Workday Adaptive Planning? Our team here at Revelwood can help! Contact us info@revelwood.com for more information.

Read more Workday Adaptive Planning Tips & Tricks:

Workday Adaptive Planning Tips & Tricks: Templates

Workday Adaptive Planning Tips & Tricks: Trigger for a Cube Calculated Account

Workday Adaptive Planning Tips & Tricks: Alternate Time Tree

Home » Planning & Forecasting » Page 7

Filed Under: Workday Adaptive Planning Tips & Tricks Tagged With: Adaptive Insights, adaptive insights tips & tricks, Budgeting, Budgeting Planning & Forecasting, enterprise performance management, Financial Performance Management, Planning & Forecasting, Planning & Reporting, Workday Adaptive Planning, Workday Adaptive Planning Tips & Tricks

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 » Planning & Forecasting » Page 7

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

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