• 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: The Victors of the Decade Combine Agility and Resilience

December 20, 2019 by Ken Wolf Leave a Comment

FP&A Done Right

As we near the end of the decade, it’s a good time to think back about what businesses have learned from an FP&A perspective, and how they can fortify and position themselves for the next decade and for future decades.

The beginning of this decade saw the evolution of online analytical processing (OLAP) systems, such as our beloved TM1, grow into comprehensive and sophisticated platforms for holistic financial and operational performance management. In theory we had the tools to empower Finance to reveal the secrets of business success locked in our systems and in our data.

The last few years of the decade have seen our imaginations captured by the disruptors, the unicorns and those who have seemingly mastered the elusive “digital transformation.” But as we’ve learned over the last quarter, some of those “darlings” of the business world may not be the successes they first appeared to be. Take WeWork for example: the company has not managed growth effectively. They are at a point (or possibly past it) where Finance could step in, do some serious analysis and revisit the company’s business model. Other headline catching companies are growing exponentially, but struggle with delivering profits. This too, points to where Finance can be playing a larger role.

Business Resilience? Or Agility?

These musings were prompted by a recent article by McKinsey on business resilience. When we think about disruptors and unicorns, we might associate them more with the popular FP&A theme of business agility. One of our business partners, Adaptive Insights, frequently talks about business agility in the context of needing to make faster and more informed decisions. The backbone of this is continuous planning, which is spearheaded by the Office of Finance.

In one sense, perhaps, business agility is the young business, the quick, rookie running back on the football field – dodging and weaving and making stellar plays, with end zone celebrations when the offense is in control of the game.

But where does resiliency come in? To me, the resilient business is the more established, mature defensive linebacker, whose job is to thwart the competition, and who is less likely to be celebrating in the end zone, but just as important to winning the game.

The question for all of us, on the precipice of a new decade is, “Will we be playing a mostly offensive game in the next few years, or a mostly defensive game? Perhaps both.” And furthermore, how do we, the CFOs and the leaders in the Office of Finance, best prepare, plan and enable our organizations for what’s to come?

Facing the Future

McKinsey mentions that while we are still in “the largest global economic expansion in history, the outlook is uncertain.” Isn’t it always? The article states that in the company’s latest survey on economic conditions, “executives’ views on the current global economy and expectations of future global growth are less favorable than they have been in years.” I’d posit a good executive is outwardly optimistic and inwardly financially, cautiously pessimistic.

It is in this context that McKinsey examines what makes a company resilient. The article defines resilient organizations as those that exhibit a “willingness to take decisive action to strengthen their balance sheets and improve cash flow before the [previous] downturn hit, often by divesting non-core assets, reducing debt, and improving the efficiency of working capital.” To become a resilient business, McKinsey recommends the following three steps:

  1. Enhance the role of the finance team. They recommend doing this in strategic planning, business analytics and decision-making at all levels of the organization. As the article states, “The best way to do this is to embed finance managers alongside business unit leaders and empower them to be partners in running the business.” Think about that for a moment – take the traditional “bean counter” out of Finance and put her or him with the business unit leader. Imagine the possibilities: the finance professional knows where the data is, how to get answers from that data, and how to slice and dice that data in different ways. The business leader knows what questions to ask – questions urgent for today’s business challenges and vital for tomorrow’s business opportunities and threats.
  2. Pressure test capital structure and scenario plan. McKinsey recommends doing this with both capital structure and cash flow, and using a range of scenarios, “from an economic crisis to other disruptive events.” You might feel somewhat certain your industry will not have a massive disruption like that of Uber on the taxi industry. But what if you are a sports arena? How much overall revenue could, for example, MetLife Stadium lose should there be an NFL strike? Over how many games? While that is not a global crisis, it is an economic crisis with impact far beyond ticket sales. On a global level, are companies pressure testing and scenario planning for the potential impact of Brexit, of various international tariffs and trade disputes that, significantly increase the price of French cheeses and wines served at the high-end luxury suites at a stadium?
  3. Take immediate action to harvest hidden value from their balance sheet. McKinsey research shows “that working capital management is surprisingly variable, even among companies in the same industry.” The organization has found that “large companies that make a focused effort can typically free up more than $100 million from working capital and redeploy it to priority projects.” This argues for going beyond traditional budgeting and embracing more flexible planning methodologies, such as rolling forecasting or active planning. For example, McKinsey revealed that they saw “upside realized by companies that consistently track cash returns on an asset level and that make an ongoing effort to reevaluate and mitigate their liabilities.” With traditional budgeting and planning, you are assessing your balancing sheet in the past. By adopting rolling forecasting or active planning – where you have the tools and skill sets to assess and adjust your balance sheet proactively – you have the power to gain this upside.

