• Skip to main content
  • Skip to footer
Revelwood Logo

Revelwood

Your SUPER-powered WP Engine Site

  • Who We Are
    • About Us
      • Our Company
      • Our Team
      • Partners
    • Careers
      • Join Our Team
  • What We Do
    • Solutions
      • Workday Adaptive Planning
      • IBM Planning Analytics
      • BlackLine
    • Services
      • Implementation Services
      • Customer Care
        • Help Desk
        • System Administration as a Service
      • Training
        • Workday Adaptive Planning Training
        • IBM Planning Analytics / TM1 Training
    • Products
      • DataMaestro
      • LightSpeed
      • IBM Planning Analytics Utilities
  • How We Help
    • Use Cases
    • Client Success Stories
  • How We Think
    • Knowledge Center
    • Events
    • News
  • Contact Us

Financial Performance Management

IBM Planning Analytics Tips & Tricks: PAW Pie Chart Total

January 23, 2024 by Lee Lazarow

Tips & Tricks from Revelwood

Pie charts are a type of visualization known as composition. Composition charts are designed to show the parts of a whole. This is a great way to look at the pieces of total. For example, the branches in a region or the months in a year.

Here is an example of a pie chart that shows operating expenses for a year:

IBM Planning Analytics Tips & Tricks: PAW Pie Chart Total

The great thing about this chart is that you can easily see the numbers for each quarter. I can also quickly see comparative values such as Q1 being much larger than Q4. However, what I cannot see is the total for the year.

IBM Planning Analytics Workspace allows you to include a “donut hole” and include the total in the center of the pie. This is enabled within the chart area of the properties by defining the radius percent.

IBM Planning Analytics Tips & Tricks: PAW Pie Chart Total

When combined with the option to “show inner label”, here is an example of the same chart with a donut hole of 50%:

IBM Planning Analytics Tips & Tricks: PAW Pie Chart Total

This approach will help you expand your use of comparative pie charts.

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!

Read more about visualizations in IBM Planning Analytics:

IBM Planning Analytics Tips & Tricks: Scatter Chart vs Bubble Chart

IBM Planning Analytics Tips & Tricks: The Waterfall Chart

IBM Planning Analytics Tips & Tricks: Pie Chart Sizing

Home » Financial Performance Management » Page 3

Filed Under: IBM Planning Analytics Tips & Tricks Tagged With: Financial Performance Management, IBM Cognos TM1, IBM Planning Analytics, TM1

IBM Planning Analytics Tips & Tricks: Excel TEXT Function

January 9, 2024 by Ivan Cepero

Have you ever merged text and a calculated number into a cell and saw that the format of the number was hard to read? The TEXT function in Excel lets you convert the number into a more professional format.

The syntax of the TEXT function is:

=TEXT(value,format_text)

  • Value: the number to format
  • Format_text: the format to apply

The example below shows the basic use of TEXT where the text “Rent amount is” has been appended to the amount in C2. The use of “General” as the second parameter indicates no specific formatting has been applied.

IBM Planning Analytics Tips & Tricks: Excel Text

To apply formatting, you can replace the second parameter with a specific format string.

IBM Planning Analytics Tips & Tricks: Excel Text

The easiest way to find format strings is to get them from the Format Cells dialog box.

  1. In Excel, press CTRL+1
  2. Go to the Number tab
  3. Select Custom in the Category pane
  4. You can then copy the format string from the “Type” textbox
IBM Planning Analytics Tips & Tricks: Excel Text

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!

Read more Excel Tips & Tricks:

IBM Planning Analytics Tips & Tricks: Excel MAXIFS and MINIFS

IBM Planning Analytics Tips & Tricks: Excel OFFSET Function

IBM Planning Analytics Tips & Tricks: Excel’s XMATCH Function

Home » Financial Performance Management » Page 3

Filed Under: IBM Planning Analytics Tips & Tricks Tagged With: excel tips, Financial Performance Management, IBM Planning Analytics, TM1

Top Three IBM Planning Analytics Tips & Tricks Posts – 2023

December 19, 2023 by Revelwood

What were your favorite IBM Planning Analytics Tips and Tricks blog posts this year? We took a look at our website analytics and found the top three posts of 2023 are (drumroll, please!) …

IBM Planning Analytics Tips & Tricks: DefineCalc

IBM Planning Analytics for Excel (PAfE) version 80 introduced a new function called “DefineCalc.” This function allows a user to create a custom calculation using TM1/Planning Analytics data via the use of MDX.

IBM Planning Analytics Tips & Tricks: Expanding Sections of Stacked Dimensions

