• 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

Best-in-Class Companies Regularly Select Integrated Planning and Reporting Solutions

September 14, 2020 by Lisa Minneci Leave a Comment

News & Events

According to the recent BARC Score report, best-in-class companies regularly select integrated planning and reporting solutions, such as IBM Planning Analytics, over Excel or home-grown systems. This report gives an overview of the planning and analytics market and provides strengths and weaknesses of leading vendors in the space.

The BARC Score report states, “Today, the reality in many companies is that integrated planning and analytics is an often proclaimed, but seldom achieved goal … So Excel, as the lowest common denominator, is often the default first choice for integrating planning with analytics. However, the lack of coherence of data and functionality resulting from using Excel instead of specialized software tools, are frequently cited reasons for user dissatisfaction, inconsistencies or error susceptibility with planning and analytics in companies today.

The report continues, “companies that use integrated software platforms for planning and analytics experience far fewer problems than those that address both topics separately with different software tools.”

IBM Ranked a Market Leader in Report

This report covers “all of the leading vendors as well as many smaller vendors that often have less visibility, but equally offer outstanding value to their customers. The vendors included are: Anaplan, Board International, IBM, Infor, Jedox, Longview, OneStream Software, Oracle, Prophix, SAP, Unit4 Prevero, Wolters Kluwer | CCH Tagetik, and Workday (Adaptive Insights.)

BARC Score report 2020

BARC’s assessment of IBM includes its portfolio of planning and analytics products – IBM Planning Analytics, powered by TM1, IBM Cognos Analytics, IBM Watson Studio and IBM SPSS. BARC lists IBM’s strengths, including:

  • IBM Planning Analytics offers comprehensive flexibility for business power users to create planning and analytics applications based on a high performance in-memory database
  • Comprehensive Excel-based functionality for preparing individual planning and analytics content in IBM Planning Analytics (modeling, custom planning forms, etc.) and publishing it to the web
  • Well-established and expansive partner community with global product support and knowledge

The BARC Score report is based on data points from The Planning Survey, The BI Survey and numerous analyst interactions. Download your copy of the report today.

Home » Financial Performance Management » Page 20

Filed Under: News & Events Tagged With: BARC, BARC Score report, Budgeting Planning & Forecasting, Financial Performance Management, IBM Cognos TM1, IBM Planning Analytics, Planning & Forecasting, Planning & Reporting, TM1

FP&A Done Right: How CFOs Can Lead in Today’s Challenging Environment

September 11, 2020 by Revelwood Leave a Comment

This is a guest blog post from our partner Workday Adaptive Planning, written by Steve Dunne. It is the second in a series looking at macro trends in the economy. This post explains how the CFO can play a strategic role in today’s uncertain business environment.

Even before the COVID-19 pandemic, businesses were facing a plethora of social, economic, and technological challenges, as discussed in the first article of this series. Yet change and uncertainty—while sometimes painful—can create new opportunities, as long as people and organizations have the agility to leverage change for the better.

This is particularly true for the finance function. CFOs must be prepared for both short-term and long-term uncertainty to fully understand and mitigate risk for their organization. This requires a fundamental shift: To become the strategic guide the business needs, finance leaders and their teams must embrace and accept continuous change as part of the new normal.

But how? Below are five key areas for finance leaders to explore in order to guide their businesses through persistent change.

Planning, Liquidity, and Risk Management Are Key to Finance Agility

During uncertain times, it’s difficult to forecast specific revenue and expense targets with any degree of accuracy. Businesses must be able to model rapidly changing conditions, and this demands organizational agility. Uncertainty heightens the need for more dynamic business planning based on a range of scenarios rather than traditional quarterly or annual planning cycles.

Having the ability to conduct more dynamic business planning means organizations can respond to changes and course correct to better understand the impact on top-line revenue and bottom-line expenses. For example, are customers paying on time? What are the implications of a percentage of those customers not settling invoices? Which supplier contracts need to be renegotiated based on changes in demand?

