IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Combining the DIMIX and DIMNM Functions
In a previous blog, we defined how to convert an alias back to the original element name within a TurboIntegrator script. The DimensionElementPrincipalName function is only valid for TI scripts, so what happens if you need to perform the same logic in a…
January 11, 2022
Financial Close & Consolidation
Modern Accounting: The Importance of Robotic Process Automation in Accounting
This is a guest blog post from our partner BlackLine, written by David Brightman, on the impact of robotic process automation in accounting. Robotic process automation (RPA) is a general set of automation tools for replicating any manual, repetitive process at scale, often by automating…
January 6, 2022
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: TM1PRIMARYDBNAME
Did you know there is a function to dynamically retrieve your database server name in IBM Planning Analytics for Excel (PAx)? When creating reports and input templates in Planning Analytics for Excel you must reference the TM1 server name you are pulling/pushing…
January 4, 2022
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: How to Download IBM Software
IBM has recommended a new IBM Planning Analytics Workspace patch to address the recently discovered Apache log4j vulnerability. Many of our clients have asked questions about how to download their software from IBM. Here are the basic steps you can take to download…
December 28, 2021
BPM Pulse Survey 2021: 96% of Respondents Say Performance Management Solutions Met or Exceeded Expectations
Every year BPM Partners surveys finance and other leaders from end user organizations for their views on the state of performance management (also called business performance management or corporate performance management). This year’s study looked at a number of aspects of performance management, such…
December 22, 2021
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Converting an Alias Back to the Element Name in TurboIntegrator
Have you ever needed to convert an alias back to the original element name within an IBM Planning Analytics TurboIntegrator script? Maybe you have a data source where the value entails an alias but further logic references the element code. You can…
December 21, 2021
Technical Bulletin: Update to Log4j Vulnerability’s Impact on IBM Planning Analytics
Updated December 21, 2021 Summary Multiple vulnerabilities have been discovered involving Apache Log4j. This was originally known as CVE-2021-44228, but it has been expanded to also include both CVE-2021-45046 and CVE-2021-45105. Apache Log4j is used by IBM Planning Analytics Workspace as part of its…
December 21, 2021
FP&A Done Right: The Office of Finance’s Powerplay — Activity-Based Planning
This is a guest blog post from Christopher Howard, senior channel manager at Workday Adaptive Planning. “I want to skate to where the puck is going, not where it has been.” – Wayne Gretzky Disruption in business means the puck is no longer where…
December 17, 2021
Financial Close & Consolidation
Prepaid Expenses Account Reconciliation in BlackLine
In today’s Quick Take video, Adam Riskin demonstrates how to create and certify a prepaid expense account in BlackLine. Prepaid expenses can be a time consuming and tedious task when doing reconciliations in Excel. BlackLine provides a streamlined and efficient process for this through…