IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Excel’s CONCAT and TEXTJOIN Functions
Microsoft Excel has recently introduced a new version of the CONCATENATE function called CONCAT. The purpose is similar in that the new function still combines text from multiple ranges and/or strings. CONCAT will eventually replace CONCATENATE, but Microsoft has not released plans…
February 4, 2020
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Excel’s IFS Function
While the IF function has been around for a while now, IFS is new to Excel. This function checks whether one or more conditions are met and then returns the value associated with the first TRUE condition. The main objective of IFS…
January 21, 2020
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…