• 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

Dillon Rossman

IBM Planning Analytics Tips & Tricks

IBM Planning Analytics Tips & Tricks: Dynamic Subsets Based on a Cube

 

Did you know you can use MDX to create dynamic subsets based on cube values in IBM Planning Analytics? In our example we will only show companies with net sales greater than 30,000,000 in the selected year.  An MDX statement that can…

Read More

June 28, 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: PAW Visualization Value Labels

 

Do you know how to add value labels for Planning Analytics Workspace (PAW) visualizations? On the column visualization below, you can see the bars but you cannot see the exact amount of each column. To enable value labels, ensure that you are…

Read More

April 26, 2022

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: 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

IBM Planning Analytics Tips & Tricks

IBM Planning Analytics Tips & Tricks: TM1PRIMARYDBNAME

 

Did you know there is a function to dynamically retrieve your database server name in IBM Planning Analytics for Excel (PAx)? When creating reports and input templates in Planning Analytics for Excel you must reference the TM1 server name you are pulling/pushing…

Read More

January 4, 2022

IBM Planning Analytics Tips & Tricks

IBM Planning Analytics Tips & Tricks: Accessing Books

 

Did you know that there are now two ways to access books in IBM Planning Analytics Workspace (PAW)?   Previously, you could access books via the “Shared", “Personal”, and “Users” folders in the bottom section of the home page. This option still…

Read More

June 8, 2021

IBM Planning Analytics Tips & Tricks

IBM Planning Analytics Tips & Tricks: Home Page Refresh

 

Did you know that the home page has received a major refresh in IBM Planning Analytics Workspace (PAW) update 57?   Previous versions of PAW contained a lot of unused space and the look and feel changed as you moved from the…

Read More

April 27, 2021

IBM Planning Analytics Tips & Tricks

IBM Planning Analytics Tips & Tricks: Database Administration

 

Did you know that database administration page has been updated in IBM Planning Analytics Workspace (PAW)?   In previous versions of PAW you would click on a database and it would present detailed information as seen below. With the “Database Settings” button…

Read More

April 13, 2021


VIEW MORE ARTICLES >

1 2Next Page » 2

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.