• 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

Planning Analytics Forecasting model

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 Analytics Forecasting model

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

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.