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

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


This is a guest post from Revelwood’s Jay Apwah.  Did you know that there are reserved local variables that you can use in TurboIntegrator scripts? Reserved local variables are variables that do not need to be defined and are destroyed when the process finishes executing. This blog will describe three variables: Value_is_String, nValue, and sValue.  You will not find these on the variables tab and you cannot re-define them, but they are accessible.  These three variables can be accessed within … Read More


This is a guest post from Revelwood’s Shane Bethea. Did you know that you can prevent data entry to TM1 in TM1 Web websheets? Here are a couple of different ways to do this. The first approach can be used for input templates. Use this approach when you want your users to be able to enter data for certain cells/columns, but not others. By default, every cell in an Excel worksheet has the ‘Locked’ property set. This property has no … Read More


This is a guest post from Revelwood’s Shane Bethea. Did you know IBM Planning Analytics lets you make API calls through VBA in Planning Analytics for Microsoft Excel (PAx)? You probably know that action buttons can be used to refresh or rebuild reports in PAx. But what if you want to refresh the data in your report as part of a VBA routine? Maybe there are more tasks you want to perform through VBA and then you want to refresh … Read More


This is a technical bulletin from Revelwood’s Steve Ellis. Did you know that the latest version of Microsoft Office 365 caused Planning Analytics for Microsoft Excel (PAx) to become unusable?  I will show you how to determine if you have been impacted and how to resolve this. Root Cause:  This is not an issue with PAx.  This incompatibility was caused by the latest Microsoft Office update in May 2018.  IBM has logged the issue with Microsoft, and although Microsoft is … Read More


VIEW MORE ARTICLES >


12Next ›Last »

Never miss another post.

Sign Up for Our Newsletter.