Discussing her own experience of business planning during COVID-19, Workday Senior Director of Corporate Finance Kinnari Desai says, “We were able to leverage actuals data from Workday Financial Management into our forecasts. This enabled us to see the resulting impact on the P&L and cash flow right away. All in all, we were able to speed up the process and operate 50% faster versus using spreadsheets.”

Similarly, during tough times finance functions are also well placed to help business leaders forecast cash and liquidity and identify risks with greater speed and accuracy. Many organizations have multiple sources of cash and creating a complete picture of their overall cash position and liquidity can be challenging without the right tools.

Keep Stakeholders Informed and Aligned with Key Insights

The need to make insights more accessible across an organization is heightened during times of uncertainty, and it doesn’t help when data is trapped in departmental silos or locked away in different tools and requiring time-consuming integrations. Workday research shows that over half of respondents we surveyed believe access to data within their organization is somewhat accessible but remains outdated and siloed within functional teams.

Businesses should have access to financial, workforce, and operational data together, as a single source, to answer fundamental stakeholder questions. Other C-suite leaders are increasingly looking for deeper insights from a wider range of data sources to help them make better decisions. For finance, this means having the ability to share credible insights with the wider business and, more importantly, encouraging these stakeholders to take action based on this data.

For example, finance needs to provide the business with better insights into working capital to better understand minimum cash and liquidity requirements. While the primary focus for most companies is on growing the top line while carefully managing the bottom line, this can lead businesses to take for granted routine but critical back-office activities, such as paying bills and turning receivables into cash.

Thomas Willman, principal, finance advisory global practice leader at The Hackett Group, told me, “Finance organizations must take advantage of opportunities to extend payables while still taking care of their most strategic suppliers. They must also share these insights with the wider business. It will be imperative for CFOs to put a sound plan in place to preserve cash and liberate cash that is tied up in working capital.”

Similarly, executives are looking for insights from finance on how they should manage investor expectations during periods of persistent change. This includes thoughtful and proactive communication and risk mitigation planning in advance of regularly scheduled earnings reports.

CFO Efficacy: Report from Any Location

The COVID-19 outbreak changed the rules completely in terms of how and where businesses operate. With employees now working from home, many finance functions had to consider new ways to keep delivering critical services, such as closing the books. This raised questions for finance leaders around the processes and controls required to support a remote close and the risks associated with performing “finance-as-usual” tasks outside the walls of the business.

The need for finance to embrace more efficient, dynamic ways of working pre-dates the global pandemic, yet it is now proving to be a significant catalyst for transformation. For finance, that means embracing automation and emerging technologies, such as machine learning, that can be applied to key processes. CFOs have long since been looking to reduce the time spent on processes such as closes, consolidations, reporting, and payroll—what’s happened in 2020 has now made this an imperative.

The Hackett Group’s Willman explains, “Finance has had to transform in so many ways in 2020. What hasn’t changed is that all of this work still has to be done; what has changed is that it has to be done away from the office. Finance professionals are exploring things such as machine learning and how it can identify patterns and make recommendations that previously would have required manual intervention.”

In addition, compliance and audit don’t suddenly stop during times of crises. Finance is still required to provide effective controls to enable auditing—even if it has to be done remotely. When discussing the company’s remote close, Philippa Lawrence, chief accounting officer at Workday, says, “We asked our internal audit team to review some of the more important and impactful controls to confirm they were operating as they should. Financial controls need to operate the same remotely as they would during any quarter-end close.”

Understand Skills and Opportunity for the Future of Finance

More than half of respondents to a global Workday survey said they planned to reskill at least 50% of their workforce by 2024 to contend with the changing world of work. Today, how will the plethora of macro-challenges to global business further intensify this conversation? How will the emergence of machine learning and other data-driven technologies influence how business leaders—including the CFO—reskill or upskill talent for their organization?

We are at the crossroads of a technology and people transformation. Finance has traditionally been stuck in the role of gatekeeper, intrinsically bound to manual transaction processing and tied to systems that prevent it from becoming a strategic guide to the business. Now, with the global appetite for automation and the technological capability in place, finance should seek to transform.

