• 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

Budgeting

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 » Budgeting » Page 9

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 » Budgeting » Page 9

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

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 » Budgeting » Page 9

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

IBM Planning Analytics Tips & Tricks: Tracing Calculations in Planning Analytics Workspace

March 26, 2019 by Lee Lazarow Leave a Comment

Tips & Tricks

Did you know that you can trace the details of a calculation in an IBM Planning Analytics Workspace exploration? The following screen shot shows a simple revenue calculation that uses input values for Units and Unit Price.

IBM Planning Analytics Tips & Tricks: PAW Tracing

You can right click on the revenue value and select the option of “trace cell” to see the details of the calculation. The trace will show me the calculated result, the formula, and the values for each component of the formula.

IBM Planning Analytics Tips & Tricks: Understanding PAW Tracing

And as of version 2.0.39, you can also trace feeders. Right click on a leaf cell and select the option to “Trace Feeders”. The trace will show me the feeder line from the rule and will also give me the status of each feeder.

IBM Planning Analytics Tips & Tricks: Planning Analytics Workspace Tracers

Tracing values and feeders will allow both end users and developers to better analyze and optimize your Planning Analytics environment.

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

Home » Budgeting » Page 9

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

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

March 22, 2019 by Brian Combs Leave a Comment

FP&A Done Right

Current Location. Destination. That’s it. That is all you need to provide your favorite mapping app for it to create a route. No current location? You will not know where to begin or how long it will take to get there. No destination? You will drive aimlessly with no end in sight. Your finance transformation or business process improvement is no different. We all recognize the need to determine our future state. But you also need to spend time understanding your current state so you can create a road map detailing how you will achieve that future state. How will you attain your long-term vision if you don’t know where you are starting from?

FP&A Done Right

Oftentimes, we simply jump directly to our desired or future state process discussions and then believe we can move straight into implementing those changes. Who cares about the current state, right? I often hear, “Brian, we don’t need to spend time on our current state process. We already know what it is.” Really? Are you sure? I had myself convinced of that same thing…right until I hit my first roadblock.

I was sure that I knew what each group did during the forecast process. After all, I created many of the schedules and reports that we used and personally trained the teams on every step. While discussing why it took so long to create one of those data input schedules, I uncovered that the functional group took the source data and “massaged” it a bit (deleted rows and columns, inserted and renamed items, etc) to put it in the format they were used to seeing. Then, they sent the file to someone on my team who simply undid much of the previous work and changed it back so it fit our process! We had no idea that the format we preferred was actually the initial extract of the source data. I happened to walk by someone’s desk at just the right time and saw something on their computer screen. After a few questions, we significantly reduced the time required to generate the same sheet.

Don’t underestimate the importance of spending adequate time mapping out and truly understanding your current state process. Don’t fool yourself into thinking that “the process” is being followed 100% of the time. Make sure to uncover those pesky little shortcuts that people take to circumvent the process. Uncover the waste in your current process and then create a future state that eliminates it. I can ensure you that time spent upfront can payback multi-fold during your transformation.

Of course, you could attempt to implement your desired future state without first understanding your starting point. If you do, call me after you are over budget and too dizzy to continue. I’ll be happy to help and I promise to do my best not to say, “I told you so.”

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

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

FP&A Done Right: Finance as the Conductor

FP&A Done Right: You Can’t “System” Your Way out of This

FP&A Done Right: Introduction

Home » Budgeting » Page 9

Filed Under: FP&A Done Right Tagged With: Analytics, Budgeting, Budgeting Planning & Forecasting, Financial Performance Management, FP&A, Planning & Forecasting, Planning & Reporting

Can You Recover From Static Planning by 2020?

March 19, 2019 by Revelwood Leave a Comment

FP&A Done Right

This is a guest blog post from Rob Hull, founder, Adaptive Insights.

Scramble like hell to pull together a budget. Execute against that budget regardless of changes in the business. Repeat the budget scramble in 12 months.

If your corporate planning process still looks like this, then you’re likely stuck in static planning. By that I mean a planning, reporting, and analytics process that’s siloed, largely manual, almost always built around spreadsheets, and constrained by limited insights into the operations of the business.

Static planning may appear to have served you well for years; in fact, for decades it was the standard way for all businesses to plan. It worked, until it didn’t.

