• 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

Planning & Forecasting

IBM Planning Analytics Tips & Tricks: Excel MAXIFS and MINIFS

July 12, 2022 by Lee Lazarow Leave a Comment

Many of you know that Excel’s MAX function will define the largest value within a range. And many of you also know that Excel’s SUMIFS function will allow you to merge IF checks into your sum formulas. But did you know that Excel has a function called MAXIFS which merges these two concepts together?

The MAXIFS function is used to determine the largest number within a range that satisfies one or more conditions.

The syntax of the function is:

=MAXIFS (max_range, criteria_range1, criteria1 [,criteria_range2, criteria2] [..])

  • Max_range
    • This is required
    • This defines the range to search
  • Criteria_range1
    • This is required
    • This defines the range to perform the IF check
  • Criteria1
    • This is required
    • This defines the criteria of the IF check
  • Criteria_range2 and Criteria2
    • These are optional
    • These allow you to have multiple IF checks
    • You can have more than 2 criteria

The following example shows how to define the maximum value for Lee.  

Other iterations of this formula include MINIFS, AVERAGEIFS and COUNTIFS.

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: Unhide Multiple Excel Sheets

IBM Planning Analytics Tips & Tricks: Refresh PAW Visualizations Automatically

IBM Planning Analytics Tips & Tricks: Improve Workbook Performance

Home » Planning & Forecasting » Page 6

Filed Under: IBM Planning Analytics Tips & Tricks Tagged With: enterprise performance management, IBM Cognos TM1, IBM Planning Analytics, Planning & Forecasting, Planning Analytics Tips & Tricks, TM1

Workday Adaptive Planning Tips & Tricks: Loan Amortization

July 6, 2022 by Robert Nordhagen Leave a Comment

Loan amortization schedules in Workday Adaptive Planning are slightly different than those done in Excel.

In Excel the typical amortization schedule looks like this:

In Workday Adaptive Planning most versions only go 1-5 years into the future. Creating a complete 10-25 year amortization schedule is not the best practice. Here is an example of an Amortization Schedule in Adaptive:

In Adaptive we show inputs in rows 2-8. Rows 10 through 14 are the formulas that calculate the interest per period, the principle and the declining principal balance.  

Row 2: Input the initial loan balance for every month the loan will be active. If you are keying it in, as opposed to uploading a file from Excel, you can use Copy Forward rather than key it in every month.  

Row 3: Input Balance (if acquiring the loan). Instead of the initial balance, put the balance as of assumption date.

Row 4: Principal Payment. This is used for variable rate loans 

Row 5: The months will be the same just like the Initial Balance for every month that the loan is active.  

Row 6: Amort Month is a counter that increases by 1 each month until the loan matures, then the field should go blank. In most cases the version will max out before the loan matures.

Row 7: Interest Rate %. This will be the same every month for fixed rate loans. For variable rate, forecast the expected rate by month.

Row 8: Draw Down. This is for additional payments.  

The formula rows will calculate as follows:

Row 10: Beginning balance is equal to prior month ending balance.

Row 11: Total Payment. This is the most complicated formula and takes many scenarios into account using nested ifs. The basis of the formula is the payment formula; ie, Balance x i / ( (1+i) * (1- 1/( 1+I )^n ))

Row 12:  Interest Payment. This takes the Beginning Balance * the Interest rate (monthly rate: rate/12)

Row 13:  Principal Payment. This takes Total Payment – Interest Payment

Row 14:  Ending Balance. This takes the Beginning Balance – Principal Payment – Draw Down

Follow up to Amortization is Conversion to Straight Line

Previously, we showed how to do a loan amortization in Adaptive Planning. Now we will go to the next step: Straight-line the interest according to GAAP in certain situations. Below is a loan amortization that takes the loan payments to maturity. The interest payments are summed. That sum is then divided evenly among the payments and the amortization schedule is redone with constant interest every month as shown in the second schedule.

