Revelwood Knowledge Center – Page 2 of 21 – Analytics that impact.
Revelwood Knowledge Center – Page 2 of 21 – Analytics that impact.

Nucleus Research’s “CPM Technology Value Matrix 2017” named IBM a leader in Corporate Performance Management (CPM) solutions and found that “recent changes to its CPM products focus both on personal functionality and usability, empowering a greater diversity of individual users with more tools.”   Based on its assessment of 17 vendors offering CPM products, the research firm determined that there are two types of CPM products: “those that are tightly integrated with Excel and those that try to reimagine CPM … Read More


Did you know you can create a single hierarchy that contains all year-to-date values within an entire year? As you know, TM1 is a consolidation tool which is designed to sum together a series of values.  There are many ways to create the consolidations using a combination of grand totals and sub totals.  This blog specifically addresses the year-to-date (YTD) hierarchy associated with a time dimension. Many clients prefer to create a single hierarchy that contains all YTD values within … 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


Every week we publish a new blog post on IBM Planning Analytics Tips & Tricks. Some of these focus on how to use new features in IBM Planning Analytics and others explain how to optimize key aspects of the core TM1 engine. We took a look at our analytics (yes, we don’t just implement analytics, we use them too!) to see which blog posts with tips & tricks are the most popular with Revelwood clients and visitors to Revelwood’s Knowledge … 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


VIEW MORE ARTICLES >


‹ Previous123Next ›Last »

Never miss another post.

Sign Up for Our Newsletter.