Dec 12 2024
IBM Planning Analytics for Excel 2.0.100 / 2.1.7
Explore the latest updates in IBM Planning Analytics for Excel (PAfE) version 2.0.100 / 2.1.7, released on December 11, 2024! This version showcases the new Preserve User Formulas feature for Universal Reports, enabling seamless report refreshes without losing your custom formulas. Learn how to configure this property for maximum efficiency. We also address a known issue with the ORDER function and provide a temporary workaround.
Details
- Version: 2.0.100 (v11) / 2.1.7 (v12)
- Released: December 11, 2024
What’s New
- 0:17 Universal Reports property: Preserve User Formula
Known Issue
- 0:49 Universal Report ORDER function error
Transcript
Hi TM1 and Planning Analytics community. It is Bryan from Cubewise. This version of Planning Analytics for Excel 2.0.100, also known as 2.1.7, was released on December 11, 2024 and includes one new feature. The Preserve User Formulas property for Universal Reports will allow you to confidently refresh the report without losing your carefully crafted formulas. To enable this property, simply edit the hidden format region of your report and add it to the p named range.
Set it to true and your formulas stay put no matter how often you refresh. Set it to false and TM1 Data will replace them during a refresh. There is one known issue with the order function in a Universal Report that would output this error message. This error is caused by the cube name missing in the MDX. The temporary fix is to add the cube name manually. And that wraps up the updates on IBM Planning Analytics for Excel.