• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer
Revelwood

Revelwood

  • 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
      • Advisory Services
      • Customer Care
        • Help Desk
        • System Admin
        • Performance Tune-Up
      • Training
        • Workday Adaptive Planning Training
        • IBM Planning Analytics / TM1 Training
    • PRODUCTS
      • DataMaestro
      • Lightspeed Planning & Reporting
      • IBM Planning Analytics Utilities
  • How We Help
    • Workday Adaptive Planning Use Cases
    • IBM Planning Analytics Use Cases
    • Client Success Stories
  • How We Think
    • Knowledge Center
    • Events
    • News
    • User Groups
  • Contact Us

IBM Planning Analytics

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: Planning Analytics Workspace Process Editor Function Help

 

Do you know how to use the function help button when developing processes in IBM Planning Analytics Workspace (PAW)? Within the scripting editor there is an fx button on the far-right hand side of the screen as seen below. When the button is…

Read More

April 12, 2022

Tips & Tricks

IBM Planning Analytics Tips & Tricks

IBM Planning Analytics Tips & Tricks: Refresh PAW Visualizations Automatically

 

Did you know that you can have IBM Planning Analytics Workspace (PAW) visualizations refresh automatically? To enable this setting, first make sure you are in “Edit” mode within your PAW book. You can then click on your visualization then click “Properties” in the…

Read More

March 29, 2022

IBM Planning Analytics Tips & Tricks

IBM Planning Analytics Tips & Tricks: Improve Workbook Performance

 

Did you know that defined name ranges can impact IBM Planning Analytics for Excel (PAx) report performance and the performance of Excel workbooks and worksheets themselves? It’s true! When workbooks are reused repeatedly for reporting purposes, defined worksheet names are stored within the…

Read More

March 22, 2022

Tips & Tricks

IBM Planning Analytics Tips & Tricks

IBM Planning Analytics Tips & Tricks: PASS Version Numbering

 

IBM released version 73 of IBM Planning Analytics Spreadsheet Services (PASS), formerly known as TM1 Web, on February 10, 2022. This version includes a few design improvements associated with stylesheets and sorting. The main change, however, is associated with the version number. The February…

Read More

March 1, 2022

IBM Planning Analytics Tips & Tricks

IBM Planning Analytics Tips & Tricks: PAx – Rebuild Book vs Recreate Book

 

Are you familiar with the difference between the “Rebuild Book” button and the “Recreate Book” button in IBM Planning Analytics for Excel (PAx)? Both buttons are used to update the rows which appear on your Dynamic Reports and both buttons refresh the…

Read More

February 15, 2022

IBM Planning Analytics Tips & Tricks

IBM Planning Analytics Tips & Tricks: Modeling Books

 

Did you know IBM Planning Analytics Workspace (PAW) update 57 introduced a new type of PAW book? This new type of book is called a “Modeling Book.” A modeling book can be created by selecting the “Data and Models” tile at the…

Read More

January 18, 2022


VIEW MORE ARTICLES >

1 2Next Page » 27

Primary Sidebar

  • Categories

    • Awards & Recognition
    • FP&A Done Right
    • IBM Planning Analytics Tips & Tricks
    • Modern Accounting
    • News & Events
    • Success Stories
    • Tech Bulletins
    • Workday Adaptive Planning Insights
    • Workday Adaptive Planning Tips & Tricks

Popular Posts

  • Workday Adaptive Planning Tips & Tricks: The Formula Assistant – How To, Where & Why
  • Workday Adaptive Planning Tips & Tricks: Templates
  • IBM Planning Analytics Tips & Tricks: Troubleshooting Planning Analytics for Excel
  • Workday Adaptive Planning Named a Leader in Gartner Magic Quadrant for Cloud Financial Planning and Analysis Solutions 2020
  • Workday Adaptive Planning Tips & Tricks: Excel Reporting Using a Report Template

Sign up for our newsletter

Connect

Authors

  • John Pra Sisto
  • Revelwood
  • Adam Riskin
  • Ailenette Cruz
  • Brian Combs
  • Dave Miersch
  • Dillon Rossman
  • Gary Leiffer
  • Ken Wolf
  • Koury Reid
  • Lee Lazarow
  • Lisa Minneci
  • Marc Assenza
  • Mary Luchs
  • Michelle Song
  • Nina Inverso
  • Summer Jeter
  • Tara Byrnes
  • Thanh Chau
  • Wesley DeMarco

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

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