As McKinsey states, “While most CFOs have a role in setting company strategy, the rest of the finance organization are sometimes viewed as passive scorekeepers. Best-in-class organizations, in contrast, expect their finance professionals to play a substantial role with business-unit leaders to set strategic priorities.”

Your Game Plan: Find Your Enabling Technology

So, what’s your best game plan for the coming years? McKinsey specifically mentions these best-in-class organizations have finance teams that “utilize innovative performance management tools to help determine how the business is actually performing and suggest steps to optimize results.” At Revelwood we’ve been consulting on and delivering solutions for financial and operational performance management for 25 years. One would think most mid-sized businesses have moved off of spreadsheets for their budgeting, planning and reporting activities. But, day-after-day, our team here speaks with not just new upstarts, but established, even large, publicly traded companies that rely on spreadsheets as the backbone of their core activities in the Office of Finance. Spreadsheets have a role in the Office of Finance and always will. But any organization that uses only spreadsheets simply can’t achieve true resiliency. And they can’t embrace agility.

Your Game Plan: Think Differently About the Office of Finance

How can you unlock the potential hidden within your finance team to add true value to the business? Think differently about how to enhance your team members’ roles. Maybe it’s even a matter of breaking up some aspects of the physical office and having finance team members sit among their associated business units. Separate their function from their strategic role. Be agile about how you think about your people and what they can do for the business.

The End Game: Resilience and Agility

As I mentioned, we think the victors of the next decade will strike a good balance between resilience and agility. Or, offense and defense. Invest in the right enabling technology, rethink the role of the Finance team, and build the skillsets and mindsets for both. That’s your best game plan.

Home » Financial Performance Management » Page 26

Filed Under: FP&A Done Right Tagged With: Adaptive Insights, agile planning, Analytics, business agility, business resilience, continuous planning, Financial Performance Management, FP&A, FP&A done right, IBM Planning Analytics, ken wolf, Rolling Forecasts, TM1

IBM Planning Analytics Tips & Tricks: The New Planning Analytics Admin Approach

December 17, 2019 by Lisa Minneci Leave a Comment

Video

In our latest IBM Planning Analytics Tips & Tricks video, Lee Lazarow, Revelwood’s FP&A Technology Director, shows you a new, single location in Planning Analytics where you can perform all your administrative tasks. This saves Planning Analytics admins time and simplifies your maintenance activities by enabling you to do all the tasks you would normally do through Windows services.

With this new approach to administration, Planning Analytics now combines server maintenance, database configuration and user definitions all into a single dashboard.

Watch this video to learn how to:

  • Get the status of your servers
  • Look at log files
  • Examine processes
  • Look at and control individual threads
  • Manipulate configuration settings, including your MTQ – multi-threaded querying setting

Planning Analytics new approach to administration saves you time and simplifies maintenance. This video will show you how to take advantage of this new feature.

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!

Want to get our Planning Analytics Tips & Tricks delivered to your inbox every Tuesday? Sign up to get our weekly email of just the week’s tip!

