IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Excel CubeDimensionCountGet Function
Have you ever written a TurboIntegrator process and needed to know how many dimensions are in a specific cube? Maybe you want to loop through each dimension to create a zero out view. You can do this by using the TABDIM function…
June 21, 2022
FP&A Done Right: The Changing Role of the CFO
This is a guest blog post from our partner Workday Adaptive Planning, explaining strategy and vision for the Office of Finance. Companies are asking more of their CFOs than ever before. They’re expected to lead environmental, social, and governance (ESG) initiatives, oversee…
June 17, 2022
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
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
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
Workday Adaptive Planning Tips & Tricks
Workday Adaptive Planning Tips & Tricks: Show Actuals for Linked Accounts
This week’s Workday Adaptive Planning and Reporting Tips & Tricks post explains an option in thestructure options for GL accounts, custom accounts and assumption accounts. The wording is not explicit and is actually misleading. If the developer wants the actual data to…
May 18, 2022
FP&A Done Right: Continuous Planning Leads to Agile Businesses
This is a guest blog post from our partner Workday Adaptive Planning. The author, Bob Hansen, explaining the value of continuous planning. Too many enterprises know firsthand the planning challenges that result from trying to achieve business agility during a time of…
April 22, 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…
April 19, 2022
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Planning Analytics Workspace Process Editor Function Help
Do you know how to use the function help button when developing processes in IBM Planning Analytics Workspace (PAW)? Within the scripting editor there is an fx button on the far-right hand side of the screen as seen below. When the button is…