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…
May 23, 2022
Optimize your Business Processes for Planning, Reporting and Analysis
When was the last time you examined – and optimized – your planning processes? Have you made adjustments over the last few years to accommodate changing office habits, work from home environments and mergers and acquisitions? If your business is like most,…
May 20, 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
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Excel’s XMATCH Function
Have you ever wanted to search a list and define the position where it appears in the list? Maybe you want to know how many sales reps exceeded their quota or want to define how many products cost more than an approved purchase…
May 17, 2022
Modern Accounting: Easier Intercompany Transactions
This is a guest blog post from our partner BlackLine, explaining five ways to make intercompany transactions easier and avoid the mess at month-end closing. Table of contentsWhat Are Intercompany Transactions?1. Identify the Type of Transaction and Set up a Standard Process…
May 12, 2022
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Adding a New Entry to Index Cube via Dynamic Report
If your IBM Planning Analytics model contains a cube that uses an index or slot dimension, you may encounter a situation where you’ll need to create a template that will allow your users to add data to an unused index. Below is…
May 10, 2022
FP&A Done Right: ESG Reporting Tools
There is a wide range of reasons why ESG (environmental, social, governance) reporting is an exploding market. One reason is that consumers care about ESG. PwC’s 2021 Consumer Intelligence Series survey reports that 91% of business leaders believe their company has a…
May 6, 2022
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Excel Workbook Stats
Have you ever wanted to know details about your existing worksheet or workbook such as the number of cells that contain data or the number of total sheets? In 2021, Microsoft Excel introduced a feature called Workbook Statistics that will provide details about…