And this should be viewed as an opportunity for finance, rather than a threat from the rise of the robots, as long as AI is used in a way that continues to put people first. A poll of 375 executives by MIT Technology Review Insights revealed that “pandemic preparedness will speed up AI deployment and accelerate the pace of AI innovation in high-risk job categories, causing both ‘job-positive’ and ‘job-negative’ effects.”

Finance is well-placed to cast aside legacy technology challenges and develop the skills of its existing workforce to benefit from emerging technologies. Now may be the optimal time to drive this transformation.

Collaborate and Communicate to Build Trust and Integrity

According to Deloitte, in the article “COVID-19: Maintaining Customer Loyalty and Trust During Times of Uncertainty,” consumers—whether purchasing for themselves or for their organization—increasingly want to buy from companies that demonstrate integrity in how they treat their employees, their customers, and the environment. These consumers seek trust, honesty, transparency, equality, and a better overall experience.

Blake Morgan, author and customer experience futurist, wrote in Forbes, “An amazing customer experience is one of the biggest competitive advantages a company can have. Instead of competing on price, more than two-thirds of companies now compete mostly on the basis of customer experience.” And, based on Edelman’s analysis of stock prices in 2018, high-trust companies beat the rest of their sector by 5% on average.

For businesses, this is often about making bold internal changes and committing to operating differently. It’s about being open and transparent, as well as being able to pivot and adapt to meet customers’ changing needs. Finance has its own part in this journey toward trust and transparency by delivering real-time data from a variety of sources and delivering these insights to the rest of the organization to drive collaboration and better decision-making.

Large businesses are being asked by stakeholders to stop merely promising to put purpose over profit, and instead make trust an organic value ingrained within their organization. This requires the right technology and processes to enable these businesses to track and analyze the data, then deliver it — whether financial, legal, or compliance—to key constituents in order to be held accountable.

Focusing on the right areas will be absolutely key for finance leaders as the world starts to spin again. Making agility a priority, while arming the organization with the right insights to make better decisions and understanding how finance will deliver what the business needs — potentially from any location — will also be paramount. All of these factors exist alongside a heightened need for brand trust and transparency — something which the finance function will play a key role in delivering.

This blog post was originally published by Workday Adaptive Planning and appeared here.

Read more guest blog posts from Workday Adaptive Planning:

FP&A Done Right: 3 Steps to Help you Plan for What’s Coming

FP&A Done Right: Reforecasting in a COVID-19 World – Best Practices you can Implement Now

FP&A Done Right: FP&A Tips for Scenario Modeling During COVID-19

Home » Financial Performance Management » Page 20

Filed Under: FP&A Done Right Tagged With: Adaptive Insights, Analytics, CFO, CFO + leadership, CFO efficacy, COVID-19, finance agility, Financial Performance Management, Revelwood, Workday Adaptive Planning, Workday survey

IBM Planning Analytics Tips & Tricks: Excel LET Function

September 8, 2020 by Lee Lazarow Leave a Comment

Have you ever created a formula that repeats another formula within a cell? Did you know that this repetition may be slowing down your reports?

For example, you may have a report where you want to pull IBM Planning Analytics data and replace zeros with the word “None.”  You can write this as a formula via:

=IF ( DBRW(cube,dim1,dim2,dim3)=0, “None”, DBRW(cube,dim1,dim2,dim3) )

Within this formula, the IF check first looks at the DBRW formula to determine a value. If the value is not zero then the IF check needs to re-run the exact same DBRW formula to produce the value that will appear in the cell.  This means that one cell potentially needs to run the same formula twice! While this doesn’t sound like a big deal, it can easily impact the performance of your report if you have many iterations of the formula.

Excel has introduced a new function called LET that will help optimize this situation. This function allows you to define a variable that can repeatedly be used within a calculation. It will help you improve performance since it will only execute the calculation once within the cell.

The syntax of the function is:

=LET (VarName, VarValue, Calculation)
  • VarName is the name of the variable to be used
  • VarValue is the value of the variable
    • This can be a hard coded number or it can be a formula
  • Calculation is a formula that uses the variable name
    • This can be a simple formula such as X+Y or it can use any existing Excel function

