Revelwood, Author at Revelwood Knowledge Center – Page 2 of 7
Revelwood, Author at Revelwood Knowledge Center – Page 2 of 7

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


This is a guest post from Revelwood’s Shane Bethea. Did you know you can create a new path to an existing Windows folder without breaking the original path when working in IBM Planning Analytics and TM1? An example of this is when you have a TurboIntegrator (TI) process that writes log files to a path that is several folders deep, but you want to simplify the path. Windows allows you to create something called a directory junction that points to the … Read More


This is a guest post by Revelwood’s Nina Gordy. Did you know it’s easy to create a simple dashboard in IBM Planning Analytics Workspace? IBM Planning Analytics Workspace dashboards allow you to provide quick and effective information to the end user. The following steps demonstrate how to create a simple dashboard. Navigate to your instance of Planning Analytics Workspace (PAW). Select New > Book from template. Note: By selecting New > Book, PAW will automatically open a new tabbed workbook. … Read More


This is a guest blog post from Revelwood’s Nina Gordy. Did you know there are a number of workarounds for unsupported Excel functions in TM1 Web? Have you ever published a TM1 Web report, only to see repeating #NAME errors when you access the report online? These are typically caused by unsupported Excel functions. While TM1 Web does support most Excel functions, there are some that it does not. Here, I’ll demonstrate ways to work within these limitations by providing … Read More


VIEW MORE ARTICLES >


‹ Previous123Next ›Last »

Never miss another post.

Sign Up for Our Newsletter.