This is tricky in Adaptive Planning because a typical Excel schedule is run out to term since there are almost always sufficient columns in an Excel sheet to handle all the monthly payments. However, in Adaptive Planning, a typical version will be only 3 to 5 years into the future so only loans within 60 months of maturity could follow the same pattern. 

For any longer maturities we have to apply the following logic. For loans with a constant monthly payment (which is most loans), calculate the payment. Then multiply the payment by the number of payments such as $9541.10 * 120 months, which is equal to $1,144,932.00 (slightly different by $0.37 due to rounding). Subtract the initial balance $1,144,932 – $1,000,000 = $144,932 which is the total of the interest. Now the Interest Payment will be equal to the total interest divided by the number of payments as seen below.

Now the GL account for Interest Expense can be linked to SL_Interest_Pmt and the GAAP reporting of Straight Line interest will be in the P&L.

Visit Revelwood’s Knowledge Center for our Workday Adaptive Planning Tips & Tricks or sign up here to get our Workday Adaptive Planning Tips & Tricks delivered directly to your inbox. Not sure where to start with Workday Adaptive Planning? Our team here at Revelwood can help! Contact us info@revelwood.com for more information.

Read more Workday Adaptive Planning Tips & Tricks:

Workday Adaptive Planning Tips & Tricks: Save Personal Views on Sheets with Dashboard

Workday Adaptive Planning Tips & Tricks: Excel Substitute

Workday Adaptive Planning Tips & Tricks: Interactive Dashboards – Dynamic Planning with Embedded Sheets

Home » Planning & Forecasting » Page 6

Filed Under: Workday Adaptive Planning Tips & Tricks Tagged With: Adaptive Planning, Budgeting, enterprise performance management, Planning & Forecasting, Workday Adaptive Planning, Workday Adaptive Planning Tips & Tricks

Workday Adaptive Planning Tips & Tricks: Choose the Correct TIME Syntax

June 22, 2022 by Michelle Song Leave a Comment

Are you familiar with all the TIME syntax in Workday Adaptive Planning? Do you know what is the best practice for each of them? This blog post will tell you the difference between them. 

Below are the most common TIME syntax in Adaptive Planning. 

  • Month(this) 
  • Versionmonth(this) – returns the 
  • This.year.positionof(this.month)
  • This.version.positionof(this.month)

In the following example, this instance has a custom calendar which is from July – June. The example is created using Month as the stratum. The same logics are applied to Quarter and Year. 

Graphical user interface, application, table

Description automatically generated

  • In July 2021, Month(this) returns the month in the standard calendar, which is month 7. This syntax also assumes that July is from July 1st to July 31st. For example, if 7/30/2021 in a custom calendar is actually a date in Aug 2021, then versionmonth(July-2021) and versionmonth(Aug-2021) will return the same number. This same situation also applies to Versionmonth(this).
Graphical user interface, application, table

Description automatically generated
  • Versionmonth(this) returns the month of the version, which also follows the standard calendar and assumes July is from July 1st to July 31st. 
Graphical user interface, table

Description automatically generated
  • This.year.positionof(this.month) returns the fiscal month of the year, which is month 1 for July-2021. This syntax references the custom calendar. For example, if 7/30/2021 in a custom calendar is actually a date in Aug 2021, then This.year.positionof(this.month) returns month 2 in the year, which is Aug 2021. Same situation applies to This.version.positionof(this.month). 
Graphical user interface, text, application

Description automatically generated
  • This.version.positionof(this.month) returns the month in the version since the Start of Version. In this case, the Start of Version is July 2021, therefore it is month 1 in the version. 

Other use cases and helpful formulas related to time. 

Personnel Sheet:

  • For Headcount calculation that has a Custom Calendar and Start Date before the system date
    • this.Year.positionof(this.Month)  – correct result, but shown as RED (error) on Income Statement because the date is outside of the system date. 
    • versionmonth(this) – might result in incorrect result due to date overlaps in two months. 
    • Use iff(ROW.PartialHeadcount>0, 1,0) as a workaround. 
  • Cumulative Salary
    • Standard calendar: 

iff(month(this)>1, ROW.Salary+ROW.CumulativeSalary[time=this-1], ROW.Salary)

  • Customized calendar:

iff(this.Year.positionof(this.Month)>1,ROW.Salary+ROW.CumulativeSalary[time=this-1], ROW.Salary)

Visit Revelwood’s Knowledge Center for our Workday Adaptive Planning Tips & Tricks or sign up here to get our Workday Adaptive Planning Tips & Tricks delivered directly to your inbox. Not sure where to start with Workday Adaptive Planning? Our team here at Revelwood can help! Contact us info@revelwood.com for more information.

Read more Workday Adaptive Planning Tips & Tricks:

Workday Adaptive Planning Tips & Tricks: Flexible Planning

Workday Adaptive Planning Tips & Tricks: Common Questions Asked During Training

Workday Adaptive Planning Tips & Tricks: Where Did My Parameters Go?

Home » Planning & Forecasting » Page 6

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

IBM Planning Analytics Tips & Tricks: PAW Chart Multicolors

June 14, 2022 by Revelwood Leave a Comment

One of the visualizations in Planning Analytics is a column chart. This type of chart is a good way to compare items since all the lines are in proportion to each other.

An easy way to create a column chart is to simply create an exploration and change the visualization into a column chart. Here is an example of a stacked exploration that compares companies by scenarios and the related column chart:

Chart, histogram

Description automatically generated

This chart is great since it’s easy to compare the high and low values. However, it’s very hard to differentiate the sub-categories since all columns are the same color. In this case, it’s hard to compare Actuals vs. Final Budget.

You can configure your chart to use multiple colors via the following steps:

  1. While in Edit mode, single click on your chart widget.
  1. Select the option for “Fields” at the top, right corner. Not all visualizations use fields, so this may appear blank if you have not yet converted your widget to a chart.
  1. Move the applicable dimension from the Length category into the Color category. In my example, color is associated with the scenario dimension.
Graphical user interface, text, application, chat or text message

Description automatically generated

Once moved, the same chart will look like this:

Chart, bar chart

Description automatically generated

This approach will allow you to use your color palettes (defined within the properties) to differentiate the dimensions within your stacked column chart and make your analyses easier.

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: PAW Visualization Value Labels

IBM Planning Analytics Tips & Tricks: Refresh PAW Visualizations Automatically

IBM Planning Analytics Tips & Tricks: PAW Maps

Home » Planning & Forecasting » Page 6

Filed Under: IBM Planning Analytics Tips & Tricks Tagged With: enterprise performance management, Excel functions, Financial Performance Management, IBM Cognos TM1, IBM Planning Analytics, Planning & Forecasting, Planning Analytics Tips & Tricks, TM1

Workday Adaptive Planning Tips & Tricks: Revenue Cohort Modeling

June 8, 2022 by Ailenette Cruz Leave a Comment

Tips & Tricks

Do you know about cohort modeling in Workday Adaptive Planning?

A cohort model provides meaningful insight of data grouped into subsets based on any characteristic important to the company. The groups are called “cohorts.” Cohorts can be based on time (i.e. season, monthly, yearly), segment (i.e. commercial, residential), or size (i.e. low, medium, high), just to name a few. Cohorts follow a pattern of behavior that helps analysts project future trends. This can help companies focus efforts on lowering churn and optimizing revenue.

Cohort model vs. Regular model

Compared to a regular model, a cohort model provides a more granular view of the data. Projecting revenue at the cohort level helps companies understand outliers that would otherwise be missed in a regular revenue model.

For example, in a regular model, projected revenue shows overall revenue for the year and may show growth. However, if you dig further into the segments, you will see that one cohort, such as small businesses in the manufacturing industry, had a large decline in sales.

If this information was available early in the year, further decline could have been prevented and management could have strategized to avoid a blow to the bottom line in the following year. Maintaining and analyzing multiple cohort models on a regular basis is crucial for successful strategic planning.

Where to use cohort modeling

  • Subscription base revenue – tech, gaming, food, streaming, service, etc.
  • Contract billing – by milestone, period, ASC 606 amortization, etc
  • Seasonality base revenue
  • Freemium – lead conversion
  • Sales Rep capacity or conversion

How to build cohort models in Workday Adaptive Planning

Cohort model in Adaptive may comprise of multiple sheets. Below is an example of a cohort model structure.

  1. 1. Planned # of Customers/Cohort
  • Modeled sheet
  • Create number data entry column to input number of customers
  • Create calculated account and link the data entry column
  • Input by cohort dimension – this can be by month/period, type of cohort, etc (ex. Jan, Feb, Mar – the month new customers are acquired)
  • No timespan

Table

Description automatically generated

  1. 2. Cohort Drivers/Curves 
  • Modeled sheet
  • Create number data entry columns, display as % (ex. 12 columns representing 12 months of the year) – this is where to input cascading percentages (aka curve)
  • Create calculated accounts for each data entry column and link
  • No timespan

Application, table

Description automatically generated with medium confidence

  1. 3. Revenue per product/customer by month
  • Modeled Sheet
    • With timespan Graphical user interface, application, table

Description automatically generated
  1. 4. Cohort Waterfall
  • Cube sheet
  • Create standard account as a trigger – in this case using active month designation
    • The active month designation to trigger what month the cohort waterfall calculates for each acquisition month
  • Create calculated account with formula using iff and switch (this serves as an index match)

iff(isblank(ACCT.Cohort_Waterfall.Cohort_ActiveMonths),blank(),

iff(this.version.isactuals,blank(),

ACCT.NewCustomers_byCohort.No_Customers[Sales Region=this, Sales Channel=this, Order Type=this, Products=this, Cohort Acquisition Month=this]

*

switch(ACCT.Cohort_Waterfall.Cohort_ActiveMonths,

1,ACCT.Cohort_Drivers.M1[Sales Region=this, Sales Channel=this, Order Type=this, Products=this],

2,ACCT.Cohort_Drivers.M2[Sales Region=this, Sales Channel=this, Order Type=this, Products=this],

3,ACCT.Cohort_Drivers.M3[Sales Region=this, Sales Channel=this, Order Type=this, Products=this],

4,ACCT.Cohort_Drivers.M4[Sales Region=this, Sales Channel=this, Order Type=this, Products=this],

5,ACCT.Cohort_Drivers.M5[Sales Region=this, Sales Channel=this, Order Type=this, Products=this],

6,ACCT.Cohort_Drivers.M6[Sales Region=this, Sales Channel=this, Order Type=this, Products=this],

7,ACCT.Cohort_Drivers.M7[Sales Region=this, Sales Channel=this, Order Type=this, Products=this],

8,ACCT.Cohort_Drivers.M8[Sales Region=this, Sales Channel=this, Order Type=this, Products=this],

9,ACCT.Cohort_Drivers.M9[Sales Region=this, Sales Channel=this, Order Type=this, Products=this],

10,ACCT.Cohort_Drivers.M10[Sales Region=this, Sales Channel=this, Order Type=this, Products=this],

11,ACCT.Cohort_Drivers.M11[Sales Region=this, Sales Channel=this, Order Type=this, Products=this],

12,ACCT.Cohort_Drivers.M12[Sales Region=this, Sales Channel=this, Order Type=this, Products=this],

0)))

Cohort modeling is a powerful feature in Workday Adaptive Planning. Try it out and see what insights you can discover.

Graphical user interface, application, table, Excel

Description automatically generated

Table

Description automatically generated

Visit Revelwood’s Knowledge Center for our Workday Adaptive Planning Tips & Tricks or sign up here to get our Workday Adaptive Planning Tips & Tricks delivered directly to your inbox. Not sure where to start with Workday Adaptive Planning? Our team here at Revelwood can help! Contact us info@revelwood.com for more information.