Check out our IBM Planning Analytics Tips & Tricks video series:

Dimension Maintenance in IBM Planning Analytics

Regions with Rules in IBM Planning Analytics

Bookmarking in IBM Planning Analytics

Snap Commands in IBM Planning Analytics

Pivoting & Selecting Shortcut in IBM Planning Analytics

Home » Financial Performance Management » Page 26

Filed Under: IBM Planning Analytics Tips & Tricks, Videos Tagged With: Analytics, Financial Performance Management, IBM Cognos TM1, IBM Planning Analytics, lee lazarow, Planning Analytics admin, Planning Analytics maintenance, TM1, video

IBM Planning Analytics Tips & Tricks: Rule Timestamps

December 10, 2019 by Lee Lazarow Leave a Comment

Tips & Tricks

TM1’s print report wizard still exists in Perspectives and many clients continue to use this approach. I recently came across an issue where a client wanted to “burst” a report and include a time stamp on a report that is being snapshot (e.g., set the cells to contain actual values and not TM1 functions that retrieve values).  Easy peasy … just use the =NOW function to generate a time stamp. Right?

Wrong. =NOW is not a TM1 formula. This means that the cell will not get converted and the timestamp would therefore refresh each time the report was opened/refreshed.

Ok, no problem. We can create a numeric value in a control cube that uses TM1’s NOW function. The time stamp will refresh each time the cell is referenced and we can then zap that value. Again, easy peasy. Right?

Wrong again! TM1 only refreshes numeric rules when the rule is re-processed. In order to keep updating the result (e.g., show the current time and date), the user would need to reprocess the rule each time.

Again, no problem. TM1 may not re-evaluate the numeric value, but it will re-evaluate a string rule like this each time the cell is queried. So we can just switch this into a string value and simply use a STR formula against the NOW command. Right?

Wait for it … wait for it …

Wrong once more! Remember that date stamps within TM1 and Excel vary by 21,916 days (well, maybe). As a result, we need to add these days to the formula. The end result gives us a formula that uses a combination of STR, NOW, 21916, lots of digits and decimals, and a trim of the wasted space.

IBM Planning Analytics Tips & Tricks: Rule Timestamps

… and this end result gives the client the ability to have a time stamp using a TM1 formula that can be snapshot and then converted into a date format!

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! Or, sign up to get our Planning Analytics Tips & Tricks delivered directly to your inbox!

Read more IBM Planning Analytics Tips & Tricks:

IBM Planning Analytics Tips & Tricks: New Configuration Settings for Dates

IBM Planning Analytics Tips & Tricks: Writing Rules

IBM Planning Analytics Tips & Tricks: Rule Concepts that are Often Forgotten

Home » Financial Performance Management » Page 26

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

FP&A Done Right: What Prevents Business Agility

December 6, 2019 by Revelwood Leave a Comment

FP&A Done Right

This is a guest blog post from our partner Workday Adaptive Planning, written by Gary Cokins. Cokins examines what business agility really means for the Office of Finance.  

There’s a lot of talk these days about business agility. Yet it’s much more than just a trendy new business term to throw around at a networking lunch. Ask any C-suite executive if their organization could be more agile, and they will likely answer yes. But what does agility mean, and why does it matter?

An agile company can respond quickly to change as it happens, opening the door to new opportunities and minimizing the risks of threats and challenges from competitors, changing market conditions, digital technology disruptions, etc. If your company can think fast, be nimble, and move first, it’s positioned to gain a significant competitive advantage in today’s data-driven, fast-paced world.

A problem is many companies over-plan and under-execute. To be competitive today, companies must embrace a “speed to results” culture. This does not mean a “ready-fire-aim” approach to decision-making and actions. But they must move fast with a constant sense of urgency.

“Any company designed for the 20th century is doomed to failure in the 21st,” says David Rose, CEO of Gust. In other words, agility is no longer a nice-to-have. It’s the cornerstone of modern business success. But achieving a responsive, dynamic organization is easier said than done.

