IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: PAW Chart Multicolors
One of the visualizations in Planning Analytics is a column chart. This type of chart is a good way to compare items since all the lines are in proportion to each other. An easy way to create a column chart is to…
June 14, 2022
Financial Close & Consolidation
Modern Accounting: Using AR Automation to Boost Cash Flow
This is a guest blog post from our partner BlackLine, explaining how to gain cash flow confidence with AR automation. Table of contentsDisruptions, Borrowing & Inefficient ProcessesRaise the Bar With AR Automation Put simply, a significant reason businesses are struggling right now…
June 9, 2022
Workday Adaptive Planning Tips & Tricks
Workday Adaptive Planning Tips & Tricks: Revenue Cohort Modeling
Do you know about cohort modeling in Workday Adaptive Planning? A cohort model provides meaningful insight of data grouped into subsets based on any characteristic important to the company. The groups are called “cohorts.” Cohorts can be based on time (i.e. season,…
June 8, 2022
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…