• Skip to main content
  • Skip to footer
Revelwood Logo

Revelwood

Your SUPER-powered WP Engine Site

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

Financial Performance Management

IBM Planning Analytics Tips & Tricks: Filtering in IBM Planning Analytics Editor

November 8, 2022 by Revelwood

Did you know there are different approaches to filtering elements when defining a subset in the IBM Planning Analytics editor? Lee Lazarow, Revelwood’s FP&A technology director and IBM Planning Analytics practice leader, demonstrates some ways to filter elements in our latest IBM Planning Analytics Tips & Tricks video.

Watch the video and you’ll learn how to:

  • Filter dimensions
  • Use descriptors such as “contains,” “equal,” and “start,” eliminating the need to use *ZYX
  • Filter elements
  • Reset filters
  • Add a second filter

Revelwood has worked with IBM Planning Analytics / TM1 for more than 27 years. We’ve partnered with hundreds of companies on the design, development, maintenance and updates of IBM Planning Analytics applications, across every industry. Have a challenge with Planning Analytics / TM1? We can help you!

Watch more IBM Planning Analytics Tips & Tricks Videos:

IBM Planning Analytics Tips & Tricks: Global Settings in Overview Area of Exploration

IBM Planning Analytics Tips & Tricks: Add Color to Multidimensional PAW Charts

IBM Planning Analytics Tips & Tricks: Shortcuts in PAW Models

Home » Financial Performance Management » Page 8

Filed Under: IBM Planning Analytics Tips & Tricks Tagged With: filter + planning analytics, Financial Performance Management, TM1

Modern Accounting: Does Your Accounting Team Have SMART Goals?

November 3, 2022 by Revelwood

This is a guest post from our partner BlackLine, explaining SMART goals and how they can help accounting managers.

One of the most widely used—and effective—approaches to goal setting is called SMART, which stands for Specific, Measurable, Attainable, Relevant, and Time-Bound. This helps you and your teams create clear goals with defined and attainable objectives.

Many accounting managers struggle with the annual goal-setting process. It can be hard to quantify the work of the folks who do the counting—which is ironic, but quite common outside of sales teams. Accountant routines can vary significantly and tend to be driven by outside factors.

But setting smart goals for accountants is a critical part of ensuring a successful year. They help you and your teams be intentional about what you want to focus on and accomplish and create alignment across the entire F&A organization.

How to Write SMART Goals for Accountants

Make Your Goals Specific

The more specific a goal is, the more attainable it will seem, and the more likely you’ll achieve it because you’ll know exactly what you need to accomplish in this area.

It’s okay to start with a larger goal, but then break it down into smaller goals that are more specific. Determine why this goal is important—for the individual, the team, and the broader F&A organization—and then talk about the short and long-term impact of achieving it.

To get even more specific, determine the exact outcome you want.

Make Your Goals Measurable & Attainable

Next, quantify your goals so you’ll know how to measure process and when they’ve been accomplished. This is often the most difficult part of setting SMART goals for accountants, and if a goal doesn’t seem quantifiable, try rephrasing it so it’s possible to measure.

It’s equally important to ensure the goal is attainable. Stretch goals are great, but impossible goals will only lead to overwhelm and frustration. Make sure the time frame is reasonable and identify anything that could get in the way of achieving the goal.

Removing those barriers should be the first step.

Make Your Goals Relevant & Time-Bound

Every goal must have importance to the broader organization as well as the individual. Uncover the why here, so the reason this is a priority is clear. This can also increase the individual or team’s motivation to achieve this goal.

Creating a reasonable deadline for each goal is also critical, along with regular check-ins to ensure you’re on track. It’s okay to have some flexibility in adjusting this deadline as needed, especially if things come up and get in the way.

This is, however, why it’s so important to identify and remove those barriers as the first steps toward the goal.

Strategies for Effective Goal Setting

Here are three strategies to incorporate into your goal-setting process that will make your accounting and finance teams far more effective in the future.

Take a Project-Based Approach

