IBM Planning Analytics

IBM Planning Analytics Tips and Tricks: Trusting the Directory where the Planning Analytics for Excel xll file resides.

October 3, 2023 by Marc Assenza

Have you ever received a notification from Excel stating that it was having an issue trusting the Planning Analytics for Excel (PAfe) Add-In? If so, you are not alone!

From time to time, it seems Excel needs to be reminded that the .xll file is a trusted file. To do this you will need to take the following steps:

Open Microsoft Excel and click on File, Options.

When the next screen appears, select “Trust Center” on the left-hand side pane and then “Trust Center Settings” on the right-hand side.

A screenshot of a computer

Description automatically generated with medium confidence

Next, click on the link that reads “Trusted Locations.”

A screenshot of a computer error message

Description automatically generated with low confidence

On the bottom right of the screen, click the button that says “Add new location.”

A yellow box with black text

Description automatically generated with low confidence

Browse to the drive and folder where your PAX xll file is located and define this as your path. Within the same window, also click the checkbox that allows subfolders to also be trusted.

A screenshot of a computer error message

Description automatically generated with medium confidence

Once complete, your Planning Analytics for Excel .xll file will be trusted.

IBM Planning Analytics, which TM1 is the engine for, is full of new features and functionality. Not sure where to start? Our team here at Revelwood can help. Contact us for more information at info@revelwood.com. And stay tuned for more Planning Analytics Tips & Tricks weekly in our Knowledge Center and in upcoming newsletters!

IBM Planning Analytics Tips & Tricks: Planning Analytics Workspace (PAW) Process Error Logs

September 26, 2023 by Lee Lazarow

Do you know how to use IBM Planning Analytics Workspace (PAW) to access error logs from your TurboIntegrator (TI) processes? It’s as simple as a single click!

To access your logs, right-click on the Processes node in the workbench and select the option for Error logs.

Once selected, a popup window will appear with a list of the existing logs. This window allows you to sort the list by process name or by date created.

There are two ways to view a log file:

Click on the box to the left of the process name
Click on the three vertical dots to the right of the date

Both methods will then let you view the log file or download the file.

This feature, when combined with PAW’s development tools, will allow you to fully develop and debug TurboIntegrator scripts using the PAW interface.

IBM Planning Analytics Tips & Tricks: Adding Images to Charts

September 12, 2023 by Ivan Cepero

Charts are an excellent way to use visuals to convey information. Did you know that you can increase the effect of charts in Excel by adding custom images?

Consider this plain pie chart.

Chart, pie chart

Description automatically generated

We can insert a corporate logo to give the chart a greater visual appeal and branding.

1 – Click on the chart to select it

2 – Right click and select “Format Chart Area”

3 – Select “Picture or texture fill”

A screenshot of a phone

Description automatically generated with medium confidence

4 – Select “Insert” to insert an image from your computer or “Clipboard” to insert a previously copied image

When clicking “Insert” you will see a pop up letting you pick various image sources.

Text

Description automatically generated

5 – You can further refine the options by having the image tile, offset or scale.

Here is the updated chart with the Revelwood logo applied, tiled and set with transparency level 80%:

You can also apply custom images to a specific data point (e.g. a pie slice in this example) by initially selecting the data point instead of the entire chart, then following the steps outlined above.

IBM Planning Analytics Tips & Tricks: Popular Video Tips, Part 3

August 29, 2023 by Ivan Cepero

Here are two more popular IBM Planning Analytics Tips & Tricks videos. Did you know we have an entire library of video tips & tricks for IBM Planning Analytics?

The Aggregate Function

In this video, Revelwood’s FP&A Technology Director, Lee Lazarow, demonstrates the aggregate function. The aggregate function allows you to summarize values that cannot be added up or averaged.

Creating Multi-Level Dimensions

Watch this video to learn how to create multi-level dimensions in Planning Analytics. This approach will let you create brand-new dimensions by simply dragging a file onto the screen. You’ll learn how to create a brand-new dimension using a file created in Notepad. See how Planning Analytics recognizes that the list is more than a list of leaf levels and more than just a parent/child relationship. You’ll also learn how to map the levels and add attributes.

Navigating the BPM Vendor Landscape: Key Insights from the 2023-2024 Report

August 25, 2023 by Revelwood

