Revelwood, Author at Revelwood Knowledge Center
Revelwood, Author at Revelwood Knowledge Center

This is a guest post from Revelwood’s Shane Bethea. Did you know IBM Planning Analytics Workspace (PAW) has a new feature that lets you easily duplicate sheets? Have you ever created a template or dashboard in PAW and thought, “This is a great format. I wish I could quickly replicate this sheet to show several different views of the same information?” PAW has a great feature called ‘Duplicate’ that will allow you to duplicate a sheet as many times as … Read More


This is a guest post from Revelwood’s Jay Apwah. Did you know that since IBM Planning Analytics was released on the cloud, there have been changes to IBM Planning Analytics server configuration parameters? New parameters have been introduced, existing ones have had their default values changed, and the behavior upon changing has changed for some others. This blog post briefly describes the eight changes.   New Parameters: There are a handful of new parameters that have been introduced. Here is … Read More


This is a guest blog post from Revelwood’s Nina Gordy.  Did you know there are a number of workarounds available for Excel functions that are not supported by TM1 Web? This blog post is the second in a series discussing these workarounds. Below, I’ll describe ways to accomplish the same results using functions that are compatible online.   Function: CELL Description: Returns information about the formatting, location, or contents of a cell Please note that workarounds only exist for some of the … Read More


This is a guest blog post from Revelwood’s Shane Bethea. Did you know that you can use the IBM Planning Analytics for Excel (PAx) Set Editor to create dynamic sets to be used in a view? This can be accomplished by using the ‘Search available members’ bar in the set editor. I will use the bpmAccount dimension in this example. Start by opening the set editor in PAx. Right click the bpmAccount dimension (or click the drop down arrow by … Read More


This is a guest blog post from Revelwood’s Nina Gordy. Did you know there are various shortcuts to force calculations in Excel, and that there is a shortcut that does this for TM1 Perspectives and Planning Analytics for Excel (PAx) as well? Rather than searching for a button in the Excel ribbon, it’s often easier and more efficient to use keyboard shortcuts to refresh calculations. This post describes the various shortcuts available to force calculations in Excel for Windows, including … Read More


This is a guest blog post from Revelwood’s Shane Bethea. Did you know that the IBM Planning Analytics for Excel (PAx) Set Editor has a new, simplified way of selecting dimension elements for a view? As of PAx version 2.0.34, this can be done with a new feature called ‘Replace and Close’. This new feature is available in the newer report types in PAx (Explorations and Quick Reports), as well as in the PAx cube viewer. The following Exploration view … Read More


VIEW MORE ARTICLES >


12Next ›Last »

Never miss another post.

Sign Up for Our Newsletter.