Revelwood

Your SUPER-powered WP Engine Site

TM1

Revelwood’s Customer Care Offering: Advantage Services

by

Do you know about Revelwood’s Advantage Services program? It consists of an annual, discounted block of hours and priority support with Revelwood’s IBM Planning Analytics and TM1 experts or Revelwood’s Workday Adaptive Planning experts.

The Advantage Services program enables you to:

  • Use the hours as needed for support, development or training
  • Forecast support costs for the year
  • Have a repository of support tickets through the length of your Advantage Services contract
  • Have Revelwood analyze your support tickets to make proactive recommendations
  • Receive discounted services hours, making your support dollars go farther

We offer four Advantage Services options to meet your needs – Platinum, Gold, Silver and Bronze. Premium plans include an annual Business Review and Roadmap discussion. We also have an SMB option for smaller businesses. 

And, you do not need to be an existing Revelwood client to participate in the program!

Interested in learning more about our Advantage Services program? Contact John Pra Sisto.

Learn more about Revelwood’s Customer Care offerings:

Revelwood Customer Care: Staff Augmentation for IBM Planning Analytics

Revelwood Customer Care: Health Check & Business Process Review for IBM Planning Analytics

Home » TM1 » Page 9

IBM Planning Analytics Tips & Tricks: Excel EOMONTH

by

Thirty days has September …

Do you sing that out loud every time you want to determine the number of days in a month? If so, do you have to pause and think about the end when defining the last day of February? More importantly, do you have to write complex logic into your spreadsheet to define this? If so, you may want to learn more about the EOMONTH function in Excel!

The EOMONTH function is designed to tell you the last day of a month – either the current month, a future month, or a historical month. The function has two parameters:

=EOMONTH(start_date, months)

  • The start_date parameter defines the initial date of your calculation
    • Microsoft recommends using the DATE function for this value
  • The months parameter defines the number of months from the start date
    • A zero value results in the current month
    • A positive value results in a future month
    • A negative value results in a previous month

Graphical user interface, application, table, Excel Description automatically generated

This approach will help you in various planning models such as …

  • Workforce planning – when to start calculating benefits 
  • Asset planning – when to begin the depreciation calculations

This can also be used to define start dates by simply adding 1 to the result and determining the first day of the next month. Now we just need a formula to help us when someone obnoxiously tells us to “just perform the task on each day that ends in Y.”

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: Rounded Buttons in Planning Analytics Workspace

IBM Planning Analytics Tips & Tricks: MDX Syntax Explained

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

Home » TM1 » Page 9

IBM Planning Analytics Tips & Tricks: Excel Tips, Part 1

by

Revelwood’s IBM Planning Analytics team has created numerous tips & tricks focused on helping people use Excel. Over the next few weeks we’ll be highlighting some of the most popular and interesting posts on Excel.

IBM Planning Analytics Tips & Tricks: Excel MAXIFS and MINIFS

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? 

Read this blog post to learn more about MAXIFS.

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

Have you ever wanted to filter a list of data to look at a subset of the entire table? Many of you know that you can use the filter button within Excel’s data section to do this.

But what if you wanted to create a filter that users can change without having to navigate through ribbons? Did you know that you can do this using Excel’s FILTER function?

Take a look at this blog post to learn how to use Excel’s FILTER function to do this.

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

Have you ever wanted to search a list and define the position where it appears in the list? Maybe you want to know how many sales reps exceeded their quota or want to define how many products cost more than an approved purchase price. This information can be calculated using Excel’s XMATCH function.

Read this blog post to learn how to use Excel’s XMATCH function. 

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: How to Make an MDX Statement Dynamic

IBM Planning Analytics Tips & Tricks: Approaches in Planning Analytics’ New Set Editor

IBM Planning Analytics Tips & Tricks: Charts in Planning Analytics Workspace, Part 1

Home » TM1 » Page 9

IBM Planning Analytics Tips & Tricks: Excel TEXTSPLIT

by

Have you ever needed to parse a text string into different columns in Excel? This is easy to do via the text-to-columns wizard, but what if you wanted to do this via a formula? The TEXTSPLIT function allows you to split a text value across columns. It even lets you split values across rows!  

The function has two required parameters:

=TEXTSPLIT(text,col_delimiter)

  • The text parameter defines the string value you are searching for
  • The column delimiter parameter defines the character(s) used for each split

In addition, there are optional parameters that can be used to determine case sensitivity, determine a row delimiter, and define what to do if two matches in a row are found

The following example shows how to use the function by searching for a space between each word and then putting each word into a new column. The source value is in cell A1 and a single TEXTSPLIT formula has been created in cell A2 (note: the text of the formula has been replicated onto cell A6 to show it in this image).

Graphical user interface, application, table, Excel Description automatically generated

This next example shows a similar concept but uses a different parameter to instead put each word into a new row.

Table Description automatically generated

This approach will simplify your searches by eliminating the need to create multiple functions to parse the same set of data.

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: Excel TEXTBEFORE & TEXTAFTER

IBM Planning Analytics Tips & Tricks: Excel SEQUENCE

IBM Planning Analytics Tips & Tricks: PAW Go To Line in Process

Home » TM1 » Page 9

IBM Planning Analytics Tips & Tricks: Charts in Planning Analytics Workspace, Part 2

by

Did you know IBM Planning Analytics Workspace (PAW) gives you many options for showing data in charts? We recently shared a few tips and tricks for visualizing your data in charts. Here are some more.

Pie Chart Sizing

Did you know that PAW allows you to “split” your pie chart widget to define how much of the space is allocated to the legend and how much of the space is allocated to the chart? 