In the past few years, the world has gotten smaller, faster, and more data driven. And whether they know it or not, organizations that plan poorly are operating on borrowed time. That’s because the requirements for effective financial and operational planning, reporting, and analytics have risen sharply and suddenly, spurred by compounding changes that threaten to overwhelm businesses that can’t operationalize new strategies to navigate them. These changes include spiraling operational complexity, growing amounts of inscrutable data, disruptive new digital-native competitors, and ever-growing customer expectations.

Navigating constant change

Any one of these changes would prove challenging. All of them together require a significant leap for any business.

Take data growth. As my colleague Tom Bogan noted recently, 90% of all the world’s data didn’t even exist two years ago. So within two years—close to the end of 2020—your business will likely be trying to manage and make sense of twice the volume of data you’re working with today.

Static planning is a poor fit for this new age of data proliferation. Businesses that base their decisions on instinct, rather than data-driven insights, tend to be less agile. They respond sluggishly to changes in the business or market—if they respond at all. Compare that to data-driven businesses, which on average grow a healthy 30% annually. Very few businesses that rely on static planning will successfully navigate our rapidly changing business world. You can’t chart your way forward through constant, rapid change by being slow, rigid, and myopic in your decision-making process.

The good news is you can recover from your static planning environment before it’s too late—before your competitors outpace you or before events overtake you. You can be one of the nimble, data-driven businesses that are the leaders of tomorrow.

The answer is active planning

Active planning is different from static planning in three key ways.

  1. It’s collaborative. It allows everybody in the business to plan and escalates critical decisions to the right people while giving them the information and insight they need to make the right choice.
  2. It’s continuous. Instead of a painful annual planning process that quickly grows stale, active planning is ongoing and infused by a constant stream of trusted, always-current data.
  3. It’s comprehensive. Active planning enables a holistic view of the business, connecting together finance, sales, workforce, and other operational planning, reporting, and analytics and integrating them with ERP, HCM, CRM, and other operational data stores.

Organizations that implement active planning processes are four times more likely to be able to respond to a market change than those still stuck with static planning. That’s a decent definition of agility if ever I’ve heard one.

Active planning by 2020? Start now

If this sounds too good to be true, be assured there are thousands of companies that have abandoned static planning and embarked on their own journey to active planning. They’ve done it by replacing spreadsheets and rigid legacy planning platforms with cloud-based planning solutions built to handle large and varied volumes of frequently changing data, yet are accessible and easy to use by a wide range of business users. And, since they know that their organization and the demands on it will only grow in the future, they’ve chosen technology that scales quickly and painlessly across different systems, locations, and environments. Operating a business is growing more complex, so planning should accommodate that complexity while still being simple enough for virtually anyone to do.

With an active planning environment, you’ll find it far easier to model what-if scenarios so you’ll be ready to course-correct when change happens. You’ll be able to determine your optimal workforce mix while setting sales quotas and drawing territories that keep account reps motivated and productive. And you’ll be able to lower the risks associated with your business decisions because forecasts are based not just on historical trends, but also on real-world, even real-time data and the input of managers closest to each part of your business.

Modern business planning is now a strategic advantage, and in today’s business environment, you need all the advantages you can find. So it follows that outdated modes of planning amount to a competitive disadvantage. Every day you spend mired in static planning is another day you’re allowing your competitors to move ahead, extending the gap between where you are and where the future demands you must go.

2020 will be here before you know it. The 4,000-plus organizations we’ve worked with to adopt active planning will be far more prepared to succeed in a world of constant change. Will you?

 

Home » Budgeting » Page 9

Filed Under: News & Events Tagged With: Adaptive Insights, Analytics, Budgeting, Budgeting Planning & Forecasting, Financial Performance Management, FP&A, Plan to Win, Planning & Forecasting, Planning & Reporting

IBM Planning Analytics Tips & Tricks: Buttons to run TI Processes

March 19, 2019 by Lee Lazarow Leave a Comment

Tips & Tricks

Did you know IBM Planning Analytics Workspace (PAW) has new features? Version 2.0.39 of PAW introduced the ability for buttons to run Turbo Integrator processes. When creating a button, you now have the option to set the target to “Run Process”. Once selected, you will have drop down selectors to define the server where the process is located and the name of the process.

IBM Planning Analytics Tips & Tricks: PAW Button Refresh

You can also control the parameters. They can be hard coded values or you can prompt the user to input value. The user prompts allow for general text input, a predefined hard coded list, or an element list which either uses an existing hierarchy or an existing subset.

IBM Planning Analytics Tips & Tricks: Understanding the PAW button process

