• 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

Revelwood

Webinar: How to Reforecast Effectively & Quickly in Uncertain Times

April 3, 2020 by Lisa Minneci Leave a Comment

News & Events

These are uncertain times. All but essential businesses in many parts of the U.S. are now working from home. Retail establishments have closed. Manufacturing plants are being re-worked to adapt from making car parts and sneakers to manufacturing Personal Protective Equipment (PPE). Some industries are booming. Some are busting. And most just don’t know what the future holds.

Unfortunately, from a financial standpoint or an operational standpoint, you can’t ignore the changes that are happening to your business. The question is: how easily can you adjust your forecast to reflect these changes?

Join us on Wednesday, April 8, 2020 at 4pm EDT for a live webinar on agile forecasting. Lee Lazarow, our FP&A Technology Director, will present examples of how our clients use IBM Planning Analytics for forecasting and what-if scenario planning. You’ll hear how:

  • A retailer/manufacturer used a percent approach to adjust numbers while dealing with a shut down in production
  • A financial services company, which uses driver-based planning, updated their plan by changing their starting assumptions
  • A medical not-for-profit created a new high-level, driver-based model to reflect decreased donations of supplies and money

Whether you are looking for a better planning solution, or if you are already an IBM Planning Analytics client, you will learn something from this webinar. Our goal is for you to come away with an understanding of different approaches for more nimble and efficient planning.

Register today!

Home » Revelwood » Page 6

Filed Under: News & Events Tagged With: Analytics, Budgeting, Budgeting Planning & Forecasting, Financial Performance Management, IBM Cognos TM1, IBM Planning Analytics, Planning & Forecasting, Planning & Reporting, planning analytics webinar, reforecasting, Revelwood, scenario planning, TM1, what-if planning, what-if scenarios

IBM Planning Analytics Tips & Tricks: Creating Multi-Level Dimensions

March 31, 2020 by Lisa Minneci Leave a Comment

Video

In today’s IBM Planning Analytics Tips & Tricks video, our FP&A Technology Director, Lee Lazarow, demonstrates how to create multi-level dimensions in Planning Analytics Workspace (PAW). This new feature allows you to build brand-new dimensions by simply dragging a file onto your screen.

Watch the video and you’ll learn:

  • How to take a multi-level file of cities and states in Notepad and drag it into PAW
  • How the leaf-level elements will be the specific cities
  • How the parent-level will be the states
  • How that rolls up to a grand total called Tri-State

From there, you then learn:

  • How to create a dimension
  • Name your dimension
  • How Planning Analytics has built-in logic to understand the levels of your file

This is just one of many new useful features in Planning Analytics.

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

Want to get our Planning Analytics Tips & Tricks delivered to your inbox every Tuesday? Sign up to get our weekly email of just the week’s tip! And don’t forget to subscribe to our YouTube channel for more Planning Analytics videos.

Watch more Planning Analytics Tips & Tricks videos:

IBM Planning Analytics Tips & Tricks Video: The Hold Feature

IBM Planning Analytics Tips & Tricks Video: Using Words Instead of Numbers

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

Home » Revelwood » Page 6

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

IBM Planning Analytics Tips & Tricks: Admin Server Recycle

March 24, 2020 by Lee Lazarow Leave a Comment

Tips & Tricks

In your existing TM1 world, much of the administration is done via your computer’s operating system. Planning Analytics brings much of the administration into your environment via a web-based interface.  This blog post explains how to do server recycle through the new interface.

Planning Analytics offers the ability to stop and/or restart your server and access logs within your system. These steps are done within the administration screen.

To access the administration screen, click on the Administration option at the top right corner of your screen (note that this will only appear if you have Admin permissions).

IBM Planning Analytics Tips & Tricks: Admin Server Recycle

Once inside the administration portal, select the option for Databases.

IBM Planning Analytics Tricks: Admin Server Recycle

You will see all your servers at the bottom left corner of your screen. Each server box will define information such as the current memory usage and the current CPU usage.

IBM Planning Analytics Tips: Admin Server Recycle

The bottom of the box will give you the ability to stop or restart your server and the three dots at the top of the box will give you access to various logs.

This approach within Planning Analytics allows server administration to be performed by PA administrators without the need to learn operating system techniques or to perform file navigation steps.

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 Planning Analytics Tips & Tricks:

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

IBM Planning Analytics Tips & Tricks: Admin Alerts

IBM Planning Analytics Tips & Tricks: Admin Critical Alerts

Home » Revelwood » Page 6

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

IBM Planning Analytics Tips & Tricks: Admin Alerts

February 25, 2020 by Lee Lazarow Leave a Comment

Tips & Tricks

In your existing TM1 world, much of the administration is done via your computer’s operating system. Planning Analytics brings much of the administration into your environment via a web-based interface.  One of the tasks you can do in this interface is to create and define email alerts.

Planning Analytics offers the ability to notify you about aspects of your server such as “Alert me when memory usage on the machine exceeds 50%”.  This is done within the administration screen.

To access the administration screen, click on the Administration option at the top right corner of your screen (note that this will only appear if you have Admin permissions).