A simple iteration of this formula can be written as:

=LET (x, 5, x*2)

This formula would result in the number 10.

The LET formula also allows you to define multiple variables.  A simple example of multiple variables can be written as:

=LET (x, 5, y, 2, x*y)

This formula would also result in the number 10.

Using this approach, our initial formula can be rewritten using the LET function:

=LET ( CubeVal, DBRW(cube,dim1,dim2,dim3), IF(CubeVal=0,”None”, CubeVal) )

This ensures that the DBRW pull is only executed once within the cell.

This functionality allows you to optimize your Excel based reports by minimizing the number of calculations that happen within your report.

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

Read more Excel Tips & Tricks:

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

IBM Planning Analytics Tips & Tricks: The Excel FORMULATEXT Function

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

 
Home » Financial Performance Management » Page 20

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

IBM Planning Analytics Tips & Tricks: Control Space

September 1, 2020 by Lee Lazarow Leave a Comment

Tips & Tricks

Have you ever been deep in thought while writing a rule or a process only to realize that you forgot the parameters for a specific command?  IBM Planning Analytics Workspace (PAW) has solved this dilemma by giving you the ability to determine those parameters with a simple set of keystrokes.

PAW’s rule editor and process editor allows you to use Ctrl-Space (e.g., press the control key and the space bar at the same time) to determine the required values associated with any rule or TI command. For example, if I type ATTRS and then press Ctrl-Space, the following will appear on the screen:

IBM Planing Analytics Tips & Tricks: Control Space

I now know the parameters that are required to complete the code.

Ctrl-Space will also help you determine which function to use.  For example, if I type ATTR and then press Ctrl-Space, the following will appear on the screen:

IBM Planning Analytics Tips: Control Space

I am now aware of all the possible attribute functions that are available and can double click on one of the results to have it automatically inserted for me.

If I do not know anything about the name of the functions to use, I can click on the fx button to see a list of the available functions, all grouped by category.

IBM Planning Analytics Tricks: Control Space

This approach allows you to quickly remember the functions and parameters that can be used in your code without having to shift your focus to another screen or manual.

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: Home Button

IBM Planning Analytics Tips & Tricks: Subset Control Dimension

IBM Planning Analytics Tips & Tricks: PAW Pass Context

Home » Financial Performance Management » Page 20

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

IBM Planning Analytics Tips & Tricks: New PAx Feature – Double Click

August 25, 2020 by Lee Lazarow Leave a Comment

Tips & Tricks

IBM Planning Analytics for Excel (PAx) contains a task pane that shows the cubes within your model. Double clicking on a specific cube expands the information associated with the cube, including public views, private views, and the dimensions. Version 49 introduced a new feature to the double click … the ability to launch an exploration browser within your Excel environment.

When double clicking for the first time, you will be promoted to define what happens upon double click. There are two options to select from: Expand and Launch

IBM Planning Analytics Tips & Tricks: PAx double click
  • Expand will show the nodes associated with the cube
  • Launch will open a view editor
  • Note: as of this writing, at least one view must be defined for the launch option to properly work.  IBM is currently working to change this requirement.

After launching and modifying your view, you can then bring the results back to Excel by clicking on the Reports button and selecting the type of report that you want to convert your view into.

New IBM Planning Analytics PAx feature - double click

If you want to reset the action associated with double click, you can change it within the options dialog box.

New double click feature in IBM Planning Analytics for Excel

This feature allows you to quickly analyze data via a drag-and-drop approach and then bring the results back into a Planning Analytics for Excel worksheet.

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: The Collect Feature in Planning Analytics Workspace

IBM Planning Analytics Tips & Tricks Video: The Hold Feature

IBM Planning Analytics Tips & Tricks Video: How to Reorder Cubes in TM1

Home » Financial Performance Management » Page 20

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

FP&A Done Right: 3 Steps to Help you Plan for What’s Coming

August 21, 2020 by Revelwood Leave a Comment

FP&A Done Right