Most of us have down time here and there that we could utilize to work on a project. Talk to each of your team members about coming up with a project that contributes to their own development, helps them connect with others, and causes them to look at their job in a new way.

For example, a Senior Staff Accountant could conduct a skills training to help accountants keep up with changes in the industry. Or, maybe you believe your AR team could be more efficient but you’re not sure. Why not give them a goal to identify areas they can improve? You may be surprised at how many great ideas surface that could save the team some time.

Create Opportunities to Strategically Develop New Skills

With the rise of new tech like robotic process automation, artificial intelligence, and blockchain, strategically developing skills to prepare for the future of finance is more essential than ever.

The exceptional accountant of tomorrow needs to begin cultivating effective communication abilities, data analysis, business acumen, and creativity — today. These capabilities will equip teams to deliver predictive insights for leadership, drive data-based decisions, and provide expert counsel.

Developing opportunities for accounting and finance professionals to problem-solve more creatively, learn new technology, and build relationships with other departments can make a massive difference on an individual and team level.

Carefully Craft Your Culture

A carefully crafted culture creates competitive advantage. It improves quality of work, boosts productivity, engagement, and retention, and reduces stress and healthcare costs.

But if this isn’t a current focus at your company, where do you even start?

A team brainstorming session can be an excellent first step. Involving your people in culture discussions can make them feel invested and as important as they really are. They’re also the ones who will be able to quickly identify what needs to change, along with the most effective approaches.

Give your leaders the responsibility of planning regular team-building events. This can be anything from fun, off-site events to a team appreciation lunch at the office. The goal should always be to bring the team closer and help them maintain better relationships, generating understanding and a deeper respect for each other.

Put Your People First

Done right, setting smart goals for your accountants can create a shared vision that makes your teams feel inspired and connected. And when the strategies within that vision meaningfully contribute to the entire organization, you can count on a higher level of buy-in.

It all comes down to putting your people first and setting them up for success. If you continually look to the future of finance and equip your teams for the new digital landscape, your F&A organization will thrive.

Creating smart goals and creating a great culture can help F&A teams retain top talent, which is a challenge in today’s business environment.

This blog post was originally published on the BlackLine blog.

Read more about Modern Accounting:

Modern Accounting: Streamlining the Month-End Close

Modern Accounting: The Impact of Investing in Accounts Receivable

Modern Accounting: Driving Sustainability

Home » Financial Performance Management » Page 8

Filed Under: Financial Close & Consolidation Tagged With: BlackLine, Budgeting Planning & Forecasting, Financial Performance Management, modern accounting

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

October 25, 2022 by Lee Lazarow

IBM Planning Analytics Workspace (PAW) allows you to easily create buttons that can be used for navigation and to run TurboIntegrator (TI) scripts. This is done by dragging the Action Button widget onto the sheet.

By default, the button appears as a rectangle.  

Shape

Description automatically generated

You can make the button more rounded by using the property called “Corner Radius” (within the area called General, Appearance).  Here is the same button with a corner radius setting of 90:

Shape, rectangle

Description automatically generated

You can also update the height of the button to make it appear even more rounded:

Shape, circle

Description automatically generated

From there, you can further customize the formatting associated with colors, fonts, and text size.

This property will allow you to define various ways to incorporate simple “press this button to…” approaches within your PAW books.

Revelwood has worked with IBM Planning Analytics / TM1 for more than 27 years. We’ve partnered with hundreds of companies on the design, development, maintenance and updates of IBM Planning Analytics applications, across every industry. Have a challenge with Planning Analytics / TM1? We can help you!

Read more IBM Planning Analytics Tips & Tricks:

IBM Planning Analytics Tips & Tricks: Working with Two Time Zones in Google Calendar

IBM Planning Analytics Tips & Tricks: New Filter Option in Set Editor

IBM Planning Analytics Tips & Tricks: 21/21/21

Home » Financial Performance Management » Page 8

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

Three Reasons You Need IBM Planning Analytics / TM1 Training