Have you ever been in a situation where you have stacked dimensions in your view and only want to expand one section of it? In legacy Perspectives, an expansion of one area equates to an expansion of all areas. IBM Planning Analytics Workspace (PAW), version 87, introduced functionality that allows you to expand just one piece at a time.

IBM Planning Analytics Tips & Tricks PAW Users and Groups

Do you know how to manage your users and groups in IBM Planning Analytics Workspace (PAW)? As of version 84, PAW now allows you to edit this information via a single click.

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!

Read more IBM Planning Analytics Tips & Tricks:

IBM Planning Analytics Tips & Tricks: Planning Analytics Workspace (PAW) Region Expansion

IBM Planning Analytics Tips & Tricks: How to Determine when Users Logged in to Planning Analytics Workspace

IBM Planning Analytics Tips & Tricks: Excel Substitute Function

Home » Financial Performance Management » Page 3

Filed Under: IBM Planning Analytics Tips & Tricks Tagged With: Budgeting Planning & Forecasting, Financial Performance Management, IBM Cognos TM1, IBM Planning Analytics, TM1

IBM Planning Analytics Tips & Tricks: Using the Subset Editor in Planning Analytics Workspace

December 12, 2023 by Revelwood

In the past, manipulating subsets in IBM Planning Analytics Workspace (PAW) involved a convoluted process of copying, creating new sets, and pasting elements. The subset editor solves this problem. The subset editor enables you to perform multiple tasks with a single click.

Watch this short IBM Planning Analytics Tips & Tricks video to see Lee Lazarow, Revelwood’s IBM Planning Analytics practice leader, demonstrate how to easily grab an element, its children, siblings, parents and descendants. 

Previously, manipulating subsets focused on the left side of navigation. Inserting elements or expanding to children or descendants was confined to this area, creating limitations in functionality. Planning Analytics, version 88, extended the subset editor’s manipulation functionality. Now users can easily expand or keep elements with a single click!

By right-clicking on an element, users can choose between options like “expand to” or “keep with.” This newfound flexibility allows for expanding to descendants, ancestors, parents, siblings, or any combination, all with a single click.

This new functionality makes the process of manipulating subsets more intuitive and efficient. You can easily work with children, siblings, parents, or any combination of them.

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!

Read more IBM Planning Analytics Tips & Tricks:

IBM Planning Analytics Tips & Tricks: Planning Analytics Workspace (PAW) Region Expansion

IBM Planning Analytics Tips & Tricks: How to Determine when Users Logged in to Planning Analytics Workspace

IBM Planning Analytics Tips & Tricks: Excel Substitute Function

Home » Financial Performance Management » Page 3

Filed Under: IBM Planning Analytics Tips & Tricks Tagged With: Financial Performance Management, IBM Cognos TM1, IBM Planning Analytics, Planning & Forecasting, TM1

Workday Adaptive Planning Tips & Tricks: Using Display Fields in Modeled Sheets

October 26, 2023 by Robert Nordhagen

Modeled sheets in Workday Adaptive Planning often have no monthly data that displays on the sheet. To see the monthly calculations you must go to row details and create a report or create a separate sheet (standard or cube). However, you can see the calculated amounts in the sheet display by using the Display Column feature.

In this demo data, we see a typical Personnel modeled sheet. Notice there are no months. None of the calculated accounts such as Salary, FICA and Bonus are shown in a monthly display.

A screenshot of a computer

Description automatically generated

However, the Salary column is shown and is the Salary that was loaded. Assume this file was loaded in January 2023 and now it is August 2023. We can go to the columns definition of the modeled sheet editor and select Display Columns:

A screenshot of a computer

Description automatically generated

Which displays all the calculated accounts in a selection:

A screenshot of a computer

Description automatically generated

Bring over Personnel Salary and we see the following options:

A screenshot of a computer

Description automatically generated

Leaving the default options, we refresh the modeled sheet display to see a new field, Personnel Salary:

A screenshot of a computer

Description automatically generated

Personnel Salary is showing the monthly salary cost. Notice for those making $120,000, the new field is displaying $10,000 for the monthly salary. We can change the parameter, “Number of time periods in Rollup Range” from 1 to 12 as shown:

A screenshot of a computer

Description automatically generated

And the result is the monthly salary is now displaying the annual salary:

A screenshot of a computer

Description automatically generated

To see how the different parameters affect the display consider the following scenarios.

  1. 1. Display 1 Year before Reference Time Period
  2. 2. Display Year Containing Reference Time Period
  3. 3. Display 1 year after Reference Time Period

To see the current time period, set the parameter and see the result:

A screenshot of a computer

Description automatically generated
A screenshot of a computer

Description automatically generated

To see the 1 year later time period, set the parameter:

A screenshot of a computer screen

Description automatically generated

Note: the Start of plan is Jul 2023. So, Year After Reference Time Period is Jan – Dec of 2024.

A screenshot of a computer

Description automatically generated

Here, we can see that the salaries have increased by 3% which is the annual raise percentage. By switching from 1 month to 12 we get:

A screenshot of a computer

Description automatically generated

These numbers represent the calendar year (Jan – Dec) after the reference period.

Revelwood is an award-winning, Platinum Workday Adaptive Planning partner. We build solutions for the Office of Finance that minimize your risk by seamlessly incorporating business analytics into your everyday thinking. We help businesses achieve their full potential with Workday Adaptive Planning by combining the software with our best practices and expert guidance.

Read more Workday Adaptive Planning Tips & Tricks:

Workday Adaptive Planning Tips & Tricks: Restrictions on Cube Sheets

Workday Adaptive Planning Tips & Tricks: Metadata Loaders

Workday Adaptive Planning Tips & Tricks: Reordering Parent and Children Cube Accounts in Cube Sheets

Home » Financial Performance Management » Page 3

Filed Under: Workday Adaptive Planning Tips & Tricks Tagged With: Financial Performance Management, Planning & Reporting, Workday, Workday Adaptive Planning, Workday Adaptive Planning Tips & Tricks

Limit the Drill Down List on a Workday Adaptive Planning Report

October 25, 2023 by Michelle Song

Our latest Workday Adaptive Planning Tips & Tricks video features Michelle Song, a senior consultant at Revelwood, demonstrating how easy it is to limit the drill down list on a Workday Adaptive Planning report. This new feature will transform how you – and your end users – interact with your Adaptive Planning reports. 

Watch this video to learn how to:

  • Access the report
  • Edit the report properties
  • Select the relevant dimensions
  • Apply your changes
  • Save and Run

Now, when you click on an account name, you’ll be greeted with only the dimensions you’ve deemed pertinent. No more hunting for the right information or risking confusion for end-users!

By fine-tuning your reports, you’re not just saving time but also enhancing the overall user experience. No more distractions, no more unnecessary options—just precise, actionable insights.

Revelwood is an award-winning, Platinum Workday Adaptive Planning partner. We build solutions for the Office of Finance that minimize your risk by seamlessly incorporating business analytics into your everyday thinking. Combining the software with our best practices and out-of-the-box applications, we help businesses achieve their full potential with Workday Adaptive Planning.

Read more Workday Adaptive Planning Tips & Tricks:

Workday Adaptive Planning Tips & Tricks: Metadata Loaders

Workday Adaptive Planning Tips & Tricks: Reordering Parent and Children Cube Accounts in Cube Sheets

Workday Adaptive Planning Framework: Purchase Order Management for Organization-Wide Planning

Home » Financial Performance Management » Page 3

Filed Under: Workday Adaptive Planning Tips & Tricks Tagged With: Financial Performance Management, Planning & Reporting, Workday Adaptive Planning, Workday Adaptive Planning demo, Workday Adaptive Planning how to

IBM Planning Analytics Tips & Tricks: Cell Security in Planning Analytics Workspace

October 17, 2023 by Revelwood

In our latest IBM Planning Analytics tips & tricks video, Lee Lazarow, Revelwood’s IBM Planning Analytics practice lead, explains and demonstrates cell security in IBM Planning Analytics (PAW). Cell security is a critical aspect of data management, providing control access to specific data points within PAW cubes. 

Watch this video and learn how to:

  • Determine the cube you want to add security to
  • Choose the dimensions
  • Create the cell security
  • Define security manually
  • Automate security with rules
  • Save and apply rules
  • Make modifications

In conclusion, cell security in IBM Planning Analytics is a powerful tool for managing data access. By following these steps, you can efficiently define and implement security measures that align with your specific needs. PAW offers a versatile platform for ensuring data integrity, whether through manual adjustments or automated rules.

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!

Read more IBM Planning Analytics Tips & Tricks:

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

IBM Planning Analytics Tips & Tricks: Adding Images to Charts

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

Home » Financial Performance Management » Page 3

Filed Under: IBM Planning Analytics Tips & Tricks Tagged With: Financial Performance Management, IBM Cognos TM1, IBM Planning Analytics, IBM Planning Analytics Tips & Tricks, TM1

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!

Read more IBM Planning Analytics Tips & Tricks:

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

IBM Planning Analytics Tips & Tricks: Adding Images to Charts

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