Barriers to agility are often so entrenched that overcoming them can seem incredibly challenging, especially when compounded by static, manual planning. Relying on racked-and-stacked table reports is insufficient. Robust modeling software, enhanced with visualization features, is needed.

Ultimately, business agility is about having the right tools to efficiently manage and measure change quickly, accurately, and comprehensively. And most of that comes down to how you plan. What is needed can be referred to as “active planning.”

Here are the three primary barriers to business agility:

Barrier #1: Manual processes and ad hoc reporting

Most finance teams use Excel to create reports, track financial projections and budgets, and synthesize numbers across departments. And it’s no wonder. Excel is an effective tool for building custom formulas, scenarios, and look-ups. As a stand-alone budget and reporting tool, however, it has some significant drawbacks, including the slow, cumbersome processes Excel perpetuates. Using Excel’s columns-to-rows math is restrictive. Greater flexibility is needed with modeling software.

Relying on Excel to reconcile budget numbers and bring business unit projections into alignment with corporate forecasts is a herculean task—rife with errors, broken formulas, and missed deadlines. By the time finance gets the numbers to match, they’re usually out-of-date.

Then there are time-consuming ad hoc requests. Who hasn’t had a CFO request detailed reports about revenue fluctuations or variances of planned-to-actuals by region, or expense increases due to higher healthcare premiums? In fact, 60% of CFOs say ad hoc analysis can take up to five days. Ultimately, ad hoc reporting is used to fill a gap in a company’s reporting process—a gap that can be filled with automated planning and reporting.

Excel doesn’t need to be replaced, however. Excel can augment automated planning. Used in conjunction with a cloud planning solution, it becomes one piece of a continuous, comprehensive, and collaborative planning process.

Barrier #2: Lack of alignment and collaboration

World-class companies know that organizational alignment on KPIs is a predictor of business success. Tracking performance against goals, ideally with targets set for the KPIs, and then flagging under- or over-performing business units monopolizes finance team resources. Finance is so busy with low-value but time-consuming tasks like balancing spreadsheets, fixing broken formulas, and nudging managers to submit budget requests, that they’re usually too swamped to steer overall financial strategy, let alone help facilitate and build collaboration.

Manual tasks hold finance hostage to mundane (albeit critical) processes, keeping data siloed and business decision-makers in the dark. Lining up behind KPIs is extremely difficult under these circumstances. These pockets of disconnected information keep decision-makers from effectively planning for what’s next.

And alignment around KPIs or collaboration under these circumstances? Not likely.

It’s not surprising that a majority of CFOs report lack of time as the biggest barrier to collaboration. Continuous firefighting and pursuing short-term priorities get in the way. When business processes become more efficient, however, collaboration is achievable. Productivity increases. Without alignment with KPIs, the disconnects between sales and operations, or production and management, or marketing and sales, make true agility impossible.

Barrier #3: Disjointed planning

By their very nature, resource allocation decisions need to reflect current circumstances—not the supply and demand challenges from last year and not financial reports that are three months old. Whether or not to hire more people, alter supplier relationships, invest in skills training, or accelerate capital investment plans largely depend on whether an organization plans effectively and agilely. And to plan effectively requires far more than a series of budget meetings and annual reports. It gets worse when different departments have their own set of numbers, revealing the need for a single version of the truth.

Disjointed and static planning flows from ad hoc information, missing data, and siloed decision-making. Active planning, on the other hand, helps organizations predict and respond quickly to potential gaps in performance and course-correct swiftly and agilely to changing market conditions.

But to do that requires a comprehensive and collaborative approach to planning that incorporates the latest information in near real time. In short, it requires active planning.

A way forward