This is a guest blog post from our partner Workday Adaptive Planning, written by Bob Hansen. Read it to learn why static planning no longer works and how to make your business agile.

Throughout the world, businesses of every size are feeling firsthand the impacts of instability. In a time of uncertainty, surviving and thriving comes down to how promptly your business can identify disruptive changes and proactively respond to them.

That’s not so easy when your business is mired in static planning—characterized by long planning cycles, immediately obsolete plans, siloed efforts, and hard-to-find errors. Manual, spreadsheet-based planning, budgeting, and forecasting may have worked well enough in a more predictable age. But as we’re discovering that age is long gone.

Even traditional market forces have proven challenging. Technological advances, ever-increasing customer expectations, and smarter, data-driven decision-making put pressure on finance teams to find new ways to operate with agility.

But how do you plan in a way that allows you to respond to such events, from the predictable to the unlikely?

The answer begins — and ends — with active planning.

Why static planning is a disadvantage

The static, traditional planning models finance teams relied on for decades aren’t just a questionable choice in times of disruption—they can leave your business at a grave disadvantage. Businesses hampered by outdated planning processes are often left scrambling to react to changes while more agile competitors outpace, outperform, and outmaneuver them. Look around you: The companies that are performing well at this minute have pivoted—sometimes substantially—in a matter of weeks, sometimes days. Their business agility has become their defining attribute for success.

It’s safe to conclude that many of these agile businesses aren’t weighed down by manual, episodic, and siloed planning. Rather, they’ve likely embraced a more modern approach to planning—planning that’s collaborative, comprehensive, and continuous. These businesses consistently minimize risk, maximize performance, and create competitive advantages because their planning empowers greater business agility.

The difference between static and modern—or active—planning can be stark. Legacy planning tools are typically bogged down by versioning headaches and siloed, instantly perishable data. In contrast, active planning models allow teams to broaden planning data beyond finance, pulling in real-time operational and transactional data from ERP, HCM, and other slices of the enterprise stack—all to make better, data-driven decisions quickly.

Laying the groundwork for business agility

As many companies recognized even before the current crisis, agility is a business imperative—and this more modern approach to planning is the key to achieving it. These three milestones will get you started on your journey to achieving an active planning model.

I. Assess the status quo

Before you map out where you’re going, you need to understand where you are. Take inventory of the current state of your company, more specifically the business planning obstacles keeping you from implementing a more modern and streamlined planning environment. More than likely, these obstacles will pertain to people, processes, or technology, or some combination thereof.

Assessing where you are means getting granular.

  • What do your current business planning processes look like?
  • How long does it take you to create a budget? A forecast? An annual plan?
  • Where are opportunities for improvement?
  • Who are your planning stakeholders?
  • What technology do you have in place, and how well is it serving you?
  • What data challenges need attention?
  • What are the bottlenecks?
  • What could be automated that isn’t?
  • Are there any opportunities for automated data integration?
  • What are you lacking in workforce planning?

Answering questions like these will help you get a clear sense of what you’re working with and where you can improve.

II. Get organizational alignment

Being a change agent is no easy task. That’s why you’ll need to recruit a savvy senior-level advocate to help champion active planning as a worthy and necessary cause. Along with your senior advisor, you’ll need a task force representative of other departments outside of finance, including operations, sales, and HR. Don’t forget to include IT to help you navigate technology needs and coordinate various data sources.

The next move is to align these key people with the business agility cause you’re championing.

How? Build a business case.

You can do this by quantifying the impact that the organization’s current status quo has on the company. What are manual processes and bottlenecks costing your business in time and money? What opportunities are passing you by? Conversely, what would those measurement strategies and KPI models look like if you implemented an active planning model? Try to unearth more nuanced ROI measures—for instance, how cutting budget time in half could give your people more time to run critical what-if scenarios—to really drive home the meaningful change that a modern agility planning model would bring.

Once your team is in place and your pain points recognized and quantified, you can map out a plan for your initial project. Consider focusing your initial effort on a function within finance so you’ll have control over the rollout. Develop a multi-phased plan that clearly communicates goals (both for implementing active planning and for this inaugural project), a concise and actionable plan, and the key metrics for your KPI model. The ability to effectively communicate the why behind this initiative will help secure any executive buy-in you need for the how. A comprehensive and well-thought out plan will go a long way toward achieving that.