October 21, 2022 by Revelwood

Whether you are new to IBM Planning Analytics / TM1 or you consider yourself an all-star, you could still benefit from training. Over our 27+ years of designing, implementing and maintaining IBM Planning Analytics / TM1 applications and environments, we’ve found there are three primary reasons for investing in training. 

1. Staff Turnover in the Office of Finance

According to Gartner, the U.S. total annual turnover rate will jump by nearly 20% from the pre-pandemic average. Maybe your Planning Analytics administrator left your organization. Maybe your organization is growing rapidly and needs to add more TM1 developers and administrators. Regardless of the reasons, training is a smart move when you have new team members joining the organization or taking on new roles in your company.

People often give their employers two weeks’ notice that they are leaving their job. That does not leave enough time for a company to hire a new employee for the position. Even if you are temporarily assigning the role to a current employee, two weeks is still not enough time to get up and running on your Planning Analytics / TM1 implementation. 

There’s also an additional complication – how accurate and up-to-date is your Planning Analytics documentation? Old and out-of-date documentation makes it even more difficult for new TM1 administrators and developers to get up to speed. 

2. Expanding use of Planning Analytics / TM1 to Extended Planning & Analysis (xP&A)

xP&A is an enterprise planning strategy that combines and extends financial and operational planning. Gartner describes it as “taking the F out of FP&A).” xP&A offers “cross-organization leaders an ‘extended,’ holistic view of their company’s operations so that they can pivot the business with greater agility and more rapidly model future business scenarios.” [Gartner].

This can mean using IBM Planning Analytics / TM1 for:

  • Human resources
  • Sales
  • Marketing
  • Operations
  • Supply Chain
  • IT
  • Research and development

There are many benefits to xP&A. The business unit leaders in these functional areas may not be the Excel experts that the Office of Finance are. Before rolling out Planning Analytics applications to other areas, you should make sure new developers and end users receive training. It will make a significant positive impact on your roll out and eventual user adoption and satisfaction. 

3. Upgrading from TM1 to Planning Analytics

Migrating from TM1 to Planning Analytics is a big opportunity to modernize your planning environment. It’s not just a standard update or migration. You’ll learn a new, rich data exploration and visualization experience in Planning Analytics Workspace. You’ll have a new Excel add-in, Planning Analytics for Excel (PAx). And you’ll leverage hierarchies – the ability to turn attributes into dimensions for faster and more flexible data analysis.

Migrating to Planning Analytics requires training. Planning Analytics is powered by TM1 but delivers a whole new environment for your planning activities.

Revelwood’s Planning Analytics / TM1 Training Options

Revelwood has offered TM1 and Planning Analytics training for decades. We’ve refined our approach, expanded our best practices, and have the answers to all your TM1 and Planning Analytics questions. 

We offer several options for training, including: 

  • IBM Planning Analytics Fundamentals
  • IBM Planning Analytics Custom Report Building
  • Personalized Training Courses, working with your data and environment. Example courses include:
    • IBM Planning Analytics / TM1 Administrator Training
    • IBM Planning Analytics / TM1 Developer Training
    • TM1 10.2.2 and earlier versions User Training
    • Customized IBM Planning Analytics User Fundamentals Training
    • Customized IBM Planning Analytics Custom Report Building Training

All training options are virtual, enabling your team members worldwide to participate in training. Take advantage of our Planning Analytics experts! Contact us about training options.

Home » Financial Performance Management » Page 8

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

The Cost of Spreadsheet Errors

October 20, 2022 by Revelwood

News & Events

Using disconnected spreadsheets for forecasting, budgeting, planning and reporting creates a host of issues, including:

  • Wasting weeks every year manually consolidating a mass of individual spreadsheets
  • Inability to easily model potential future scenarios or answer what-if questions
  • Measuring actual spend against plan is a major chore
  • Talented finance staff spends too much time on low-level, non-value add activities.

These challenges are ongoing and exponential. The longer you rely on spreadsheets for “collaborative” planning, the higher the costs are. Most of these costs are “soft” costs – time, manpower, delays. But there are hard costs too – in the form of errors. Some of these errors might be small. Some might have a significant impact on your company. Here are a few examples:

Famous Spreadsheet Errors

J.P. Morgan’s “White Whale” debacle was a result of a spreadsheet user error. The firm was using Excel spreadsheets to model Value at Risk (VaR) for the Chief Investment Office. The model was built by copying and pasting data from one spreadsheet to another. Several cells in this model contained faulty equations due to a failed copy-and-paste process. This led the firm to severely underestimate the downside risk of one of its credit portfolios, which led to approximately $6.5 billion in losses and fines. 

The municipality of West Baraboo, Wisconsin, relied on spreadsheets to calculate how much its borrowing would cost. The spreadsheet had a sum that was missing one cell. This resulted in West Baraboo underestimating the total cost of a 10-year bond, meaning the village had to pay $400,000 more interest on the bond than it originally thought.

Lazard, Ltd. Is an investment bank that advised SolarCity Corp. The bank had a computational error in a spreadsheet. This error led Lazard to discount the value of SolarCity Corp by $400 million. This happened when Tesla Motors Inc. was purchasing SolarCity Corp.

When Vista Equity Partners purchased Tibco Software, Tibco shareholders received $100 million less than originally anticipated. This was a result of a spreadsheet error that overstated Tibco’s equity value.

The chances might be slim of your company suffering one of these financial disasters. But if you are still relying on spreadsheets for forecasting, budgeting, planning and reporting, you are likely to be experiencing one – if not many – of the nine circles of spreadsheet hell. 

What are they? Download this eBook, The Nine Circles of Spreadsheet Hell, to learn them – and the hidden costs of spreadsheets. 

Home » Financial Performance Management » Page 8

Filed Under: News & Events Tagged With: Financial Performance Management, Planning & Forecasting, Workday Adaptive Planning, Workday Adaptive Planning Tips & Tricks

IBM Planning Analytics Tips & Tricks: MDX Syntax Explained

October 18, 2022 by Lee Lazarow

MDX enables you to query dimensions and cubes, lists of elements, data points, calculations, and more. 

The first step in learning MDX is to understand the syntax. Below is an example of an MDX expression that returns all elements of the product dimension sorted in ascending order. To understand the expression, we’ve color-coded the syntax below. 

Part1, the part that is associated with the TM1 structure and model, is in green. This defines cubes, dimensions, hierarchies, elements and more. 

Part 2, in blue, is the MDX Function.

Part 3 is in red. These are known as curly brackets or braces. These convert the results of the MDX Expression into a set. 

The Expression below lets you list all elements of the product dimension and sort the list in ascending order:

Graphical user interface, text, application, email

Description automatically generated

Revelwood recently hosted a webinar on How to Use MDX in your IBM Planning Analytics Environment. Watch the recording to learn more about using MDX.

Interested in learning more about MDX? We have another MDX-specific webinar on Wednesday, November 9, 2022 at 1pm ET. Attendees will learn advanced MDX functions and see real-life examples of how Revelwood used MDX to address complex reporting requirements and to solve client challenges. 

Have a question about MDX? Register for our upcoming webinar or reach out to us at info@revelwood.com

Revelwood has worked with IBM Planning Analytics / TM1 for more than 27 years. We’ve partnered with hundreds of companies on the design, development, maintenance and updates of IBM Planning Analytics applications, across every industry. Have a challenge with Planning Analytics / TM1? We can help you!

Read more IBM Planning Analytics Tips & Tricks on MDX:

IBM Planning Analytics Tips & Tricks: An Approach to Strengthening your MDX Skills

IBM Planning Analytics Tips & Tricks: Making Default Cube Views Dynamic with MDX

IBM Planning Analytics Tips & Tricks: Dynamic Subsets Based on a Cube

Home » Financial Performance Management » Page 8

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

Modern Accounting: Streamlining the Month-End Close

October 13, 2022 by Revelwood

This is a guest post from our partner BlackLine, explaining how to streamline and optimize the month-end close procedss.

What Is the Month-End Close Process?

The month-end close process is the series of activities accounting teams must monitor, perform, and review, on a monthly basis, to produce timely, accurate, and complete financial statements and related reporting. While the most important closing period comes at the end of the financial year, most businesses use month-end procedures to accurately track performance—a monthly closing process as part of regular accounting ensures that the numbers are reliable, stable, and accurate.

Why Is Optimizing the Month-End Close Important?

Extra time spent on the month-end close means less time spent on adding value through analysis and business partnering. Optimizing the month-end close will get financial numbers into the hands of leadership sooner to assist with timely analyses and smarter decision-making. Other reasons to optimize include better discipline, more structure, improved controls, more visibility, and reduced risk.

Flowchart for Month-End Close Process

Here is a month-end close process flowchart to visualize some of the key steps and processes.

BlackLine month end flowchart

What Are Month-End Procedures?

While traditionally a lot of the heavy lifting is done during a few peak days, the month-end close process is ongoing throughout the month as transactions are recorded in various systems.

Before reporting, accounting must capture, review, and make adjustments to data from disparate sources, which often include a primary ERP, other ERPs, sub-ledgers, banks, point-of-sale systems, and many others. When results are solidified and reviewed, accounting then reports results to stakeholders including internal management, external shareholders, regulatory bodies, and others.

When accountants think about the month-end close, they’re likely referring to the activities in the middle of the figure above, like substantiating balance sheet accounts, reconciling transactions, recording recurring journal entries, analyzing variances, monitoring critical tasks and controls, and supporting audits. These are the processes that require the most effort. These activities are traditionally performed manually in spreadsheets and stored in difficult to access emails or on shared drives.

How Long Does a Month-End Close Take?

Each company is different, so it’s impossible to say how long your month-end close should take. Surveys and research over the years show the month-end process generally takes between 5-10 days.

However, over the past decade, with help from technology, the close has been getting faster. According to Ventana Research in 2019, “63% of participants indicated their organization completes its monthly close within six business days, up from 53% in 2014, with nearly half (46%) now closing within four business days (the previous rate was 29%).”

Accounting teams face a lot of pressure to close the books fast because executives use the previous month’s financials to make business decisions for the upcoming months and quarters. Ventana Research notes, “Closing faster has value: 62% of those that close within six days say that the information they provide is timely, while only 39% of those that take longer say that.”

However, closing faster can mean a tradeoff between speed and accuracy. For example, using estimates rather than actuals can shave hours or days off your close, but that means your numbers may not be exact, and when it’s time to close the fiscal year, the actuals will still need to be determined. This may end up adding days to your year-end close.

What Are the Steps in the Closing Process?

Again, because all companies are different, there is no perfect month-end close checklist. For example, businesses that sell physical products will have the extra steps of tracking inventory while companies that are service-focused will not. Smaller companies may have fewer accounts while multinationals will have hundreds or thousands. But there are some key items most accounting teams will need and steps they’ll need to follow.

Some of the information accounting teams need to have on hand in order to close the monthly books:

  • Total revenue numbers
  • Bank account information
  • Inventory levels (if applicable)
  • Petty cash total
  • Financial statements
  • Balance sheets
  • Total fixed assets
  • Income and expense accounts
  • General ledger

Common steps in closing the month-end books:

  • Record all incoming cash and accounts receivable
  • Review expenses and accounts payable records
  • Reconcile accounts
  • Review fixed assets
  • Inventory count (if necessary)
  • Collect and review financial documents
  • Prepare financial statements
  • Review all information for accuracy

Best Practices for a Month-End Close Process

When thinking about best practices for the month-end close, you may want to ask yourself these three questions about your month-end close process:

1.     Do I have sufficient visibility into the entire month-end close process?

2.     Have we done all we can to mitigate risk?

3.     Am I paying highly trained professionals to perform remedial tasks?

If you identify challenges based on those questions, you may want to implement some of these month-end close best practices.

Conduct Pre- and Post-close Team Meetings

During pre-close meetings, the team should discuss follow-up items from the previous month’s post-close meeting and determine the current month’s close schedule and timeline. This way everyone is clear on responsibilities and deadlines. You should also determine what staff should do if they run into barriers and how they should communicate any bottlenecks.

In post-close meetings, discuss what worked and what didn’t, and review assigned roles and responsibilities for the next month. Review any lessons learned, any variances or abnormalities, and entertain any proposed changes to the process.

Manage your Time, be Organized, and Communicate Efficiently

Understanding deadlines and schedules is critical so you can work toward an ideal close date. Being organized will help you stay on track. In addition, accountants must begin to cultivate strong written communication skills with the ability to think critically. They will also need strong oral communication skill and the ability to convey pertinent financial information to executive teams and stakeholders.

Build Relationships

Exceptional accountants know how to manage numbers and people. That requires cultivating a broader range of relationship skills today, such as how to work in a team and how to engage with other departments. If other departments are aware of what you are doing and what you’ll need for each month-end in advance, they may be more willing to contribute the financial data you need on time.

Take Advantage of Automation

Refocus your teams on analysis by replacing repetitive, spreadsheet-heavy work with leading-practice automation. Centralize data and close activities, automate journal entries and reconciliations, strengthen controls, and enhance visibility.

Common Challenges in a Month-End Close Process

Some challenges finance and accounting teams encounter when performing a manual close process include:

  • Team members don’t know what needs to be done and/or what is already completed
  • Inaccurate or incomplete data
  • Lack of standardization
  • Processes that are not clearly defined
  • Discrepancies between numbers
  • Delayed reconciliations due to errors, adjustments, and reclassifications
  • Lack of real-time data that results in little or no visibility and transparency

These challenges during the month-end close are likely why nearly 70% of CAOs recognize a need to change. The month-end close process relies on many people, technology, processes, and other inputs. As a result, accounting organizations are challenged by inconsistent data and processes and a lack of standardization across the enterprise—all while depending on spreadsheets, emails, phone calls, and in-person meetings to bring it all together.

As business leaders look for accounting to provide more real time insights, and while regulatory environments are increasingly complex, it becomes even more difficult for accounting to do it all on time without compromising compliance or control. Traditional manual accounting processes are simply not sustainable.

Transitioning away from manual workflows will give you access to one of the most efficient tools you’ll ever use: accounting automation.

How Financial Close Automation Technology Improves the Closing Process

In order to optimize the month-end close process, companies should embrace technology and innovation that enables transformation. Integrated solutions that address more than one aspect of the close process, and in particular, cloud solutions, are helping companies make the move to modern accounting—bit by bit. Let’s take a closer look at how automation technology improves the financial close process.

While there’s no one size fits all approach, many successful accounting organizations begin their optimization journey with close management by unifying data and processes and driving better accountability through visibility. Technology can be used to capture all tasks and embed workflow and segregation of duties. Leading solutions also help centralize supporting documents and provide dashboards for reporting on status and KPI’s.

Optimizing balance sheet substantiation and high-volume reconciliation processes is a natural next step, as preparing, reviewing, and retaining account reconciliations is a common pain point for accounting, and valuable resources spend a disproportionate amount of time on repetitive tasks like ticking and tying.

Technology not only standardizes account reconciliations using templates but improves continuity by embedding policies and procedures, reduces risk by importing general ledger account balances and other data directly from source systems, and drives efficiency by automating matching activities and up to 80% of certifications.

Another way to optimize the financial close is by addressing the journal entry process. Many organizations record hundreds, if not thousands of journal entries each month. Technology not only centralizes the journal entry process with workflow and integration to related balance sheet reconciliations but automates the creation, posting, and certification of a significant portion of a company’s entries. Harmonizing the process and supporting documentation in the cloud not only saves time during the close but also reduces audit testing and preparation.

Finally, intercompany accounting and governance is another area ripe for transformation, as it poses numerous challenges for accounting with complex regulatory requirements and cross-functional dependencies involving legal, tax, and other stakeholders. Accounting can use technology to proactively govern their intercompany process from transaction initiation through netting and settlement. End-to-end intercompany solutions facilitate the process with defined workflows, embedded controls, and automation.

This blog post was originally published on the BlackLine blog.

Read more about Modern Accounting:

Modern Accounting: The Impact of Investing in Accounts Receivable

Modern Accounting: Driving Sustainability

Modern Accounting: Why Does Intercompany Accounting Crash Your Close?


Home » Financial Performance Management » Page 8

Filed Under: Financial Close & Consolidation Tagged With: BlackLine, Financial Performance Management, FP&A, modern accounting, Planning & Forecasting

IBM Planning Analytics Tips & Tricks: Global Settings in Overview Area of Exploration

October 11, 2022 by Revelwood

Do you know how to define your global settings in the overview area of an IBM Planning Analytics Exploration? Revelwood’s FP&A Technology Director, Lee Lazarow, demonstrates how to manage and define these settings. 

Watch our latest IBM Planning Analytics Tips & Tricks video to learn:

  • Locate the gear icon in the overview area of your Exploration
  • Identify the four different global settings you can define
    • Hierarchy name – shows details about each dimension
    • Iconography – gives details about each one of the dimensions, similar to the legacy version of Subset Editor
    • Context information – provides details about the database, which database it is references, which cube it is referencing
    • Section headers – shows within the area what is the context, or what was previously called titles or picks.

When you define your global settings in IBM Planning Analytics, you create a better experience for your end users. It enables end users to determine what they are looking at and what they are navigating through.

Revelwood has worked with IBM Planning Analytics / TM1 for more than 27 years. We’ve partnered with hundreds of companies on the design, development, maintenance and updates of IBM Planning Analytics applications, across every industry. Have a challenge with Planning Analytics / TM1? We can help you!

Watch more IBM Planning Analytics Tips & Tricks Videos:

IBM Planning Analytics Tips & Tricks: Add Color to Multidimensional PAW Charts

IBM Planning Analytics Tips & Tricks: Shortcuts in PAW Models

Home » Financial Performance Management » Page 8

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

IBM Planning Analytics with Watson Named Value Index Leader by Ventana Research

October 7, 2022 by Revelwood

News & Events

Ventana Research has named IBM Planning Analytics with Watson a Value Index Leader in the firm’s Business Planning Value Index: 2022 Vendor and Product Assessment. The firm evaluated IBM Planning Analytics with Watson, along with planning products from Anaplan, Board International, Infor, insightsoftware, OneStream Software, Oracle, Planful (formerly Host Analytics), Prophix, SAP, Unit4, Vena Solutions, Wolters Kluwer and Workday.

IBM was categorized as an Exemplary Vendor, ranking first overall in the Value Index. Additional rankings by IBM Planning Analytics include:

  • Ranking second in Product Experience
  • Ranking Second in Customer Experience
  • Named as a Value Index Leader in TCO/ROI
Table

Description automatically generated

The purpose of the report is to “evaluate the maturity of software vendors and products and their value for enterprise use in business planning.” It is designed to provide a “balanced perspective of vendors and products that is rooted in an understanding of business drivers and needs.” Ventana uses research-based analytics and methodology to generate the Value Index ratings. The firm then “builds to a set of indicators it presents in both analytic and graphic form, each depicting the value of a specific vendor’s offering in terms of what it can deliver relevant to business planning needs.”

According to Ventana, “Technology is essential to making planning and budgeting more strategic, more strategic, more productive and more consequential to an organization’s success.”

Download your complimentary report!

Home » Financial Performance Management » Page 8

Filed Under: News & Events Tagged With: Financial Performance Management, IBM Cognos TM1, IBM Planning Analytics, Planning & Reporting, TM1

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