• Skip to main content
  • Skip to primary sidebar
  • 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

Thanh Chau

IBM Planning Analytics Tips & Tricks

IBM Planning Analytics Tips & Tricks: Correctly Sum Rounded Numbers in Excel

 

Almost everyone has created Excel reports that round numbers to the thousands or millions. With such reports there are sometimes situations where the displayed total does not match the displayed components. We can see the revenue sums correctly when looking at the natural…

Read More

May 25, 2022

IBM Planning Analytics Tips & Tricks

IBM Planning Analytics Tips & Tricks: Using Charts and Data Series with Dynamic Reports

 

IBM Planning Analytics Workspace has several chart visualizations that you can use in place of Explorations. However, this functionality is not available in Planning Analytics for Excel (PAx). Excel has its own chart functionality, but it gets a bit tricky if we want to…

Read More

March 15, 2022

IBM Planning Analytics Tips & Tricks

IBM Planning Analytics Tips & Tricks: Updating ODBC Connections for Multiple Processes

 

As of version 2.0.69 of IBM Planning Analytics Workspace (PAW), you are now able to update the ODBC connection for multiple TurboIntegrator (TI) processes at once. For prior versions, you would have needed to open each process to update the connection. To utilize…

Read More

February 8, 2022

IBM Planning Analytics Tips & Tricks

IBM Planning Analytics Tips & Tricks: PAx Writeback Mode

 

As of version 2.0.68 of IBM Planning Analytics for Excel (PAx), a new toggle was added to the IBM Planning Analytics ribbon that allows users to decide how DBRW formulas are treated when data is entered. Prior to version 2.0.68, this option was…

Read More

November 9, 2021

IBM Planning Analytics Tips & Tricks

IBM Planning Analytics Tips & Tricks: Making Assets Accessible to Applications and Plans

 

When creating Applications and Plans in IBM Planning Analytics Workspace (PAW), PAW views, PAW books, and websheets can be assigned to guide each step of the business process. These objects are collectively called “Assets." Although these objects are available from PAW books, they…

Read More

May 25, 2021

IBM Planning Analytics Tips & Tricks

IBM Planning Analytics Tips & Tricks: Converting Existing Applications

 

IBM Planning Analytics version 57 introduced applications and plans which let you organize Planning Analytics Workspace (PAW) assets such as books, view, and websheets into groups. These approaches allow you to group items together in sections (similar to a folder) or in steps…

Read More

April 6, 2021

IBM Planning Analytics Tips & Tricks

IBM Planning Analytics Tips & Tricks: Introduction to Apps and Plans

 

As of version 58 of IBM Planning Analytics Workspace (PAW), IBM introduced new features called Applications and Plans. These are meant to guide business processes by centralizing and organizing required tasks to make sure that all steps are completed in the correct…

Read More

March 16, 2021

IBM Planning Analytics Tips & Tricks

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

 

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…

Read More

December 22, 2020

IBM Planning Analytics Tips & Tricks

IBM Planning Analytics Tips & Tricks: Asymmetric Axis in PAW

 

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…

Read More

December 1, 2020


VIEW MORE ARTICLES >

1 2Next Page » 2

Primary Sidebar

  • Categories

    • Accounting and Accounts Receivable
    • Awards & Recognition
    • Data Analytics in Finance
    • Financial Close & Consolidation
    • FP&A Done Right
    • IBM Planning Analytics Tips & Tricks
    • News & Events
    • Success Stories
    • Tech Bulletins
    • Workday Adaptive Planning Insights
    • Workday Adaptive Planning Tips & Tricks

Popular Posts

Authors

Adam Riskin
Adam Riskin
Brian Colucci
Brian Colucci
Brian Combs
Brian Combs
Cameron Burke
Cameron Burke
Dave Miersch
Dave Miersch
Ivan Cepero
Ivan Cepero
John Pra Sisto
John Pra Sisto
Jonathan Dunn
Jonathan Dunn
Ken Wolf
Ken Wolf
Lee Lazarow
Lee Lazarow
Lisa Minneci
Lisa Minneci
Luke Griffie
Luke Griffie
Marc Assenza
Marc Assenza
Mary Luchs
Mary Luchs
Michael Mari
Michael Mari
Michelle Song
Michelle Song
Revelwood
Revelwood
Robert Nordhagen
Robert Nordhagen
Simon Foley
Simon Foley
Thomas McDade
Thomas McDade

Sign up for our newsletter

Connect

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.