• 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
        • Adaptive Planning Training
        • IBM Planning Analytics / TM1 Training
    • Products
      • DataMaestro
      • LightSpeed
      • IBM Planning Analytics Utilities
  • How We Help
    • Workday Adaptive Planning Use Cases
    • IBM Planning Analytics Use Cases
    • BlackLine Use Cases
    • Client Success Stories
  • How We Think
    • Knowledge Center
    • Events
    • News
  • Contact Us

Cognos

Technical Bulletin: End of Support for IBM Planning Analytics Local, IBM Planning Analytics Advanced and IBM Planning Analytics Express Versions 2.0.0 – 2.0.8

July 6, 2021 by Lee Lazarow Leave a Comment

Tech Bulletins

IBM recently announced End of Support (EOS) dates for older versions of IBM Planning Analytics Local, IBM Planning Analytics Advanced and IBM Planning Analytics Express.

Here are the important dates to know:

  • April 30, 2022 – End of support for versions 2.0.0 – 2.0.7
  • September 20, 2022 – End of support for version 2.0.8.

In order to keep your Planning Analytics environment working properly, we recommend that clients upgrade to Planning Analytics version 2.0.9. Upgrading to a newer version of Planning Analytics will give you access to new fixes and features, such as:

  • Multi-threaded loading of cubes for faster startup
  • Data protection by ensuring that a major error in a TurboIntegrator process rolls back instead of committing any changes
  • Various new configurating settings, formatting options and functions for TM1 Websheets
  • Support for Windows Server 2019

Revelwood Can Help

Let us make this upgrade as easy as possible on you and your team. We can assist you with all aspects of the upgrade, including:

  • Downloading and installing Planning Analytics 2.0.9
  • Assisting with the testing process, and if needed, creating a test plan
  • Reviewing your existing Planning Analytics environments
  • Optimizing your migration approaches (Development, QA and Production)
  • Training for new features and configuration settings
  • Defining a Road Map for you for future changes to the Planning Analytics environment.

If you would like Revelwood’s assistance with your upgrade, please contact John Pra Sisto.

Learn more about IBM’s announcement:

  • https://www.ibm.com/support/pages/node/1206880https://www.ibm.com/support/pages/node/1206880
  • https://www.ibm.com/support/lifecycle/details?q45=B952284Y60078F98
  • https://www.ibm.com/support/lifecycle/details?q45=Y845442N85330S21
Home » Cognos

Filed Under: Tech Bulletins Tagged With: Cognos, end of support + IBM Planning Analytics, IBM Planning Analytics, IBM Planning Analytics Advanced, IBM Planning Analytics Express, IBM Planning Analytics Local, IBM Planning Analytics v2

IBM Planning Analytics Tips & Tricks: 445

July 6, 2021 by Lee Lazarow Leave a Comment

Tips & Tricks

Time is an important aspect when implementing planning models. Calculations often use time to spread an annual amount throughout the year. However, the definition of “spread” does not always entail a simple approach.

Sometimes clients want to spread an annual value evenly through the year, which leads to an easy “divide by 12” calculation. But sometimes clients want to spread the values based on weeks. This is where calculations get a bit more complicated.

A standard year includes 52 weeks. However, not all months contain the same number of weeks and we do not want the spread to include any decimals. As a result, we cannot simply divide 52 by 12 months. We can, however, easily divide 52 by 4 quarters and calculate that each quarter has 13 weeks.

But we again face the same challenge since 13 weeks divided by 3 months results in a value with decimals. This is where accounting standardization comes into play. There are three standard methods to determine how to spread the number of weeks throughout a quarter.

  • 4-4-5
  • 4-5-4
  • 5-4-4

Each of these methods define how many weeks are in the first month, how many weeks are in the second month, and how many weeks are in the third month. For example, the 4-4-5 method ensures that a calendar based year always has 4 weeks of data in fiscal January, 4 weeks of data in fiscal February, and 5 weeks of data in fiscal March.

There are advantages and disadvantages to this approach:

Advantages:

  • Comparisons are easy since the end date of the period is always the same day of the week
    • Every period is the same length which makes quarter vs. quarter comparisons useful
    • Comparisons can easily be made to the same period in the prior year
    • Comparisons can easily be made to a similar period in a different quarter
  • Since the number of weeks in a month are consistent, it is very easy to calculate weekly averages

Disadvantages:

  • Month by month comparisons are flawed because one month is 25% longer than the other two
  • The year only includes 364 days (7 days x 52 weeks), so a 53rd week will need to be added every five or six years … which can make year over year comparisons difficult
  • This approach can also lead to other complex accounting practices such as accruals

IBM Planning Analytics, powered by TM1, is full of new features and functionality. Need advice? Our team here at Revelwood can help. Contact us for more information at info@revelwood.com. We post new Planning Analytics Tips & Tricks weekly in our Knowledge Center and in newsletters.

Read more IBM Planning Analytics Tips & Tricks:

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

IBM Planning Analytics Tips & Tricks: The Excel DATE Function

IBM Planning Analytics Tips & Tricks: Rule Timestamps

Home » Cognos

Filed Under: IBM Planning Analytics Tips & Tricks Tagged With: Cognos, enterprise performance management, enterprise planning, Financial Performance Management, IBM Planning Analytics, planning models, spread values

IBM Planning Analytics Tips & Tricks: PAW Chart Padding

June 29, 2021 by Lee Lazarow Leave a Comment

Did you know that IBM Planning Analytics Workspace (PAW) offers a feature calling “padding” which defines lines are separated within a chart? The concept of padding is the equivalent of defining white space in between the lines (e.g., no padding) or making the lines touch the lines above and below (e.g., padding).

The setting is located within the chat area of the visualization properties. It is defined as a binary option so you can choose to enable it or disable it.

IBM Planning Analytics Tips & Tricks: PAW Chart Padding

Here is an example of the same chart via both options. The chart on the top has padding enabled (e.g., the option is not checked) and the chart on the bottom has padding disabled.

By defining whitespace around your charts, you make your data more readable.

IBM Planning Analytics, powered by TM1, is full of new features and functionality. Need advice? Our team here at Revelwood can help. Contact us for more information at info@revelwood.com. We post new Planning Analytics Tips & Tricks weekly in our Knowledge Center and in newsletters.

Read more IBM Planning Analytics Tips & Tricks:

IBM Planning Analytics Tips & Tricks: Pie Chart Sizing

IBM Planning Analytics Tips & Tricks: IBM Planning Analytics Workspace Tab Icons

IBM Planning Analytics Tips & Tricks: IBM Planning Analytics Workspace Tab Colors

Home » Cognos

Filed Under: IBM Planning Analytics Tips & Tricks Tagged With: Cognos, enterprise performance management, enterprise planning, Financial Performance Management, IBM Planning Analytics, IBM Planning Analytics charts, IBM Planning Analytics PAW, IBM Planning Analytics Workspace, TM1

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

Contact:

25B Vreeland Road, Suite 111 Florham Park, NJ 07932
201.984.3030
info@revelwood.com

Copyright © 2023 · Revelwood Inc. All rights reserved. Revelwood® and the Revelwood logo are registered marks of Revelwood Inc.