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

PAW

IBM Planning Analytics Tips & Tricks: PAW Exploration Icons

November 26, 2024 by Lee Lazarow

Have you ever been in a situation where you wanted your users to reference an exploration or chart on your IBM Planning Analytics Workspace (PAW) page, but you didn’t want to give them full access to make changes? You can do this by editing the toolbar to include or exclude icons.

This setting is found within the Properties area within the Custom, Toolbar section. Here is a sample of the options for an exploration:

A screenshot of a computer

Description automatically generated

Not all icons are configurable (for example, the zero suppression icon will always be available to users), but each item in the list uses a simple on/off trigger to determine if the icons should appear for end users.

Here is an example with the “Edit MDX” icon enabled:

And here is an example with the “Edit MDX” icon disabled:

As you can see, disabled icons will completely disappear from the list.

This approach provides an easy way to simplify the ribbon for your end users.

Revelwood is an IBM Gold Business Partner with 25+ years of experience designing, developing, implementing and maintaining IBM Planning Analytics environments. Revelwood has helped clients in all sizes across all industries optimize and grow their use of Planning Analytics. Revelwood’s Planning Analytics team consists of experienced PA experts, including a multi-year IBM Champion.

Stay up to date with PA – sign up for our weekly Planning Analytics Tips & Tricks newsletter, subscribe to our YouTube channel, and join our IBM Planning Analytics All-Stars group on LinkedIn.

Read more IBM Planning Analytics Tips & Tricks

IBM Planning Analytics Tips & Tricks: High Availability in Version 12

IBM Planning Analytics Tips & Tricks: ASCIIOUTPUT

IBM Planning Analytics Tips & Tricks: Upcoming Changes to Planning Analytics

Home » PAW

Filed Under: IBM Planning Analytics Tips & Tricks Tagged With: IBM, IBM Planning Analytics, PAW, PAW explorations, Planning Analytics Workspace

IBM Planning Analytics Tips & Tricks: Learn how to use Snap Commands in IBM Planning Analytics

October 22, 2019 by Lisa Minneci Leave a Comment

Tips & Tricks

IBM Planning Analytics has a feature, snap commands, that simplifies various routine tasks. In our latest IBM Planning Analytics Tips & Tricks video, Revelwood’s FP&A Technical Director, Lee Lazarow demonstrates how snap commands in Planning Analytics allow you to change computer jargon into natural language wording.

In this video, Lee takes you through an example looking at operating expenses. He explains how Planning Analytics has built-in intelligence that is smart enough to understand typos or give you a list of options.

Watch Snap Commands in IBM Planning Analytics and learn:

  • How to turn on snap commands in the Planning Analytics Workspace (PAW) ribbon
  • How to use simple snap commands
  • How to hide a column

Snap commands simplify Planning Analytics, making your life easier!

IBM Planning Analytics, which TM1 is the engine for, is full of new features and functionality. Not sure where to start? Our team here at Revelwood can help. Contact us for more information at info@revelwood.com. And stay tuned for more Planning Analytics Tips & Tricks weekly in our Knowledge Center and in upcoming newsletters!

Check out our IBM Planning Analytics Tips & Tricks video series:

Regions with Rules in IBM Planning Analytics

Bookmarking in IBM Planning Analytics

Home » PAW

Filed Under: IBM Planning Analytics Tips & Tricks, Videos Tagged With: Analytics, Beyond Budgeting, Budgeting, Budgeting Planning & Forecasting, Financial Performance Management, IBM Cognos TM1, PAW, Planning & Forecasting, Planning & Reporting, Planning Analytics Tips & Tricks, Planning Analytics Workspace, snap commands, TM1

Revelwood Launches Report Conversion Service for Migrating Excel & TM1 Web Reports to PAx

October 17, 2019 by John Pra Sisto Leave a Comment

News & Events

Revelwood has launched a new Report Conversion service to help TM1 users to migrate their Excel and TM1 Web (Websheets) reports to Planning Analytics for Excel (PAx). Our service also helps TM1 users recreate their existing Excel or TM1 Web reports in PAx.

As with all the aspects of migrating from TM1 to Planning Analytics, there is a significant benefit to migrating existing reports to the new platform. The biggest of these benefits is improving performance. When you migrate to, or recreate these reports in PAx, you’ll also be able to take advantage of both Active Forms and MDX to make the new versions of your reports truly dynamic.

Migrating reports can be time-consuming. But it also presents the opportunity to review your report library and assess which reports you actually need and which ones you can retire. Rather than get overwhelmed with the prospect of assessing and moving your reports, let us help you.

Revelwood’s report conversion service consists of:

  • Conversion – We’ll convert your Excel reports from TM1 Perspectives to PAx. We’ll work with you to make sure the new reports look the way you want them to look, execute correctly, and render as Websheets where appropriate. We’ll use our own tools we’ve developed, specifically designed to streamline the conversion process. We’ll also make sure you have easy access to all the reports in your report library.
  • Optimization – Over time reports tend to become laden with too much information, or, on the flip slide, missing data elements. They also end up with hidden hard-coded values, errors, and performance issues. Our Report Conversion service includes automating and optimizing for accuracy and improved performance. You’ll save time and eliminate errors in your ongoing reporting process.
  • Rationalization – We’ll work with you to rationalize your reporting strategy. Together we’ll determine which reports you need and which reports can be combined to save time and effort. We’ll decide which reports need to be rendered in Planning Analytics Workspace (PAW) and accessed via a browser, instead of in Excel. We’ll also help you determine if Quick Reports and/or Explorations should be used instead of the traditional DBRW-style reports from TM1.
  • Education – We’ll make you self-sufficient in creating and maintaining PAx reports going forward! Our team will train you on PAx, with an emphasis on how to build well-designed, dynamic financial reports that leverage the best of both Planning Analytics and Excel.

Migrating your existing reports to Planning Analytics presents a unique opportunity to assess your reporting strategy, optimize and streamline your reports. Don’t just migrate your reports wholesale. Let us help you convert and make the most out of your reports.

Questions? Just drop me an email!

Home » PAW

Filed Under: News & Events Tagged With: Financial Performance Management, IBM Cognos TM1, IBM Planning Analytics, PAW, PAx, PAx reports, Planning Analytics for Excel, Planning Analytics Workspace, report conversion services, Revelwood, TM1, TM1 Perspectives, TM1 web

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.