• 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

IBM Planning Analytics Tips & Tricks

IBM Planning Analytics Tips & Tricks

IBM Planning Analytics Tips & Tricks: Excel CubeDimensionCountGet Function

 

Have you ever written a TurboIntegrator process and needed to know how many dimensions are in a specific cube? Maybe you want to loop through each dimension to create a zero out view. You can do this by using the TABDIM function…

Read More

June 21, 2022

IBM Planning Analytics Tips & Tricks

IBM Planning Analytics Tips & Tricks: PAW Chart Multicolors

 

One of the visualizations in Planning Analytics is a column chart. This type of chart is a good way to compare items since all the lines are in proportion to each other. An easy way to create a column chart is to…

Read More

June 14, 2022

IBM Planning Analytics Tips & Tricks

IBM Planning Analytics Tips & Tricks: NumberToStringEx

 

IBM Planning Analytics has the ability to export data to flat files with the use of the ASCIIOUTPUT and TEXTOUTPUT functions. However, these two functions will only accept string variables. That means that numeric data will first need to be converted to…

Read More

June 7, 2022

IBM Planning Analytics Tips & Tricks

IBM Planning Analytics Tips & Tricks: WildcardFileSearch

 

Depending on your business process, you may need to load similar data from multiple files. One such example is loading headcount from different HR systems. This may be necessary if your company has gone through a merger. Another example is if you have forecast data…

Read More

May 31, 2022

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: Planning Analytics Workspace Visualization Axis

 

Did you know you are able to create custom axis labels for IBM Planning Analytics Workspace (PAW) visualizations? Below is a column visualization that shows periods on the x-axis and a net income amount on the y-axis. As you can see, a generic…

Read More

May 24, 2022

IBM Planning Analytics Tips & Tricks

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

 

Have you ever wanted to search a list and define the position where it appears in the list? Maybe you want to know how many sales reps exceeded their quota or want to define how many products cost more than an approved purchase…

Read More

May 17, 2022

IBM Planning Analytics Tips & Tricks

IBM Planning Analytics Tips & Tricks: Adding a New Entry to Index Cube via Dynamic Report

 

If your IBM Planning Analytics model contains a cube that uses an index or slot dimension, you may encounter a situation where you’ll need to create a template that will allow your users to add data to an unused index. Below is…

Read More

May 10, 2022

IBM Planning Analytics Tips & Tricks

IBM Planning Analytics Tips & Tricks: Excel Workbook Stats

 

Have you ever wanted to know details about your existing worksheet or workbook such as the number of cells that contain data or the number of total sheets? In 2021, Microsoft Excel introduced a feature called Workbook Statistics that will provide details about…

Read More

May 3, 2022


VIEW MORE ARTICLES >

< Prev Page 14 15Next Page » 41

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 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
Julia Seelin
Julia Seelin
Ken Wolf
Ken Wolf
Lee Lazarow
Lee Lazarow
Lisa Minneci
Lisa Minneci
Luke Griffie
Luke Griffie
Marc Assenza
Marc Assenza
Mary Luchs
Mary Luchs
Michelle Song
Michelle Song
Revelwood
Revelwood
Robert Nordhagen
Robert Nordhagen
Sarah Hildenbrand
Sarah Hildenbrand
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.