You can still control the appearance of the button using the other button properties. This allows you to control aspects such as colors, fonts, and wording. When used properly, buttons will help simplify the Planning Analytics experience and make your planning and reporting approach easier for your end users.

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

Home » Budgeting » Page 9

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

IBM Planning Analytics Tips & Tricks: New Features in PAW – Data Refresh

March 12, 2019 by Lee Lazarow Leave a Comment

Tips & Tricks

Did you know that there are new features in IBM Planning Analytics Workspace (PAW)? We’ll cover these new features in the next few blog posts. Today, we’ll discuss how you can set your data refresh definitions directly from the short cut bar. The “Grid Refresh” option allows you to determine when your data refreshes.

IBM Planning Analytics Tips & Tricks: PAW Data Refresh

This parameter gives you two options:

IBM Planning Analytics Tips & Tricks: Understanding the PAW Data Refresh

After each context change: when selected, data will be refreshed anytime the structure of the view is modified. This includes the swapping of rows and columns, the expansion or collapsing of members in the rows or columns, changing values in the context areas, and using snap commands.

Defer on leaf data change: when selected, data will only be refreshed when an action is taken to refresh the data. These actions include manually clicking a refresh button, entering data in consolidated cells, using data spreading, and updating cells from a date picker.

Just like Excel’s workbook calculation settings, PAW explorations allow you to define your refresh settings.

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: Swap Rows & Selectors in Planning Analytics Workspace

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

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

Home » Budgeting » Page 9

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

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

March 8, 2019 by Brian Combs Leave a Comment

FP&A Done Right

Fly…Fly;

Ring…Ring;

Wave…Wave;

Bat…Bat

In the above examples:

Am I talking about a fly that’s buzzing around my head or are we getting on a plane to fly somewhere? Is that the ring from a telephone or a fancy diamond ring? Did someone just wave at you from across the room or are we going surfing on a big wave? Did we just see a bat fly out of a cave or did I pick up my bat and step to the plate?

Metadata management is extremely important because names matter. Context matters. Metadata management covers a whole host of data governance issues, but I want to simply focus on the naming conventions you choose for your accounts, departments, locations and other elements in your dimensions. You must enforce standard nomenclature throughout your systems. This is not an easy exercise, but it is absolutely necessary.

We often play games with nomenclature so we can circumvent our system’s rules or logic. Perhaps you “need” to tweak a formula or consolidated roll-up to meet one internal customer’s exact specifications so you alter the name slightly.

  • “U.S. Operations” vs “U.S. Ops” where you include Canada and Mexico in one since the manager is responsible for North America as a whole
  • “Total International” vs “Total Intl” where you exclude EMEA from one because that tells a better story
  • “Total Salary” vs “Total_Salary” where certain bonuses are included in one of them due to different comp plans

Who’s that going to hurt? Right? It will come back to haunt you and it makes it difficult for your typical end user to understand what they are looking at.

My general rule of thumb is to print a copy of any analysis or report and then look at it to see if everything is clear. A hard copy takes it out of its context and it needs to stand alone. At some point, a print out of your report will end up on someone’s desk and you will be called out for a number that is “wrong” simply because similar names have different meanings. I have received more than one panicked phone call from the C suite telling me that my numbers were wrong. They had the proof! A hard copy report that someone gave them was in their hands and it contradicted the numbers I just gave them. I hope my point is clear – there will always be a hard copy. Make sure that copy is crystal clear.

There are any number of software solutions you can purchase to help you manage this, but you can create a homegrown process easily as well. This doesn’t have to be anything fancy, just bring everyone to the table. While at Hertz, I created a Data Governance team and process that included a member from our Domestic and International FP&A teams, Accounting, Operations and Corporate. Before I agreed to add anything to our planning and reporting system, this team needed to meet to discuss and agree on a naming convention. It may sound silly, but I can ensure you that these meetings saved countless hours of reconciling differences between reports.

We have all heard the adage about “sticks and stones.” Perhaps I just shed a different light on that old tale. At least in this context, names really can hurt.

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

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

FP&A Done Right: Finance as the Conductor

FP&A Done Right: You Can’t “System” Your Way out of This

FP&A Done Right: Introduction

Home » Budgeting » Page 9

Filed Under: FP&A Done Right Tagged With: Analytics, Budgeting, Budgeting Planning & Forecasting, Financial Performance Management

  • « Go to Previous Page
  • Page 1
  • Interim pages omitted …
  • Page 7
  • Page 8
  • Page 9
  • Page 10
  • Page 11
  • Interim pages omitted …
  • Page 19
  • 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.