III. Expand across the business

As noted above, there’s a strong case for beginning the rollout of your active planning model in finance and focusing on low-hanging fruit to bring early and easy wins. You’re motoring along, mapping projects, tracking and communicating progress, analyzing KPI reports, and making necessary tweaks. Once a rhythm and familiarity are in place, broaden your scope beyond finance. Initiate planning projects that engage HR, sales, or marketing. This is where you begin to extend the use and impact of active planning company wide.

The key in this phase is to strengthen cross-departmental communication and collaboration. Don’t fall into the trap of relying on your technology or tools to do the heavy lifting. It will be easier to realize and maintain success with regular stakeholder one-on-ones, identifying lessons learned along the way, uncovering opportunities for more ingenuity and improvement, and communicating success and congratulations when they’re warranted.

Doing this will help elevate the role of finance to a strategic force within your organization by orchestrating planning throughout the business. Finance will no longer be known primarily for gathering budget numbers and issuing reports. Instead, your business will look to finance to drive the change and innovation needed to not only weather times of uncertainty, but to thrive in them.

Map your way forward

These three pillars lay the groundwork for creating a more agile planning environment—one that will help you plan for what’s coming, whatever that may be. But since it’s merely a foundation, you’ll want to build on it. Stay tuned for additional insights that can help you derive even greater value from your modern planning environment.

Because the only thing certain about the future is that it will reward business agility. With this foundation and the insights we’ll share in subsequent blogs, you’ll be much better equipped to map your way forward into that tomorrow.

This blog post was originally published by Adaptive Insights and appeared on the Adaptive Insights blog.

Read more guest blog posts from Workday Adaptive Planning:

FP&A Done Right: Reforecasting in a COVID-19 World — Best Practices You Can Implement Now

FP&A Done Right: What FP&A Must do Differently to Make Planning a Success

FP&A Done Right: Modernize your Budget Process to Anticipate Change

Home » Financial Performance Management » Page 20

Filed Under: FP&A Done Right Tagged With: Adaptive Insights, business agility, cloud financial performance management, enterprise performance management, financial agility, Financial Performance Management, Planning & Forecasting, Revelwood, static planning, Workday Adaptive Planning

IBM Planning Analytics Tips & Tricks: Home Button

August 18, 2020 by Lee Lazarow Leave a Comment

Tips & Tricks

IBM Planning Analytics Workspace (PAW) offers an easy to use navigation menu that will quickly allow you to navigate to any open book. This is done by clicking on the menu at the top, center of your screen. Here is a sample menu that shows three open workbooks.

IBM Planning Analytics Tips & Tricks: Home Button

But did you know that you can also go back to PAW’s opening screen via a single click? A “home” button exists at the top, left corner that takes you directly to the welcome page.

The home button in IBM Planning Analytics

This approach will allow you to save time by quickly navigating back to the start via a single click.

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

Read more IBM Planning Analytics Tips & Tricks:

IBM Planning Analytics Tips & Tricks: Create New Books with the Diamond Icon

IBM Planning Analytics Tips & Tricks Video: Formatting Views in Planning Analytics Workspace

IBM Planning Analytics Tips & Tricks: The Collect Feature in IBM Planning Analytics Workspace

Home » Financial Performance Management » Page 20

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

IBM Planning Analytics Tips & Tricks: Subset Control Dimension

August 11, 2020 by Dillon Rossman Leave a Comment

Tips & Tricks

Did you know that dimensions exist within IBM Planning Analytics that display your model’s public subsets?

A dimension called }Subsets_<Dimension Name> is automatically created when a dimension is created. The elements of this new dimension are dynamically updated as permanent public subsets are created and destroyed (note: the creation of temporary subsets does not update this dimension).

These control dimensions allow for easy access to public subsets within TurboIntegrator processes. In addition, the subset control dimensions can be accessed via Architect and Planning Analytics for Excel (PAx).

