IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: NumberToStringEx
IBM Planning Analytics has the ability to export data to flat files with the use of the ASCIIOUTPUT and TEXTOUTPUT functions. However, these two functions will only accept string variables. That means that numeric data will first need to be converted to…
June 7, 2022
Workday Adaptive Planning Tips & Tricks
Workday Adaptive Planning Tips & Tricks: Check Boxes in Modeled Sheets
As part of the 2022R1 release, Workday Adaptive Planning has enabled some new enhancements for Modeled Sheets. I am most excited for the checkbox capability, a new feature for Modeled Sheets. In addition to being a nice visual icon for users in…
June 1, 2022
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: WildcardFileSearch
Depending on your business process, you may need to load similar data from multiple files. One such example is loading headcount from different HR systems. This may be necessary if your company has gone through a merger. Another example is if you have forecast data…
May 31, 2022
FP&A Done Right: Financial Forecasting Processes that Guide Business Strategy
This is a guest blog post from our partner Workday Adaptive Planning, outlining nine ways to plan in the changing world of finance. Table of contentsStep 1: Define Your TermsStep 2: Model Your RevenueStep 3: Model Your ExpensesStep 4: Set Your CadenceStep…
May 27, 2022
Financial Close & Consolidation
Modern Accounting: Achieving Finance Transformation
This is a guest blog post from our partner BlackLine, explaining four essential steps for transformation success. Making the Move to F&A Digital Transformation For controllers, CFOs, CTOs, and business leaders in general, planning a move to digital finance transformation can be…
May 26, 2022
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Correctly Sum Rounded Numbers in Excel
Almost everyone has created Excel reports that round numbers to the thousands or millions. With such reports there are sometimes situations where the displayed total does not match the displayed components. We can see the revenue sums correctly when looking at the natural…
May 25, 2022
Facing an IBM Planning Analytics / TM1 Talent Shortage?
There’s plenty of news about “The Great Resignation” or the talent shortage/war. In some cases, the challenge is not in finding someone, but in finding the right skills. This is particularly true for companies searching for people with IBM Planning Analytics /…
May 25, 2022
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Planning Analytics Workspace Visualization Axis
Did you know you are able to create custom axis labels for IBM Planning Analytics Workspace (PAW) visualizations? Below is a column visualization that shows periods on the x-axis and a net income amount on the y-axis. As you can see, a generic…
May 24, 2022
Introducing DataMaestro, the Data Orchestration Platform for IBM Planning Analytics / TM1
We’ve just released a new product designed to make the lives of IBM Planning Analytics / TM1 systems administrators’ easier. DataMaestro is a solution for managing and moving data that saves Planning Analytics / TM1 users significant time and money by making…