The sought-after capabilities of agility—to see change coming, rapidly adapt to it, and turn uncertainty into business opportunities—can only be achieved by changing fundamental processes. Automating reporting so that it flows from multiple coordinated systems (ERP, CRM, HCM, etc.), generating reports in real time, and giving managers access to self-service reporting are all critical to an active planning process. Equally critical is to avoid digitally cementing existing processes that need to be redesigned.

While static planning produces monolithic plans that aren’t a true reflection of the business environment, active planning is different. It’s about listening to what your data is telling you about your goals, resources, suppliers, customers, competitors, and the wider market. Where static planning is top-down, siloed, slow, and limited, active planning is collaborative, continuous, and comprehensive. In other words, active planning allows you to plan and forecast at the speed of modern business.

By deploying a modern planning solution that enables active planning, your company can streamline FP&A processes, gain insights more quickly, and make better decisions faster. And be able to respond to change as it happens.

Don’t get stuck in the back office reconciling numbers and fixing broken links. Become a strategic partner by giving decision-makers access to the information they need with easy-to-use self-service reports, up-to-date data, and strategic insights.

Barriers to agility? With active planning, they’re easy to overcome.

Gary Cokins is an internationally recognized expert, speaker, and author in enterprise and corporate performance management (EPM/CPM) systems. He is the founder of Analytics-Based Performance Management LLC. Gary can be reached at gcokins@garycokins.com

This blog post was originally published on the Workday Adaptive Planning blog.

Sign up for our FP&A Done Right series

Get our FP&A Done Right series sent directly to your inbox. Sign up here. 

Home » Financial Performance Management » Page 26

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

IBM Planning Analytics Tips & Tricks: Learn the Excel CELL Formula

December 3, 2019 by Lee Lazarow Leave a Comment

Tips & Tricks

Excel is, and always will be, a powerful tool for the financial team. With so much power, there are many great Excel formulas that rarely get used. I recently had a situation where I wanted to easily replicate a sheet and have each sheet use an MDX expression that referenced a different dimension name. I wanted to use a formula to determine the sheet name and used the CELL function.

The CELL function returns information about a specific cell within an Excel file. The syntax of the function is

CELL( info_type, reference ) 

The info_type defines the type of information to be returned and reference is associated with a specific cell. Some examples of info_type include “col” to define the column, “row” to define the row, “address” to define the cell refence and “filename” to return the full path and filename of the workbook and the worksheet.

The resulting format of the info_type called filename is

path[workbook.xlsm]sheetname

I took the approach of naming the sheet with the same name as the dimension. For example, one sheet was called “Account” and another sheet was called “Company.” By using a combination of the FIND function, the MID function and the TRIM function I was able to isolate the sheet name.

=TRIM(MID(CELL("filename",A1),FIND("]",CELL("filename"))+1,99))

I created this formula in cell B10 and then used the result within my MDX expression.

="{ TM1DRILLDOWNMEMBER( { ["&B10&"].[Orphans] }, ALL, RECURSIVE ) }"

This approach allows me to replicate an Active Form report by simply copying the entire sheet and then renaming the new sheet to be the same as the dimension name.

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-related tips & tricks:

IBM Planning Analytics Tips & Tricks: Recalculating Excel Worksheets

IBM Planning Analytics Tips & Tricks: Workarounds for Unsupported Excel Functions in TM1 Web

IBM Planning Analytics Tips & Tricks: New Excel Feature – XLOOKUP

Home » Financial Performance Management » Page 26

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

IBM Planning Analytics Tips & Tricks: Trimming Picklists

November 26, 2019 by Lee Lazarow Leave a Comment

Tips & Tricks

Did you know that IBM Planning Analytics includes a feature that helps trim the list of choices in a picklist as you type? There are many different ways to create picklists in TM1/Planning Analytics and Revelwood has previously written about creating picklist cubes.

Here is an exploration that uses a picklist. This list entails all base level elements of a dimension. As you can see, there are six options to choose from.

IBM Planning Analytics Tips & Tricks: Trimming Picklists