IBM Planning Analytics Tips & Tricks: Admin Alerts

Once inside the administration portal, select the option for Databases, Configuration.

IBM Planning Analytics Tips: Admin Alerts

Within the configuration settings window you can then select Alerts, expand the Databases section, and select a database.

IBM Planning Analytics Tricks: Admin Alerts

Once selected, you will have a series of options such as memory usage and thread information. Each option offers threshold definitions and an option to send a notification. The bottom of the screen defines the email addresses that will be used when notifications are sent.

This approach within Planning Analytics allows system administration to be performed by PA administrators without the need to learn operating system techniques or advanced coding methods.

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!

Learn more IBM Planning Analytics Tips & Tricks to make your admin tasks easier!

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

IBM Planning Analytics Tips & Tricks: Simplifying Dimension Maintenance

IBM Planning Analytics Tips & Tricks: Planning Analytics Administration

Home » Revelwood » Page 6

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

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

February 18, 2020 by Lisa Minneci Leave a Comment

Videos

In today’s IBM Planning Analytics Tips & Tricks video, our PF&A Technology Director, Lee Lazarow, demonstrates a new feature in Planning Analytics Workspace (PAW) version 2.0.44, that enables you to reorder TM1 cubes. Your TM1 cubes were likely designed for a specific reason. Over the course of years, the data has been changed and added to. TM1 would let you optimize the system by reordering the dimensions and re-indexing the database.

Watch this Planning Analytics video to see how this new feature lets you optimize your cubes by reordering them. When you reorder your cubes, PAW gives you information about the optimization, including if there will be an increase or decrease in performance, and what the impact on RAM will be.

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

Want to get our Planning Analytics Tips & Tricks delivered to your inbox every Tuesday? Sign up to get our weekly email of just the week’s tip! And don’t forget to subscribe to our YouTube channel for more Planning Analytics videos.

Watch more Planning Analytics video tutorials:

Filtering in Planning Analytics

Creating Buttons in Planning Analytics

Planning Analytics Admin

Home » Revelwood » Page 6

Filed Under: IBM Planning Analytics Tips & Tricks, Videos Tagged With: Analytics, Budgeting, Budgeting Planning & Forecasting, Financial Performance Management, IBM Cognos TM1, IBM Planning Analytics, lee lazarow, planing analytics video, Planning & Forecasting, Planning & Reporting, Planning Analytics Tips & Tricks, planning analytics tips & tricks video, Revelwood, TM1

Adaptive Insights Tips & Tricks: Trigger for a Cube Calculated Account

February 12, 2020 by Michelle Song Leave a Comment

Tips & Tricks

When you try to use the “actuals overlay” function in a cube calculated account to display actuals data from a modeled sheet, but you keep receiving a formula error that says “Cube Calculation Formulas must evaluate to zero when the cube’s other accounts are zero”, what do you do?

Adaptive Insights Tips & Tricks: Trigger for a Cube Calculated Account

The reason for this is that cube sheets are intended to use for data input with multi-dimensions and calculations within the current cube, but not as a way to display data from other areas in the instance. To solve this problem, you have to condition the account based on another account in the current cube sheet.

For example, you can create a “Trigger Account” and assigned a value of 1 to the account for all intersections and periods that you want to display the data.

Adaptive Insights Tips & Tricks

Then, in the formula section of the cube calculation account, write

Adaptive Insights Tips & Tricks

Note: If you do not need the actual overlay function, you can use a Cube Metric account. Cube metric accounts can reference accounts from other sheets and do not need “trigger” accounts.

The team at Revelwood has been recognized by Adaptive for its thought leadership in the space, commitment to its Adaptive Insights practice, and its rapid achievements of milestones. Visit Revelwood’s Knowledge Center for our Adaptive Insights Tips & Tricks or sign up here to get our Adaptive Insights Tips & Tricks delivered directly to your inbox. Not sure where to start with Adaptive Insights? Our team here at Revelwood can help! Contact us info@revelwood.com for more information.

Read more Adaptive Insights Tips & Tricks from the Revelwood team:

Adaptive Insights Tips & Tricks: Alternate Time Tree

Adaptive Insights Tips & Tricks: Assumption Sheets

Adaptive Insights Tips & Tricks: Finding Missing Formulas

Home » Revelwood » Page 6

Filed Under: Workday Adaptive Planning Tips & Tricks Tagged With: Adaptive Insights, adaptive insights tips & tricks, Analytics, Revelwood

IBM Planning Analytics Tips & Tricks: Excel’s CONCAT and TEXTJOIN Functions

February 4, 2020 by Nina Inverso Leave a Comment

Tips & Tricks

Microsoft Excel has recently introduced a new version of the CONCATENATE function called CONCAT. The purpose is similar in that the new function still combines text from multiple ranges and/or strings. CONCAT will eventually replace CONCATENATE, but Microsoft has not released plans to sunset the original function to ensure compatibility with older versions of Excel.

The CONCAT function expects at least one text parameter value, with a maximum of 253 arguments. For example:

IBM Planning Analytics Tips & Tricks: CONCAT and TEXTJOIN Functions
=CONCAT(A1,B1,C1,D1,A2,B2,C2,D2)

returns “Tobeornottobe.” The new function also allows you to combine text ranges. For example:

=CONCAT(A1:D2)

returns a string consisting of the values in cells A1, B1, C1, D1, A2, B2, C2, and D2. In this case, “Tobeornottobe” will once again be returned.

Similarly, the TEXTJOIN function joins text from multiple ranges and/or strings but includes two additional parameters. These parameters allow you to specify the delimiter and determine if empty cells are ignored. For example:

=TEXTJOIN(“ ”, TRUE, A1:D2)

returns “To be or not to be,” whereas

=TEXTJOIN(“ ”, FALSE, A1:D2)

returns “To   be or not  to be.” In the last example, the spaces have been doubled wherever there are empty cells because the second parameter has been set to FALSE.

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

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

Read related posts with Excel Tips & Tricks and using Excel with Planning Analytics:

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

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

IBM Planning Analytics Tips & Tricks: Recalculating Excel Worksheets

Home » Revelwood » Page 6

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

Adaptive Insights Tips & Tricks: Alternate Time Tree

January 29, 2020 by Michelle Song Leave a Comment

Tips & Tricks

Have you ever wanted to have an alternate time tree/ stratum rollup in Adaptive Insights? The current Adaptive Insight system only supports one stratum rollup and there is no “Time Attribute” available in the current system to group the different time periods together. Here are some workarounds for you.

For example, the screenshot below is your current time tree setup in Adaptive Insights. Week is the lowest time stratum in the time tree. It has a stratum rollup of Week – Month – Quarter – Year.

Alternate time tree in Adaptive Insights

This is the main time tree that you used in your company for planning. However, you also have an alternate time tree that you used for your in store calendar, which has a stratum rollup of Week – Cycle – Year. Weeks are the same in both time trees, but Cycles do not roll up into Month and Quarter, so you couldn’t include Cycle in the current time tree.

Here are two methods to achieve an “alternate time tree”:

  1. If the alternate time tree is only used for reporting purposes, plan at the Week (lowest) time stratum and use Report/OfficeConnect to sum up the weeks for each Cycle.
Understanding alternate time trees in Adaptive Insights

In this case, Cycle1-2019 is a subtotal calculation of WK1 to WK4-2019.

2. If the alternate time tree is used for planning purposes, create a dimension for Cycle and use it in the sheet. An example is shown in the screenshot below of a modeled sheet. The timespan is used to input expense for each week. Week 1 to week 4 is Cycle 1, so the values for Cycle 1 are only entered in those periods.

stratum rollup in Adaptive Insights

Here’s a report to show the results.

Understanding stratum rollup in Adaptive Insights

Hope you find this helpful and feel free to reach out to us if you have any questions!

The team at Revelwood has been recognized by Adaptive for its thought leadership in the space, commitment to its Adaptive Insights practice, and its rapid achievements of milestones. Visit Revelwood’s Knowledge Center for our Adaptive Insights Tips & Tricks or sign up here to get our Adaptive Insights Tips & Tricks delivered directly to your inbox. Not sure where to start with Adaptive Insights? Our team here at Revelwood can help! Contact us info@revelwood.com for more information.

Read more Adaptive Insights Tips & Tricks:

Adaptive Insights Tips & Tricks: How to Override Default Lookups

Adaptive Insights Tips & Tricks: Leveraging your Testing Model

Adaptive Insights Tips & Tricks: Finding Missing Formulas

Home » Revelwood » Page 6

Filed Under: Workday Adaptive Planning Tips & Tricks Tagged With: Adaptive Insights, adaptive insights tips & tricks, Analytics, Financial Performance Management, Revelwood

IBM Planning Analytics Tips & Tricks: Excel’s IFS Function

January 21, 2020 by Nina Inverso Leave a Comment

Tips & Tricks

While the IF function has been around for a while now, IFS is new to Excel. This function checks whether one or more conditions are met and then returns the value associated with the first TRUE condition. The main objective of IFS is to simplify an expression that would have previously required multiple nested IF functions.

The general format of the IFS function is

=IFS(Condition 1, Value if Condition 1 = TRUE, Condition 2, Value if Condition 2 = TRUE, Condition 3, Value if Condition 3 = TRUE)

The function can handle up to 127 different conditions, and only the first two parameters are required.

Here is an example using a sample Excel grid:

IBM Planning Analytics Tips & Tricks: Excel's IFS function
=IFS(A1>250,A2,B1>250,B2,C1>250,C2,D1>250,D2)

will return “Green” (the value of cell C2).

In older versions of Excel, this would be written as

=IF(A1>250,A2,IF(B1>250,B2,IF(C1>250,C2,IF(D1>250,D2))))

Multiple nested IF functions would previously be used to accomplish the same result.

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

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

Read related posts with Excel Tips & Tricks and using Excel with Planning Analytics:

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

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

IBM Planning Analytics Tips & Tricks: Recalculating Excel Worksheets

Home » Revelwood » Page 6

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

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