• 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

TM1

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

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

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

Tips & Tricks

IBM Planning Analytics Tips & Tricks

IBM Planning Analytics Tips & Tricks: Combining the DIMIX and DIMNM Functions

 

In a previous blog, we defined how to convert an alias back to the original element name within a TurboIntegrator script. The DimensionElementPrincipalName function is only valid for TI scripts, so what happens if you need to perform the same logic in…

Read More

January 11, 2022

IBM Planning Analytics Tips & Tricks

IBM Planning Analytics Tips & Tricks: Converting an Alias Back to the Element Name in TurboIntegrator

 

Have you ever needed to convert an alias back to the original element name within an IBM Planning Analytics TurboIntegrator script? Maybe you have a data source where the value entails an alias but further logic references the element code. You can…

Read More

December 21, 2021

Technical Bulletin: Apache Log4j Vulnerability Impact on IBM Planning Analytics Models

Tech Bulletins

Technical Bulletin: Apache Log4j Vulnerability Impact on IBM Planning Analytics Models

 

Summary A vulnerability has been discovered involving Apache Log4j (CVE-2021-44228). Apache Log4j is used by IBM Planning Analytics Workspace as part of its logging infrastructure.  This may have a significant impact on your existing models. Details This issue impacts all users currently…

Read More

December 15, 2021


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.