IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: The SCAN Function
Have you ever needed to parse data by looking for a specific character within your source records? Maybe you want to filter an employee’s last name from a “Lazarow, Lee” or maybe you want to define the year from “12/25/2021”. All of…
January 25, 2022
Financial Close & Consolidation
Activity Analysis in BlackLine
Did you know BlackLine can save you a significant amount of time in your month, quarter and year-end close activities? In our latest BlackLine Quick Take video, Adam Riskin demonstrates how to use BlackLine to analyze your accounting team’s activity and therefore determine how…
January 20, 2022
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Modeling Books
Did you know IBM Planning Analytics Workspace (PAW) update 57 introduced a new type of PAW book? This new type of book is called a “Modeling Book.” A modeling book can be created by selecting the “Data and Models” tile at the…
January 18, 2022
FP&A Done Right: xP&A Should be in your Future
This is a guest blog post from our partner Workday Adaptive Planning, explaining why xP&A is the future of planning. With its promise of extending FP&A principles beyond finance and into other areas of the business, xP&A (extended planning and analysis) is…
January 14, 2022
Financial Close & Consolidation
Modern Accounting: Enhancing BlackLine Implementations with Expertise in the Office of Finance
In mid-2021 Revelwood announced a strategic partnership with BlackLine, a cloud-based finance and accounting platform. There are many clear benefits for Revelwood clients to add BlackLine to their best-of-breed solutions automating various activities in finance. The question for non-Revelwood clients might be: why turn to…
January 13, 2022
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…