In this blog post, we explain how to view and modify the split. 

PAW Chart Multicolors

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.

Read this blog post to learn an easy way to create a column chart via an exploration. We then explain how to change that visualization into a column chart. 

Mekko Charts

PAW offers many visualization options to allow you to show and analyze your data in creative ways. This includes standard chart types such as bar, line and pie. But it also includes some reports that are not always understood. One of these report types is a Mekko chart.

A Mekko chart (also sometimes called a Marimekko chart) is used to extend a stacked column chart by using the width of each column to show the overall importance of that section. Read our blog post on using Mekko charts. 

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: Charts in Planning Analytics Workspace, Part 1

IBM Planning Analytics Tips & Tricks: DefineCalc

IBM Planning Analytics Tips & Tricks: Top 3 Blog Posts of 2022

Home » TM1 » Page 9

IBM Planning Analytics Tips & Tricks: How to Make an MDX Statement Dynamic

by

Did you know we have a number of resources available to learn more about MDX? We hosted a two-part series on How to Use MDX in Your IBM Planning Analytics Series. We also published a blog post, IBM Planning Analytics Tips & Tricks: MDX Syntax Explained, to accompany part 1 of the webinar series. 

In part 2 of our MDX webinar series, we demonstrate how to make an MDX dynamic by using the power of Excel.

You’ll see we start with a basic Excel report, generated out of IBM Planning Analytics for Excel (PAx). We then take the static, base MDX and turn it into a concatenation of parts of the index statement and the cell reference. In turn, that enables us to change the root account, thereby changing the data that shows in the report.

Watch the full webinar to learn more about working with MDX.

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: Using MDX to Compare Dimension Hierarchies

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

Home » TM1 » Page 9

IBM Planning Analytics Tips & Tricks: Approaches in Planning Analytics’ New Set Editor

by

In Revelwood’s latest IBM Planning Analytics Tips & Tricks video, Lee Lazarow demonstrates three different ways to change a drop-down menu in Planning Analytics’ new set editor.

Watch this video to learn the three approaches:

1. Change the drop-down by doubling clicking the dimension, which opens the set editor

2. Click on the three dots on the right side to open the set editor

3. Click on the drop-down to see the elements currently in the set (note: you need to enable this when you are creating your Exploration)

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:

IBM Planning Analytics Tips & Tricks: 2022’s Top 3 Tips & Tricks Videos

IBM Planning Analytics Tips & Tricks: How to Set Up Action Buttons in Planning Analytics for Excel

IBM Planning Analytics Tips & Tricks: How to Set Up Synchronizations in IBM Planning Analytics Workspace

Home » TM1 » Page 9

IBM Planning Analytics Tips & Tricks: Charts in Planning Analytics Workspace, Part 1

by

Did you know IBM Planning Analytics Workspace (PAW) gives you many options for showing data in charts? Here are some tips and tricks for working with charts in PAW.

Scatter Chart vs Bubble Chart

A scatter chart is used to show relationships within your data. This type of chart is great to see patterns and groupings over a large set of values. A bubble chart is also used to show relationships and it is also great to see patterns. So what is the difference between the two types of charts? 

In this blog post, we explain the difference between the two types of charts. As you’ll learn, the type of chart makes a difference when reviewing your data. How to decide which chart to use? It’s simple – ask yourself how many details you want to see at once. 

The Waterfall Chart

PAW includes various visualizations that can be used to view your data. One of these visualizations entails a chart called a waterfall chart. This type of chart will help you show the components of a summarized number. It is very helpful in determining which values are beneficial to the total and which values are detrimental.

This blog post shows an exploration in PAW and its corresponding waterfall chart. 

Lines vs Area for Multiple Elements

A line chart is typically used to show values over time. This type of chart is great to see trends with your data. An area chart is also used to show values over time and is sometimes referenced as a line chart with the area below the line filled. While this is the case in PAW for a chart that contains a single line, it is not the case for a chart with multiple lines. 

Read this blog post to learn about a line chart versus an area chart. 

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: DefineCalc

IBM Planning Analytics Tips & Tricks: Top 3 Blog Posts of 2022

IBM Planning Analytics Tips & Tricks: 2022’s Top 3 Tips & Tricks Videos

Home » TM1 » Page 9

IBM Planning Analytics Tips & Tricks: Top 3 Blog Posts of 2022

by

What was your favorite IBM Planning Analytics Tips & Tricks blog post in 2022? We did some analysis and determined the three most popular PA Tips & Tricks blog posts. They are:

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

Read Dillon Rossman’s blog post to learn how to use MDX to create dynamic subsets based on cube values.

2. IBM Planning Analytics Tips & Tricks: Adding a New Entry to Index Cube via a Dynamic Report

This post presents an interesting situation. If your Planning Analytics model contains a cube that uses an index or slot dimension, you will need to create a template that allows your users to add data to an unused index.

3. IBM Planning Analytics Tips & Tricks: Pax – Rebuild Book vs Recreate Book

In this post, Lee Lazarow explains the difference between the “Rebuild Book” button and the “Recreate Book” button in Planning Analytics for Excel (Pax).

Are you receiving our IBM Planning Analytics Tips & Tricks every Tuesday? If not, sign up to subscribe to our newsletter. You’ll get the latest post direct to your inbox.

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: 2022’s Top 3 Tips & Tricks Videos

IBM Planning Analytics Tips & Tricks: Excel TEXTBEFORE & TEXTAFTER

IBM Planning Analytics Tips & Tricks: How to Set Up Action Buttons in Planning Analytics for Excel

Home » TM1 » Page 9