Have you ever generated an IBM Planning Analytics Workspace (PAW) exploration and struggled to read the values in the grid? For example, how easy is it to define the travel cost for department 55 in the screenshot below?

A few years ago, I wrote a blog post about solving this in Excel by using formulas to shade every other row. This approach is built into PAW via an option called “Zebra strips.” You can enable this option within the Custom properties of an exploration:

Once enabled, PAW will lightly shade every other row to allow you to quickly navigate through your exploration. Using the example from earlier, it is now much easier to define the travel cost for department 55.

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!

Read more IBM Planning Analytics Tips & Tricks:

IBM Planning Analytics Tips & Tricks: PAW “Spacers”

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

IBM Planning Analytics Tips & Tricks: Excel Switch Function