IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Maintaining Subset-Driven Consolidations
Did you know you can create a TurboIntegrator process to replace a TM1 feature? While the vast majority of TM1 features are still available in Planning Analytics, one feature that has been eliminated is the ability to automatically utilize subsets as consolidations…
September 10, 2019
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Best Practices for Hierarchies
Did you know IBM Planning Analytics hierarchies are used to see alternative data rollups in the same view? By default, all dimensions include a single hierarchy based on the original definition. Creating multiple hierarchies in a dimension is initially disabled in Planning…
June 25, 2019
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: The Benefits of Using Hierarchies
Did you know there are several benefits to using hierarchies in IBM Planning Analytics? Hierarchies are one of the additional features available in Planning Analytics. The main benefit of hierarchies is that they enable users to see alternative data rollups in the…
April 2, 2019
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Workarounds for Unsupported Excel Functions in TM1 Web
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…
November 6, 2018
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Recalculating Excel Worksheets
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,…
October 9, 2018
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Creating a Simple Dashboard in Planning Analytics Workspace
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.…
August 14, 2018
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Workarounds for Unsupported Excel Functions in TM1 Web
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…
August 7, 2018
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Performance Monitoring, Part 2
Did you know there are easy ways to address resource issues in order to have a finely tuned IBM Planning Analytics environment? This is the second in a two-part series about monitoring the performance of your server to maintain a working TM1…
March 13, 2018
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Performance Monitoring, Part 1
Did you know that server resources are vitally important to maintaining a working TM1 system? In this two-part blog series, I’ll review methods for monitoring the resources available on your server and the ways in which you can address most issues that…