I can select a value by clicking on an element from the list, which is great when I have a small list like this. But what if I have hundreds of elements in the list? The list can quickly become hard to navigate.

I can instead type in the “Search” area. If I type the letter “F” then my list is reduced to the only elements that contain the letter F.

IBM Planning Analytics Tips: Trimming Picklists

You can see that the list does not just look at the first character … it instead looks at all characters. As another example, if I instead type the letters “ment” then the list will trim down to anything that contains these letters within the full string.

IBM Planning Analytics Tricks: Trimming Picklists

This approach can help your end users when selecting cost centers, employee names, or other long lists.

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!

Want to get our Planning Analytics Tips & Tricks delivered to your inbox every Tuesday? Sign up to get our weekly email of just the week’s tip!

Learn more about picklists in IBM Planning Analytics:

IBM Planning Analytics Tips & Tricks: Creating TM1/Planning Analytics Picklist Cubes

IBM Planning Analytics Tips & Tricks: When to Build Multiple Cubes

Home » Financial Performance Management » Page 26

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: Are you Ready to Start Analyzing Differently?

November 22, 2019 by Revelwood Leave a Comment

FP&A Done Right

This is a guest blog post from our partner Workday Adaptive Planning, written by Anders Lui-Lindberg. Lui-Lindberg’s blog post fits perfectly with our series’ theme of sharing insights on how the Office of Finance can change from traditional budgeting and “business as usual” to more agile, sophisticated practices.

 If there’s one thing a finance professional can do forever, it’s analyze stuff. We’re never short of data to analyze, and there are always more details to be ironed out. We love analyzing stuff so much that we almost forget the purpose of doing the analysis.

The purpose is to improve business performance through improved decision-making. That means that the analysis must produce an outcome that can be presented and discussed with business leaders. Too often though, we don’t get to that stage, and yet again finance falls short of making an impact.

It’s time to change the ideal of a good finance professional

I’ve often heard: “You can be the best finance professional in the world, but if you can’t communicate the results of your analysis, then it doesn’t matter.”

There’s only one problem with this statement. If you can’t communicate the results of your analysis, then you’re not the best finance professional in the world! In fact, in a disrupted finance value chain, you’re not much good at all.

I know this is a tough message, but we must signal to all finance professionals that doing analysis will soon be a thing of the past when algorithms and machine learning take over. Through these, we can get much deeper insights and at a much faster pace. Sure, humans might still need to put some finishing touches on it or spend a bit of time interpreting the results, but forget about spending days analyzing stuff in Excel.

Today when I ask finance professionals how much time they spend on the different activities in the value chain, “analysis” often hits 30%. That’s 30% on your own, behind a screen, doing analysis in Excel or some other tool. Granted, if in that time you can produce several golden nuggets of insight that can significantly improve decisions, then it might be worth doing. Most often we don’t though, and if you consider that an additional 35% of the time is spent on working data and reporting, then it leaves very little time to work with your stakeholders to improve their decision-making.

What kind of analysis are we really doing then?

So, what’s an ideal finance professional? We’ll uncover more of the answer in later articles, but building upon a week in the life of the business partner as pictured below, let’s look at how much time is spent on analysis.

It’s Monday morning, and the report landed on your desk as we saw in last week’s article, “Who’s running your reporting landscape?” You spend 15-30 minutes looking through the report to both ensure that the data makes sense and analyze the key developments. Through your previous dialogues with your stakeholders, you already know what’s happening in the business and therefore can much faster connect the variances to real business events.

You’re now ready for the weekly Monday meeting with your stakeholders. We’ll talk more about what happens there next week. On Tuesday though, it’s time to do some more analysis, but in a different way. Here you problem-solve with your stakeholders on how to improve business performance. You use a structured framework to consider your options and prepare a final recommendation to be presented on Wednesday. This could still take a full day or a day and a half, but as much as you’re analyzing your options, you’re also discovering insights and influencing decisions already through the problem-solving stage.