Read more Workday Adaptive Planning Tips & Tricks:

Workday Adaptive Planning Tips & Tricks: Check Boxes in Modeled Sheets

Workday Adaptive Planning Tips & Tricks: Excel Reporting Using a Report Template

Workday Adaptive Planning Tips & Tricks: Expand/Collapse Feature in OfficeConnect

Home » Planning & Forecasting » Page 6

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

FP&A Done Right: Is Your Planning Process Hindering Decision Making?

June 18, 2021 by Revelwood Leave a Comment

This is a guest blog post from our partner Workday Adaptive Planning, explaining how and why you should foster a culture of planning.

Long planning cycles. Short-lived plans. Siloed efforts. Hard-to-find errors. And never enough time for strategic analyses.

Do these FP&A issues ring a bell?

They should, if your planning processes are largely manual and mostly spreadsheet based, and don’t lend themselves to collaboration or version control.

An over-reliance on spreadsheets and legacy on-premises applications constrains the organization with rigid, siloed planning. These legacy planning environments are inflexible and brittle, prevent collaboration, and fail to deliver insights that drive decision-making.

Often, finance leaders are not even aware of how manual processes such as the gathering and consolidating of data, cumbersome email-based communication, and complex report creation put a strain on finance resources—a strain that keeps the finance team locked in low-value tasks. And while markets, revenue targets, and costs constantly move, old-world planning processes hinder related planning and reporting and slows decision-making to a crawl. Leaders either don’t have numbers they trust or don’t have the insights needed for agile decision-making.

Create value in all corners of the organization

Opportunities to grow are exceedingly challenging in a highly competitive and increasingly global environment. CFO research surveys typically characterize their corporate innovation efforts as highly successful. The success rate is low because getting the people, processes, and data all moving in the same direction can be difficult. To create value in all corners of the organization—sales, marketing, operations, and HR—everyone needs to fully engage with the planning process.

A siloed, spreadsheet-based approach leaves operational leaders in the dark and keeps business planning out of sight. Stakeholders don’t know where they are falling short; they can’t manage what they can’t see. While traditional planning functions on a rigid schedule (e.g., monthly), business operations are incredibly fluid. No business leader should be forced to wait until the month-end report is generated to make a decision. A finance team’s inability to provide insights in a timely manner hampers decision-making across the organization.

It’s no wonder that forward-thinking organizations are opening their eyes to a more effective and efficient way to plan—modern planning. Companies that adopt a modern planning process are better prepared to identify and take advantage of growth opportunities and operate more efficiently. Modern planning is collaborative, so you can plan as a team, and it’s continuous, so you can rapidly adapt to change.

Fostering a culture of planning

Instead of complex legacy applications and hordes of spreadsheets strewn across the organization, competitive organizations leverage cloud-based planning solutions to respond proactively to an ever-changing marketplace. Enterprise performance management solutions that integrate planning with source ERP, CRM, HR, and payroll systems offer a single version of the truth that fosters a culture of planning built on trust and real-time data.

Forward-thinking finance organizations recognize that planning will no longer suffice in a real-time, data-centric environment. The days of building elaborate spreadsheets to forecast the business trajectory—only to put them away until the next planning cycle—are fading quickly, at least at companies that want to remain competitive. A new modern planning model is emerging, centered around cloud-based tools to build accurate planning models faster, reduce errors, foster collaboration, and drive better decision-making. As stakeholders are more involved in the planning process, they’re gaining greater trust in the data. Leading finance organizations are using modern planning to:

  • Free up finance time and capacity
  • Improve the accuracy and integrity of finance and accounting data, plans, and reports
  • Accelerate cycle times for critical finance processes like month-end close, operational reporting, planning, and what-if analysis
  • Enhance collaboration with business stakeholders

In short, these finance organizations are leading with insights to drive business decisions and, in the process, elevating the role of finance to be more strategic.

Change starts at the top

Modern planning requires a cultural shift, but the rewards make it worth the effort. It can be difficult to get people to move from the comfort of their familiar spreadsheets to cloud-based collaborative planning tools, and the change has to start at the top.

The key to successfully transitioning to a modern planning model is thoughtful change management, wherein all parties understand the value of centralized planning tools and how they can contribute. When everyone takes ownership and knows how they are expected to add value, innovative planning, analytics, and performance measurement engage more people—including sales, marketing, operations, and HR—in the process of planning, moving away from the old, static models of the past.

The true payoff of modern planning is realized when everyone is working together on a continuously updated plan that incorporates fresh, valuable, and trusted data.

Tomorrow’s winners will be the most agile

In summary, modern planning means business agility. And business agility means organizations like yours can think fast, move first, and change rapidly, while maintaining control and stability. It means you can understand not only what’s going on but also how you could respond and what effect your actions would have.

It enables you to meaningfully digest the new volume, variety, and velocity of data by capturing it all in a single, intuitive, integrated environment, and surfacing the critical information you need to make decisions.

It brings your whole business together by broadening participation in planning and strategy to improve both day-to-day operations and your understanding of the overall dynamics of your business.

It’s continuous and company-wide, supported by a platform that’s easy-to-use, fast, and powerful. That makes it easier to model complex scenarios, link together operational and financial plans, monitor executional results, analyze past and current performance, and drill down into (or roll-up) fine-grain reporting from any area of the business.

The world isn’t going to slow down, and markets aren’t going to get less competitive. In the long-term (and probably before then) business agility isn’t going to be just a nice-to- have, or even a significant differentiator.

It’s going to be the deciding factor between the businesses that survive, and the businesses that wish they had.

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

Home » Planning & Forecasting » Page 6

Filed Under: FP&A Done Right Tagged With: FP&A done right, Office of Finance, Planning & Forecasting, Planning & Reporting, xP&A

FP&A Done Right: Collaborate More When Planning

March 12, 2021 by Revelwood Leave a Comment

FP&A Done Right: Collaborate More When Planning

This is a guest blog post from our partner Workday Adaptive Planning, recommending how to get other departments to collaborate with the Office of Finance.  

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

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

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

But achieving a collaborative finance function can be difficult. That’s because FP&A often lacks the necessary time, direction, or clarity around KPIs to build the cross-functional relationships required to improve forecasting and reporting. So what should be a team effort becomes a finance exercise, and when numbers change, it becomes finance’s fault. In the end, we lose credibility as a business partner.

Make Your Data Everyone’s Data

So how do you get other departments to collaborate with finance? Start by empowering your business partners with more ownership and accountability in the data and your process. For example, many businesses still do most of their forecasting and planning with spreadsheets. Not only is this wildly inefficient (not to mention more likely to include errors), but it keeps all the information bottled up on one person’s screen until they’re ready to share.

We all have seen an Excel spreadsheet named finalV2 or Final V3, only to find out our business partners are using FinalV6. This is a leading cause of number mismatch. Using modern finance tools, a finance team can collect and report on the numbers without needing to send and receive Excel spreadsheets. Everyone is on the same version and making the changes together. This just makes the business partners a part of the overall process, not part of the problem.

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

A Strategic Bonus to Collaborative Finance

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

The bottom line: Financial collaboration becomes easier when you stop relying on static spreadsheets. It starts with getting the entire team working with one, trusted set of numbers, and building on a foundation of accurate, up to date data.

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

Check out more FP&A Done Right posts here:

FP&A Done Right: Five Tips for Budgeting in the Age of COVID

FP&A Done Right: To Recover from Economic Shock, Are CFOs Envisioning Enough Scenarios?

FP&A Done Right: Three Driver-based Budgeting Tips for CFOs when Change is Imminent

Home » Planning & Forecasting » Page 6

Filed Under: FP&A Done Right Tagged With: Adaptive Insights, Budgeting Planning & Forecasting, enterprise performance management, FP&A, FP&A done right, Planning & Forecasting, Planning & Reporting

IBM Planning Analytics Tips & Tricks: Planning Analytics Forecasting – Setting up the Forecast

March 9, 2021 by Nina Inverso Leave a Comment

This is part three in a three-part series on IBM Planning Analytics’ new feature, Forecasting. 

In our previous blog about IBM Planning Analytics’ new Forecasting feature, we reviewed the steps required to preview your forecast. Once previewed, you can then run your Forecast.

  1. Open a Planning Analytics Workspace (PAW) book and add a new cube view. Setting up the forecast in IBM Planning Analytics Forecasting
  2. Place the time dimension’s flat hierarchy alone on the columns. As of PAW version 2.0.60, you will no longer be required to display the entire hierarchy on the view. Instead, you will have the option to select the scope of the historical data used in the forecast.
  3. Select the context and row elements to forecast. For example:
    • Drag the account dimension on top of the source dimension to swap their positions.
    • Click on the version dimension to select a different version of the data from the drop-down list.
    • Double-click on the account dimension to select the row elements. Setting up the forecast in IBM Planning Analytics Forecasting

Your PAW cube view is now ready as a Planning Analytics Forecasting model.

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: Planning Analytics Forecasting – Configuring the Time Dimension

IBM Planning Analytics Tips & Tricks: Planning Analytics Forecasting – Configuring the Forecast Settings

IBM Planning Analytics Tips & Tricks: Planning Analytics Forecasting – Previewing the Forecast

Home » Planning & Forecasting » Page 6

Filed Under: IBM Planning Analytics Tips & Tricks Tagged With: Budgeting Planning & Forecasting, enterprise performance management, Financial Performance Management, IBM Cognos TM1, IBM Planning Analytics, IBM Planning Analytics Forecasting, Planning & Forecasting, Planning Analytics tips, Planning Analytics Tips & Tricks, Revelwood, setting up forecast + Planning Analytics, TM1

IBM Planning Analytics Tips & Tricks: Planning Analytics Forecasting – Previewing the Forecast

March 2, 2021 by Nina Inverso Leave a Comment

This is part two of a three-part series on IBM Planning Analytics new Forecasting feature. 

In our first blog about Planning Analytics’ new Forecasting feature, we reviewed the steps required to configure your forecast. Once configured, you can then preview your forecast before to get a better idea of the results prior to populating the cube.

  1. Open the PAW book that contains your forecast view. Previewing the forecast in IBM Planning Analytics
  2. Click anywhere on the view to activate it. Then click the Forecast icon in the ribbon at the top of the screen. This will open the Forecast window on the right-hand side of your screen. Configure the forecast settings if you have not already done so. Previewing the forecast in IBM Planning Analytics
  3. Click on one of the elements in your row dimension to select the row. Then click the Preview button in the Forecast window on the right-hand side of your screen. Previewing the forecast in IBM Planning Analytics
  4. The Forecast preview window will open. There are two tabs with information about the forecast:

a. Preview chart

Previewing the forecast in IBM Planning Analytics

The Preview chart depicts displays the forecasted data, along with a surrounding shaded area. There is a 95% chance that the actual values will fall in this shaded area (or cloud).

b. Statistical details

Previewing the forecast in IBM Planning Analytics

The Statistical details tab provides key information used by the model to forecast your data. Read more about these values here.

In our next blog post, we will review how to run your Planning Analytics Forecasting model.

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: Configuring the Time Dimension

IBM Planning Analytics Tips & Tricks: Configuring the Forecast Settings

IBM Planning Analytics Tips & Tricks: Convert Existing View Directly to Reports

Home » Planning & Forecasting » Page 6

Filed Under: IBM Planning Analytics Tips & Tricks Tagged With: Budgeting Planning & Forecasting, enterprise performance management, Financial Performance Management, IBM Cognos TM1, IBM Planning Analytics, IBM Planning Analytics Forecasting, Planning & Forecasting, Planning Analytics tips, Planning Analytics Tips & Tricks, TM1

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