Business Performance Management (BPM) is a critical aspect of modern organizations, helping them streamline operations, enhance decision-making, and achieve their strategic goals. In the fast-paced world of BPM, choosing the right vendor and solution can be a daunting task.

The Vendor Landscape Matrix 2023-2024 Edition by BPM Partners provides a comprehensive overview of various BPM vendors, their capabilities, and customer satisfaction ratings, enabling organizations to make informed decisions. The Vendor Landscape Matrix, an annual report by BPM Partners, offers a comprehensive view of the BPM vendor landscape. The report delves into the specifics of various BPM vendors, highlighting their strengths, core capabilities, customer satisfaction ratings, and more.

According to the most recent report, “In the past 12 months, with a somewhat uncertain global economy, the need for performance management systems has continued to grow … The focus this year for companies looking for new or replacement systems are offerings that are integrated, intelligent, and intuitive.” The report also highlights that as extended planning and analysis (xP&A) grows into other areas of operations, “so does the need for seamless integration with a growing list of financial and operational source systems.” As a result, “the vendors are upgrading their data integration capabilities to keep up with this need.”

BPM Partners notes that “the next area of focus is intelligent performance management solutions. This includes both artificial intelligence (AI), as well as financial intelligence.” The report states that “the latest iterations of AI capabilities in most products are aimed at business users, not data scientists.” They define “financial intelligence” as the system “natively understand[ing] income/expense, asset/liability and balance/flow.”

BPM Partners Vendor Landscape Matrix is designed to provide “a point-in-time snapshot of all the core players, their status in the market, and the focus of their offerings.” The 2023-2024 Matrix covers the following BPM vendors: Aceterys, Anaplan, Board International, Centage, Fluence Technologies, IBM, JustPerform, OneStream, Pigment, Planful, Prophix, SAP, TalenTia, Unit4, Vena, Wolters Kluwer CCH Tagetik and XLerant.

Revelwood partners IBM (IBM Planning Analytics) and Fluence Technologies were named a Premier Leader (IBM) and a Leader (Fluence) in the 2023-2024 report. IBM received an Overall BPM Pulse rating of 4.14 (Very Good), while Fluence received an Overall BPM Pulse Rating of 4.67 (Outstanding).

IBM Planning Analytics

The BPM Partners report states that, “IBM Planning Analytics is designed for integrated and extensible planning and offers a unified set of capabilities for budgeting, planning, forecasting, analysis and reporting for financial as well as operational data.” The solution has an 82% recommendation rate. Recent developments include a new SaaS option for IBM Planning Analytics with AWS and IBM Envizi working with Planning for ESG reporting.

Fluence Technologies

According to BPM Partners, “The Fluence Close-to-Disclose platform is a cloud-based, consolidation-first solution that includes Fluence Account Reconciliation, Fluence Consolidation with out-of-the-box consolidation models and calculations, close management, Fluence Disclosure Management” and more. The solution has a 95% recommendation rate.

BPM Partners’ Vendor Landscape Matrix 2023-2024 Edition is a valuable resource for organizations seeking a comprehensive guide to BPM vendors. It offers detailed insights into vendors’ capabilities, customer satisfaction, and strengths, making it an indispensable tool for anyone embarking on their BPM journey. In a world where informed decisions drive success, this report empowers organizations to select the right BPM solution with confidence.

More from our FP&A Done Right Series:

Navigating Economic Volatility: Insights from CFOs

Workday Adaptive Planning Recognized with the 2023 Gartner Peer Insights Customers’ Choice for Financial Planning Software

No, Artificial Intelligence Will Not Replace Finance Jobs

IBM Planning Analytics Tips & Tricks: Counting Hidden Rows in Excel

August 22, 2023 by Ivan Cepero

With a clever combination of formulas, you can have Excel calculate the number of hidden rows in a data set. This trick will work on both manually hidden rows and autotfilter hidden rows.

There are two ways to count hidden rows, depending on how your data is structured. Both methods use the AGGREGATE function.

The syntax of AGGREGATE is:

=AGGREGATE(function_num,options,array)

Where

Function_num is one of the following:

Function_num	Function
1	AVERAGE
2	COUNT
3	COUNTA
4	MAX
5	MIN
6	PRODUCT
7	STDEV.S
8	STDEV.P
9	SUM
10	VAR.S
11	VAR.P
12	MEDIAN
13	MODE.SNGL
14	LARGE
15	SMALL
16	PERCENTILE.INC
17	QUARTILE.INC
18	PERCENTILE.EXC
19	QUARTILE.EXC

And options are one of the following:

Option	Behavior
Default	Ignore nested SUBTOTAL and AGGREGATE functions
1	Ignore hidden rows, nested SUBTOTAL and AGGREGATE functions
2	Ignore error values, nested SUBTOTAL and AGGREGATE functions
3	Ignore hidden rows, error values, nested SUBTOTAL and AGGREGATE functions
4	Ignore nothing
5	Ignore hidden rows
6	Ignore error values
7	Ignore hidden rows and error values

We will be leveraging option 5: Ignore hidden rows

Consider the example data set:

Application, table, Excel

Description automatically generated

Blank cells merit special treatment and will determine which method you use.

No Blanks in Data

If your data will have no blank (zeros are ok) like column D in the sample data set, you can use this formula to count the hidden rows:

=AGGREGATE(2,4,Table1[Feb])-AGGREGATE(2,5,Table1[Feb])

Blanks in Data

Table

Description automatically generated

If there are blanks in the data (as in column C), you will need to add a helper column in Excel. The helper column will use AGGREGATE for the cell in the same row and this converts a blank into a 0. Use the same formula as the first method but use the helper column instead of the original data.

=AGGREGATE(2,4,G3:G7)-AGGREGATE(2,5,G3:G7)

IBM Planning Analytics Tips & Tricks: Popular Video Tips, Part 2

August 15, 2023 by Revelwood

We’re continuing to highlight some of our most popular video tips & tricks for IBM Planning Analytics.

Creating Buttons for TI Scripts

In this video, Revelwood’s FP&A Technology Director, Lee Lazarow, demonstrates how to create a button in Planning Analytics Workspace (PAW) for a TurboIntegrator (TI) script. Creating buttons like this will simplify tasks for your end users and create a much better end user experience.

You’ll learn how to go into properties, determine the button target, make that into a process, and then select and choose that process. The features in PAW allow you to select if you want prompts to appear and what controls you have over those prompts.

Formatting Views in PAW

Watch this video to see Lee demonstrate how to format views in Planning Analytics Workspace (PAW). You’ll learn how to manipulate your views by:

Making columns wider
Changing row heights
Changing fonts and text styles
Adding shading, and more

IBM Planning Analytics Tips & Tricks: Performance Monitoring

August 8, 2023 by Andrew Chaves

IBM Planning Analytics contains a series of Performance Monitoring Control Cubes that let you record performance statistics for various aspects of your environment.

In Perspectives, this feature was enabled by right-clicking on the name of the server. But did you know that you can also control this in Planning Analytics Workspace via the tm1s.cfg control settings?

To enable the monitoring, go to the Administration area and then select the option for Databases. Once you have selected your database, click on “configuration.”

The performance monitor settings are found within the Administration settings and the Default sub area.

Once enabled (be aware that there may be an impact on performance when you use this), you will be able to use the results to help analyze your server performance.

IBM Planning Analytics Tips & Tricks: Popular Video Tips, Part 1

August 1, 2023 by Revelwood

Did you know we have a library of video tips & tricks for IBM Planning Analytics? Over the next few weeks we’re going to highlight some of our most popular videos for IBM Planning Analytics / TM1.

Filtering in IBM Planning Analytics

In this video, Revelwood’s FP&A Technology Director, Lee Lazarow, demonstrates how the Planning Analytics Workspace (PAW) interface enables you to manipulate elements in your subsets. The PAW interface allows for wild card searches and attribute searches. You’ll learn how PAW takes this a step further so that you can make your search criteria more structured, enabling you to filter by name, level, attribute and more.

Formatting Views in PAW

Watch this video to see Lee demonstrate how to format views in Planning Analytics Workspace (PAW). You’ll learn how to manipulate your views by:

Making columns wider
Changing row heights
Changing fonts and text styles
Adding shading, and more

IBM Planning Analytics Tips and Tricks: Trusting the Directory where the Planning Analytics for Excel xll file resides.

Read more IBM Planning Analytics Tips & Tricks: