• 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

FP&A Done Right: How to Improve Cross-team Collaboration

May 3, 2019 by Revelwood Leave a Comment

FP&A Done Right

This is a guest blog post from our partner Adaptive Insights.

When it comes to business, collaboration is vital. After all, no single department can do its job for long without the other departments pulling their own weight. Sales is no good if shipping can’t deliver; marketing falls flat if customer service keeps alienating users; everything grinds to a halt if human resources doesn’t provide the appropriate staffing.

But for some reason, when it comes to the numbers, it can feel like every department is on its own. Data is often stuck in silos, making it difficult or even impossible for other departments to get the information they need to do their jobs well.

Nowhere is this more evident than in the department that makes numbers its business: finance.

Collaboration can be a struggle

According to an Adaptive Insights CFO survey, nearly 50% of CFOs cited the inability to align with other departments on key metrics as a top issue, while 70% said improving collaboration with other parts of the business was a top priority for the upcoming year.

What makes collaboration with others such a struggle for the finance team? According to the report, 79% said lack of time was one of their most challenging collaboration issues, while 55% cited lack of clarity about who has decision-making authority when collaborators disagree.

It’s no wonder teams struggle to achieve collaborative finance; they don’t have the necessary time, direction, or clarity around KPIs to build the cross-functional relationships required to improve forecasting and reporting. So what should be a team effort becomes a finance exercise, and when numbers change, it becomes finance’s fault. In the end, we lose credibility as a business partner.

Make your data everyone’s data

So how do you get other departments to collaborate with finance? Start by empowering your business partners with more ownership and accountability in the data and your process. For example, many businesses still do most of their forecasting and planning with spreadsheets. Not only is this wildly inefficient (not to mention more likely to include errors), but it keeps all the information bottled up on one person’s screen until they’re ready to share. We all have seen an Excel spreadsheet named finalV2 or Final V3, only to find out our business partners are using FinalV6. This is a leading cause of number mismatch. Using modern finance tools, a finance team can collect and report on the numbers without needing to send and receive Excel spreadsheets. Everyone is on the same version and making the changes together. This just makes the business partners a part of the overall process, not part of the problem.

The more you can modernize your process and increase visibility into KPIs across the company, the more others will think of “our numbers” instead of “finance’s numbers.” When you create a single source of truth and share it, collaborators will be able to move past arguing about the numbers and start working together to decide on next steps.

A strategic bonus to collaborative finance

As a bonus, automation and dashboards for self-service collaborative reporting can vastly reduce the amount of transactional work the finance team has to accomplish each day. This frees up our time for both increased collaboration and providing the strategic, high-level analysis that helps move the company forward.

This blog was originally published by Adaptive Insights.

Home » Financial Performance Management » Page 32

Filed Under: FP&A Done Right Tagged With: Adaptive Insights, Financial Performance Management

IBM Planning Analytics Tips & Tricks: PAW Calculations

April 30, 2019 by Lee Lazarow Leave a Comment

Tips & Tricks

Did you know IBM Planning Analytics offers more than one way to add calculations to your data?

The great thing about using Planning Analytics within Excel is that you can add additional calculations to your data set to help you further analyze your data. Did you know that you can also do this within PAW explorations?

Use the following steps to create a new calculation:

  1. Select one or more elements within your exploration. The elements can be from either the row or column axis.
  2. Right click on a selected element
  3. Choose the option to “create calculation”.

Planning analytics will then provide you with a set of pre-built calculations to choose from. The calculations available vary according to the number of members selected.

If you select one element, you will have options such as absolute value and percentage of total:

IBM Planning Analytics Tips & Tricks: PAW Calculations

If you select two elements, you will have options such as variance amount and percentage change:

IBM Planning Analytics Tips & Tricks: Using PAW Calculations

If you select three or more elements, you will have options such as average amount and maximum value:

IBM Planning Analytics Tips & Tricks: Working with PAW Calculations

Once created, you have the option to rename or remove any calculations within your exploration.

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!

Learn more IBM Planning Analytics Tips & Tricks:

IBM Planning Analytics Tips & Tricks: Creating Selectors in Planning Analytics Workspace

IBM Planning Analytics Tips & Tricks: Creating Buttons in Planning Analytics Workspace

IBM Planning Analytics Tips & Tricks: Synchronizing Selectors in Planning Analytics Workspace

Need more guidance? Take a look at our IBM Planning Analytics Training services and our Customer Care Program.

Home » Financial Performance Management » Page 32

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

Your Favorite TM1 Features Did Not Go Away

April 29, 2019 by Revelwood Leave a Comment

Tips & Tricks

This is a guest blog post from Revelwood’s Shane Bethea.

TM1 customers worldwide are upgrading and migrating to IBM Planning Analytics. Regardless of where you are in your upgrade or migration process, there’s a very important point you should know: you will not lose Perspectives or TM1Web when you upgrade or migrate.

IBM Planning Analytics comes with new interfaces, features and functionality that can eventually replace Perspectives and TM1Web. These are Planning Analytics for Excel (PAx) and Planning Analytics Workspace (PAW). While these are new and deliver many benefits, understand that you do not need to leave behind your beloved Perspectives or TM1Web.

You should look at your upgrade or migration path as you would any other software enhancement process. Evaluate what is currently working for your organization and what is not. Develop a plan for what needs to be improved upon and when those improvements are best implemented. That roadmap should give you guidelines on what is best for your organization: staying with Perspectives and/or TM1Web, upgrading/migrating in the long term, or starting an upgrade/migration process in the short term. What is most vital is understanding what will work best for your organization and why.

All IBM Planning Analytics users are licensed to use PAW in Development to use, learn and understand the new features and capabilities. Customers usually install the PAW server in the Development environment and begin experimenting with PAx and PAW to decide if, how and when they want to move forward with the new interfaces and features.

Love Perspectives and TM1Web? Don’t worry – they are still there!

Need more guidance? Take a look at our IBM Planning Analytics Training services and our Customer Care Program.

Home » Financial Performance Management » Page 32

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

IBM Planning Analytics Tips & Tricks: PAW Cell Comments

April 23, 2019 by Lee Lazarow Leave a Comment

Tips & Tricks

Did you know IBM Planning Analytics Workspace allows you to add comments to your data set?

During both planning and reporting cycles, many clients often ask how they can add comments into their data set. After all, the goal of a Planning Analytics database is to have a single source of data … both numeric and text.

Planning Analytics Workspace allows you to insert comments into your explorations quickly and easily.

Step 1:

Right click on the cell where you want to insert the comment and select the option for “Comments”. As with all string values in Planning Analytics, comments can be added at either a base level or a consolidated level.

Step 2:

Click on “Add Comment”, enter your comment, and select the option to “Post”. You can enter multiple comments into a single data cell.

IBM Planning Analytics Tips & Tricks: Using cell comments in PAW

Step 3:

A blue triangle will now appear in the top, right corner. You can follow the tasks in step 1 to review the existing comments.

IBM Planning Analytics Tips & Tricks: How to add cell comments

In addition to viewing the comments in PAW, the information is stored in a control cube called }CellAnnotations_CUBENAME. The data point contains a lot of metadata information to define the caption, the creator, the intersection, and other reference points. However, this data could easily be cleaned up and be included in reports.

IBM Planning Analytics 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 blog posts in the IBM Planning Analytics Tips & Tricks Series:

IBM Planning Analytics Tips & Tricks: Creating Buttons in Planning Analytics Workspace (PAW)

IBM Planning Analytics Tips & Tricks: Customizing Planning Analytics Workspace (PAW) Directory Installation on Windows Server 2016

IBM Planning Analytics Tips & Tricks: Hiding Dimensions in Planning Analytics Workspace

Need more help? Learn about our Customer Care options for IBM Planning Analytics & TM1 users. 

Home » Financial Performance Management » Page 32

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

FP&A Done Right: It’s Time for a Change

April 19, 2019 by Brian Combs Leave a Comment

FP&A Done Right

Change. /CHānj/

verb

  1. to make the form, nature, content, future course, etc., of (something) different from what it is or from what it would be if left alone
  2. to transform or convert

noun

  1. the act, process, or result of changing
  2. a transformation or modification; alteration

Seems simple enough, right? Not by a long shot. One of the two big C’s you must be prepared to facilitate is Change (Communication is the second one). I love change. I’m not talking about change simply for the sake of change. We all know there is enough of that. I’m referring to the change that comes about once you recognize that something is missing from your processes. When you realize there is a better, more efficient way to achieve your goals, step up and make the change happen. Be a Change Agent.

Many people don’t like change and you will find individuals who resist at every step. Communicating the changes and the need for them must begin long before the new processes, roles, or systems take place. Crafting a clear message, directed at each level of your organization is key and must be consistently reinforced. When you are in the midst of a transformation, you will become focused on timelines, budgets, and deliverables. It’s easy to overlook something such as change. After all, “that ship has already sailed.  There’s no way we are turning back now. They will just have to fall in line.”

This is another lesson I learned the hard way. Early in my career, I didn’t understand resistance to change. We were changing portions of our revenue planning process to be driver based and I assumed the group would accept the changes because they were told to. At the end of day, what choice did we have? Well, we had several meetings, created a new process, made the system updates to incorporate these changes, and then sent the announcement describing the new process and letting them know that it would be live with the next forecast. Oops. Let’s just say that we didn’t go live with the next forecast. 

The next time around, I learned from those mistakes and found a more successful route for navigating change. I elicited the support of select individuals in different geographies (particularly important for global organizations) and departments. Not only did I choose people who were respected and well liked, but I also chose a couple of the naysayers.  Oftentimes, we know one or more individuals who are going to be upset with our changes. Make them part of the solution and add them to your team. That move allowed me to get a preview of the pushback that I could expect once we announced the changes. We were able to chart a path around the upcoming roadblocks and I included those objections in my communications. I then had those team members deliver the communication, so it didn’t appear as if it was coming from the top down.  This was a successful strategy.

Read more blog posts in our FP&A Done Right series:

FP&A Done Right: “That’s the Way We’ve Always Done It!” — Challenge the Status Quo

FP&A Done Right: Even Google Maps Requires a Starting Point

FP&A Done Right: The Importance of Naming Conventions – Names Really Can Hurt

FP&A Done Right: The Flexibility of Today’s FP&A Systems is Both a Blessing and a Curse

Home » Financial Performance Management » Page 32

Filed Under: FP&A Done Right Tagged With: Financial Performance Management, FP&A

IBM Planning Analytics Tips & Tricks: PA Modeling – The Settings Editor

April 16, 2019 by Revelwood Leave a Comment

Tips & Tricks

This is a guest post from Revelwood’s Shane Bethea.

Did you know that there is a new way to edit object settings in IBM Planning Analytics Workspace (PAW)? The Settings editor is new for PAW and gives the system administrator a clear, easy to use interface to modify attributes, security, and properties for objects such as cubes, dimensions, processes, and chores (where applicable). In the background, the Settings editor is still modifying entries in control cubes such as the }CubeAttributes, }CubeSecurity, and }CubeProperties cubes, but the new interface is much easier to use and a more centralized interface.

To use the Settings editor, right click on Cubes (or Dimensions, Processes, or Chores) within the navigation tree and select Edit settings.

IBM Planning Analytics Tips & Tricks: The Settings Editor

Selections to edit Attributes, Security, or Properties are in the top, right hand corner of the Settings editor that appears. Each interface is displayed below.

IBM Planning Analytics Tips & Tricks: Understanding the Settings Editor
IBM Planning Analytics Tips & Tricks: How to use the Settings Editor
IBM Planning Analytics Tips & Tricks: Learn how to use the Settings Editor

You can easily switch between Cube, Dimension, Process, and Chore settings by changing the value in the drop down list at the top left corner of the Settings editor.

IBM Planning Analytics Tips & Tricks: The Settings Editor in Planning Analytics Workspace

The grid below outlines the different cubes that are modified by the Settings editor.

Understanding the Settings Editor in Planning Analytics Workspace

The new Settings editor widget simplifies your administrative tasks by giving you a single approach to modify many different components within your Planning Analytics environment. Stay tuned for more entries covering the other modeling widgets.

IBM Planning Analytics 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!

Learn more IBM Planning Analytics Tips & Tricks:

IBM Planning Analytics Tips & Tricks: Creating Selectors in Planning Analytics Workspace

IBM Planning Analytics Tips & Tricks: Creating Buttons in Planning Analytics Workspace

IBM Planning Analytics Tips & Tricks: Synchronizing Selectors in Planning Analytics Workspace

Need more guidance? Take a look at our IBM Planning Analytics Training services and our Customer Care Program.

Home » Financial Performance Management » Page 32

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

IBM Planning Analytics Tips & Tricks: PA Modeling – The Dimension Editor

April 9, 2019 by Revelwood Leave a Comment

Tips & Tricks

This is a guest post from Revelwood’s Shane Bethea.

Did you know that you can quickly and easily create a new time dimension in the Planning Analytics Workspace (PAW) Dimension editor? The following steps will automatically create a time dimension with a standard hierarchy and pre-populated set of attributes in a matter of seconds.

To create your time dimension using the PAW Dimension editor, simply right click Dimensions in the left hand navigation tree and select Create dimension.

IBM Planning Analytics Tips & Tricks: The Dimension Editor

Enter a name for your new time dimension and then click Create.

IBM Planning Analytics Tips & Tricks: Understanding the Dimension Editor

Select the ‘Customize as Time’ button to open the time interface.

IBM Planning Analytics Tips & Tricks: How to use the Dimension Editor

Select the start year, end year, and element granularity (Year, Quarter, or Month) and then click Create.

Understanding the dimension editor in IBM Planning Analytics Workspace

This will create a new time dimension, complete with a calendar year’s Year/Quarter/Month hierarchy and a standard set of attributes.

Working with the Dimension Editor in IBM Planning Analytics Workspace

Once created, you can add or modify these attributes based on your reporting and analytics needs. Stay tuned for more entries covering more features and the other modeling widgets.

IBM Planning Analytics 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!

Learn more IBM Planning Analytics Tips & Tricks:

IBM Planning Analytics Tips & Tricks: Creating Selectors in Planning Analytics Workspace

IBM Planning Analytics Tips & Tricks: Creating Buttons in Planning Analytics Workspace

IBM Planning Analytics Tips & Tricks: Synchronizing Selectors in Planning Analytics Workspace

Need more guidance? Take a look at our IBM Planning Analytics Training services and our Customer Care Program.

Home » Financial Performance Management » Page 32

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

FP&A Done Right: “That’s the Way We’ve Always Done It!” – Challenge the Status Quo

April 5, 2019 by Brian Combs Leave a Comment

FP&A Done Right

“That’s the way we’ve always done it.” “I don’t know, we just send it to them every month.” AHHHHHH! Stop it! When I get that response; it is like fingernails on a chalk board to me. It sends shivers up and down my spine. FP&A needs to add value at every step of the process. Focus on the up- and down-stream impacts of everything you do and make sure you understand the intent behind what you are doing. Without that knowledge, you blindly repeat tasks month to month. Don’t simply be a “doer.” Doers are easily replaced. Make your voice known and focus on those tasks which connect data to strategy and action.

Challenge the status quo. At a minimum, question it. Take the initiative to speak with your CFO or manager about something that doesn’t make sense to you. Ask them how they use the data you provide to drive the company. Worst case? They blow you off, but now they know you are interested in learning more to try and help them. Best case? You get an advocate who can help you drive change. Give it shot. Don’t just do. Think and understand.

FP&A Done Right: Challenge the Status Quo

One day, I was at my wits’ end. It was going to be yet another long night pulling data together and validating/manipulating numbers to create reports. Out of desperation, I went up to the C suite and asked if the CFO was available. I told her that the team worked late (again) and we had not yet created this one particular report that we provided her monthly. “Would it be ok if we didn’t send this until tomorrow?” I asked. This was one of those reports that was a bear. It took a couple of us many hours to pull together data from several other reports (some of which had not yet been created), massage and tweak it, add commentary and validate. Her matter of fact response, “I don’t even open that report any more.” Then she walked in to the conference room and left me there standing in the hallway wondering what to do with all these newfound hours in my week! I actually started to laugh right there in the hallway.

I learned a valuable lesson that day. Ask questions. Challenge the status quo.

Read more blog posts in our FP&A Done Right series:

FP&A Done Right: Even Google Maps Requires a Starting Point

FP&A Done Right: The Importance of Naming Conventions – Names Really Can Hurt

FP&A Done Right: The Flexibility of Today’s FP&A Systems is Both a Blessing and a Curse

Home » Financial Performance Management » Page 32

Filed Under: FP&A Done Right Tagged With: Financial Performance Management, FP&A

IBM Planning Analytics Tips & Tricks: The Benefits of Using Hierarchies

April 2, 2019 by Nina Inverso Leave a Comment

Tips & Tricks

Did you know there are several benefits to using hierarchies in IBM Planning Analytics?

Hierarchies are one of the additional features available in Planning Analytics. The main benefit of hierarchies is that they enable users to see alternative data rollups in the same view. There are several reasons to take advantage of this new approach to interacting with your data.

Hierarchies can improve query performance. Modeling attributes as hierarchies instead of dimensions can save memory space. This allows for cubes with fewer dimensions, while using hierarchies as virtual dimensions.

 Attributes can be turned into hierarchies. Hierarchies provide greater flexibility. Updating a hierarchy is as easy as updating an attribute. A single dimension can contain multiple hierarchies, and multiple hierarchies can be displayed in the same view.

 Hierarchies can be created and maintained manually or via TurboIntegrator process. This gives users flexibility to choose the method by which their hierarchies are maintained. Planning Analytics provides a user-friendly interface for manual maintenance, while TI processes can make automated maintenance fast and simple.

Planning Analytics hierarchies enable you to gain informative and flexible insight into your data, while utilizing fewer resources.

IBM Planning Analytics 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: GMT vs Local Time

IBM Planning Analytics Tips & Tricks: Captions

IBM Planning Analytics Tips & Tricks: Regions with Planning Analytics Rules

Need more guidance? Take a look at our IBM Planning Analytics Training services and our Customer Care Program.

Home » Financial Performance Management » Page 32

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

  • « Go to Previous Page
  • Page 1
  • Interim pages omitted …
  • Page 30
  • Page 31
  • Page 32
  • Page 33
  • Page 34
  • 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.