As you can see, this is a very different approach to analysis compared to what you’re used to. Instead of being buried in Excel sheets, you’re out there discussing real business problems with your stakeholders and together with them coming up with solutions. Those solutions, if designed and executed well, will bring tangible value to the bottom line of the company. Are you ready to start analyzing differently?

Anders Lui-Lindberg is a senior finance business partner at Maersk and the co-founder of the Business Partnering Institute. He is also the co-author of the book Create Value as a Finance Business Partner and a longtime finance blogger with more than 33,000 followers.

This blog post was originally published on the Workday Adaptive Planning blog.

Home » Financial Performance Management » Page 26

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

IBM Planning Analytics Tips & Tricks: Simplifying Dimension Maintenance

November 19, 2019 by Lisa Minneci Leave a Comment

Videos

Watch our latest IBM Planning Analytics Tips & Tricks video to learn how to simplify dimension maintenance in Planning Analytics. Once you master these easy techniques, you’ll be able to do all of your dimension maintenance from the Planning Analytics Workspace (PAW) administration screen.

In this video, Lee Lazarow, Revelwood’s FP&A technology director, demonstrates how to maintain your dimensions in PAW. Lee shows you how to move elements using both a standard drag-and-drop approach and a wizard-based approach. You’ll also see how to create new hierarchies and how to manipulate your dimension structure without going to a different screen.

By merging all aspects of a dimension together, you can do all your dimension maintenance from the PAW administration screen.

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!

Want to get our Planning Analytics Tips & Tricks delivered to your inbox every Tuesday? Sign up to get our weekly email of just the week’s tip!

Check out our IBM Planning Analytics Tips & Tricks video series:

Regions with Rules in IBM Planning Analytics

Bookmarking in IBM Planning Analytics

Snap Commands in IBM Planning Analytics

Pivoting & Selecting Shortcut in IBM Planning Analytics

Home » Financial Performance Management » Page 26

Filed Under: IBM Planning Analytics Tips & Tricks, Videos Tagged With: Analytics, Budgeting, Budgeting Planning & Forecasting, Financial Performance Management, IBM Cognos TM1, IBM Planning Analytics, Planning & Forecasting, Planning & Reporting, Planning Analytics Tips & Tricks, Planning Analytics video, Planning Analytics Workspace, Revelwood, TM1, video

IBM Planning Analytics Tips & Tricks: PAx Control Objects

November 12, 2019 by Lee Lazarow Leave a Comment

Tips & Tricks

IBM Planning Analytics uses cubes to store metadata information such as security and attribute information. These automatically generated cubes are called control cubes (which I sometimes call “squiggle cubes”) and begin with a prefix of a right curly brace.

Server Explorer used a toggle approach within the View menu to allow users to either view or hide these cubes. Planning Analytics for Excel (PAx) also includes a toggle approach that can be used via the following steps:

1) Ensure that the task pane is showing by selecting the icon within the IBM Planning Analytics ribbon

IBM Planning Analytics Tips & Tricks: PAX Control Objects

2) Click on the icon for “show and hide”

Understanding PAx Control Objects - IBM Planning Analytics Tips & Tricks

3) Select the option for “show control objects”

How to use PAx Control Objects - IBM Planning Analytics Tips & Tricks

Once selected, the list of cubes will expand and will display the control cubes. This list can be controlled via cube security to limit which control cubes can be seen by the user.

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: Troubleshooting Planning Analytics for Excel (PAx)

IBM Planning Analytics Tips & Tricks: The Ranked Report

IBM Planning Analytics Tips & Tricks: The Replace and Close Feature in PAx

Home » Financial Performance Management » Page 26

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

  • « Go to Previous Page
  • Page 1
  • Interim pages omitted …
  • Page 24
  • Page 25
  • Page 26
  • Page 27
  • Page 28
  • 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.