Home » Financial Performance Management » Page 3

Filed Under: IBM Planning Analytics Tips & Tricks Tagged With: Financial Performance Management, IBM Planning Analytics, IBM Planning Analytics for Excel, IBM Planning Analytics Tips & Tricks, TM1

Unlocking Success: Harnessing Customer Satisfaction Metrics with Workday Adaptive Planning

September 20, 2023 by Revelwood

In today’s competitive business landscape, customer satisfaction is more critical than ever. Happy customers are not only likely to stay loyal but also become advocates for your brand, driving growth through referrals and repeat business. Workday Adaptive Planning can help monitor customer satisfaction metrics and leverage the data for strategic decision-making, with a particular focus on the professional services industry.

The Importance of Customer Satisfaction

Customer satisfaction is the backbone of any successful business, but it holds even more significance in the professional services sector. Here’s why:

1. Client Retention:

High customer satisfaction translates into strong client retention rates. Satisfied clients are more likely to continue using your services, providing a stable revenue stream.

2. Reliable Referrals:

Happy customers become your brand advocates. They are more inclined to recommend your services to others, leading to a steady influx of new clients through referrals.

3. Competitive Advantage:

Exceptional customer satisfaction sets you apart from your competitors. It’s a key differentiator that can make potential clients choose your services over others.

Leveraging Workday Adaptive Planning

Workday Adaptive Planning offers a powerful solution for tracking and utilizing customer satisfaction metrics. Here’s how it can help:

1. Integration with Customer Feedback Software:

Workday Adaptive Planning seamlessly integrates with customer feedback software like Zendesk or Monday. You can easily import customer satisfaction data into the platform, ensuring that teams across your organization have access to valuable insights.

2. Comprehensive Dashboard:

The platform provides an active dashboard displaying essential metrics such as average SLA, Net Promoter Scores (NPS), and customer satisfaction. It also breaks down renewal rates by team leads. Conditional formatting helps identify areas where improvements can be made.

3. Drill-Down Capabilities:

With Workday Adaptive Planning, you can drill down into the data further. For example, you can explore specific Key Performance Indicators (KPIs), such as new references. This feature allows for in-depth analysis and customized reporting.

4. Informed Decision-Making:

By leveraging the data from customer satisfaction metrics, businesses can make informed decisions. Whether it’s retaining clients, generating references, or delivering projects on time, the platform offers insights to enhance efficiency and effectiveness.

5. Industry-Specific Metrics:

Workday Adaptive Planning doesn’t just stop at basic metrics. It can provide additional details on industry-specific metrics, giving you a more comprehensive view of your performance within your sector.

In a world where customer satisfaction reigns supreme, Workday Adaptive Planning empowers businesses, especially those in the professional services industry, to turn data into actionable insights. By monitoring and analyzing customer satisfaction metrics, you can maintain your current customer base and drive business growth.

If you’re interested in diving deeper into other Adaptive use cases for professional services or want to explore how Workday Adaptive Planning can transform your organization, take a look at our Workday-approved framework for using Adaptive Planning to track customer satisfaction.

Read more from this series:

Aged to Perfection: The Whiskey Model for Workday Adaptive Planning

Reusable Cash Flow Forecasting in the Solar Installation Industry

What-if Analysis in Workday Adaptive Planning

Home » Financial Performance Management » Page 3

Filed Under: Workday Adaptive Planning Insights Tagged With: Customer Satisfaction, Financial Performance Management, Planning & Forecasting, Workday, Workday Adaptive Planning

  • « Go to Previous Page
  • Page 1
  • Page 2
  • Page 3
  • Page 4
  • Page 5
  • Interim pages omitted …
  • Page 47
  • Go to Next Page »

Footer

Revelwood Overview

Revelwood helps finance organizations close, consolidate, plan, monitor and analyze business performance. As experts in solutions for the Office of Finance, we partner with best-in-breed software companies by applying best practices guidance and our pre-configured applications to help businesses achieve their full potential.

EXPERTISE

  • Workday Adaptive Planning
  • IBM Planning Analytics
  • BlackLine

ABOUT

  • Who We Are
  • What We Do
  • How We Help
  • How We Think
  • Privacy

CONNECT

World Headquarters

Florham Park, NJ | 201 984 3030

European Headquarters

London & Edinburgh | +44 (0)131 240 3866

Latin America Office

Miami, FL | 201 987 4198

Email
info@revelwood.com

Copyright © 2025 · Revelwood Inc. All rights reserved. Revelwood® and the Revelwood logo are registered marks of Revelwood Inc.