To access subset control dimensions via Architect:

  1. Make sure “Display Control Objects” is enabled
IBM Planning Analytics Tips & Tricks: Subset Control Dimension

2. Navigate to “Dimensions” and scroll down until you reach “}Subsets_<Dimension Name>”

IBM Planning Analytics Tips: Subset Control Dimension

To access via Planning Analytics for Excel:

  1. On the task pane, make sure “Show Control Objects” and “Show Dimensions” are both enabled
IBM Planning Analytics Tricks: Subset Control Dimension

2. Navigate to “Dimensions” and scroll down until you reach “}Subsets_<Dimension Name>”

Subset control dimension in IBM Planning Analytics

This feature gives you an easy approach to see (and loop through) your public subsets without having to create scripts that reference Windows folders.

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: Maintaining Subset Driven Consolidations

IBM Planning Analytics Tips & Tricks: Compatibility of Views and Subsets

IBM Planning Analytics Tips & Tricks: The New Set Editor

Home » Financial Performance Management » Page 20

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

The Impact of COVID-19 on Lease Planning and Management

August 10, 2020 by Lisa Minneci Leave a Comment

FP&A Done Right

The COVID-19 pandemic has impacted almost every industry – and will continue to do so into the foreseeable future. Corporate real estate and the real estate investment trust (REIT) industry are examples that have gone from fairly predictable scenarios to areas that have been completely upended.

As a result of the coronavirus, many global employers are debating the need to have their employees work in large offices at all. Barclays’ CEO told CNBC that “crowded corporate offices with thousands of employees may be a thing of the past.” Along with Barclays, Mondelēz, Nationwide, and Twitter are talking about a “permanent shift to work from home and reduced office space.” The reasons range from safety to insurance to cost savings. In fact, a Reuters analysis of “quarterly earnings calls over the past week (week of July 15, 2020) revealed that more than 25 large companies plan to reduce their office space in the year ahead, a move designed to reduce the second-largest expense after payrolls.”

A typical REIT company normally holds millions or billions of dollars in assets in office space. They should have a good understanding of which leases are coming up for renewal or expiration, and which buildings will have extra capacity. They look long-term to fill space and maximize revenue opportunities.

Suddenly, as a result of COVID-19, REITs are faced with tenants who are viewing their office space commitments very differently. Many businesses, like retailers and restaurants, have been closed for months. Some are still closed. Some are re-opening slowly. Some face the prospect of future shut-downs. Businesses have asked landlords for rent concessions, and some U.S. cities and states have issued guidelines supporting rent concessions. Regardless of the reason, tenants are now asking for lease modification options. These include partial terminations and reductions in space.

It is possible to “model” real estate assets and leases on spreadsheets, but it is simply not possible to manage this level of complexity, and do so in near real time, with a spreadsheet. In order to truly understand the total impact of rent concessions and lease modifications across multiple buildings, in different states, throughout the nation, a real estate holding company or a REIT requires sophisticated planning software. These firms must be able to do “what-if” scenario modeling. They need to have a clear picture of capacity, in order to move tenants or divest of assets, if needed. They require a solution that is agile, flexible and dynamic.

It’s hard to predict what will happen over the next few months or even the next year, but it’s clear that the real estate industry will see lots of change, fluctuation in leases, and unpredictability.

Read more blog posts about the impact of COVID-19:

FP&A Done Right: The Office of Finance in the COVID-19 Economy

FP&A Done Right: FP&A Tips for Scenario Modeling During COVID-19

FP&A Done Right: Reforecasting in a COVID-19 World – Best Practices You Can Implement Now

Home » Financial Performance Management » Page 20

Filed Under: News & Events Tagged With: Budgeting, Budgeting Planning & Forecasting, Financial Performance Management, FP&A, Planning & Forecasting, Planning & Reporting, real estate investment trust, REIT

  • « Go to Previous Page
  • Page 1
  • Interim pages omitted …
  • Page 18
  • Page 19
  • Page 20
  • Page 21
  • Page 22
  • 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.