Revelwood

Your SUPER-powered WP Engine Site

Planning Analytics video

IBM Planning Analytics Tips & Tricks Video: The Aggregate Function

by Leave a Comment

Watch our latest IBM Planning Analytics Tips & Tricks video to learn about the aggregate function. Lee Lazarow, Revelwood’s FP&A Technology director, demonstrates this new function that allows you to summarize values that cannot be added up or averaged.

You’ll see Lee create a simple view of net income, examining some of the details associated with opex. He looks at it for multiple companies and for a total. Lee explains how one set of data is from the original numbers that your planners input into Planning Analytics. That data is doing a standard roll-up.

The second set of data is for a calculation of the percentage of net income. Lee demonstrates what you should do if you don’t want to look at the pre-built consolidation, but instead want to look at only some of the companies. He walks you through how to create your own calculation.

You’ll learn how to make sure this calculation is not a sum calculation, but instead how to leverage the aggregate function to summarize values such as percentages or ratios.

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!

Watch more IBM Planning Analytics Tips & Tricks videos:

IBM Planning Analytics Tips & Tricks Video: Drag & Drop Functionality

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

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

Home » Planning Analytics video

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

by Leave a Comment

In today’s IBM Planning Analytics Tips & Tricks video, Lee Lazarow, our PF&A Technology Director, demonstrates how to format views in Planning Analytics Workspace (PAW). By using formatting, you will make your views easier to read so your users can spend more time focusing on their data.

Watch the video to learn how to manipulate your views by:

  • Making your columns wider
  • Changing rowing heights
  • Changing fonts and text styles
  • Adding shading, and more.

You’ll also learn how to start over if you want to change your formatting. Taking the time to format your views makes it much easier for your users to home in on the data and the meaning behind that data.

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: Creating Multi-Level Dimensions

IBM Planning Analytics Tips & Tricks Video: The Hold Feature

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

Home » Planning Analytics video

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

by Leave a Comment

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 » Planning Analytics video

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

by Leave a Comment

In today’s IBM Planning Analytics Tips & Tricks video, our FP&A Technology Director, Lee Lazarow, demonstrates how you can use words to input data in Planning Analytics Workspace (PAW) instead of numbers. In the old TM1-world, you had the ability to put numbers into your system as part of your normal planning approach. Now, you can use words. Let’s explain …

Watch our Planning Analytics video and you’ll learn how to:

  • Enter words such as 2k to indicate 2,000
  • Enter 2.5K for 2,500
  • Use the “greater than” sign to spread values into other cells and reconsolidate them
  • Have Planning Analytics Workspace do the math for you by typing in common phrases such as “add 100” or “increase by 10%”

This approach gives you a great deal of flexibility when using PAW. You can use your number keypad, your standard keyboard, or even voice commands to enter data into 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 video tutorials:

IBM Planning Analytics Tips & Tricks Video: Reordering TM1 Cubes

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

IBM Planning Analytics Tips & Tricks Video: Creating Buttons in Planning Analytics

Home » Planning Analytics video

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

by Leave a Comment

In today’s IBM Planning Analytics Tips & Tricks video, our FP&A Technology Director, Lee Lazarow, demonstrates how to do filtering in Planning Analytics. Filtering in Planning Analytics Workspace (PAW) will make it easy for your users to select the data they want to see, thereby giving them a good user experience.

The new PAW interface works much like Windows Server does – you can do various searches (wildcard searches, level searches, attribute searches) and thereby take a giant list of elements and filter it down to a smaller subset. The PAW interface even takes it a step further by enabling you to make your search criteria much more structured and user-friendly.

When you master the ability to do filtering in PAW, you’ll enable your users to easily select the data they need.

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 week? 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 IBM Planning Analytics Tips & Tricks videos:

Reviewing Chores in Planning Analytics

Creating Buttons in Planning Analytics

Planning Analytics Admin

Home » Planning Analytics video

IBM Planning Analytics Tips & Tricks: Reviewing Chores

by Leave a Comment

In today’s IBM Planning Analytics video tutorial, our FP&A Technology Director, Lee Larazow, demonstrates PAW v 2.0.43’s new approach that allows you to easily review the chores that are associated with a specific process. Once you have mastered the techniques Lee explains in this video, you’ll have a key skill to making it much easier to maintain your Planning Analytics environment.

Watch this video and you’ll learn how to:

  • Go into a list of processes
  • View all the individual chores associated with a process
  • Define the processes within the chore
  • Completely remove a process from the chore

This new approach by PAW makes Planning Analytics maintenance much easier!

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:

Creating Buttons in Planning Analytics

Planning Analytics Admin

Dimension Maintenance in IBM Planning Analytics

Home » Planning Analytics video

IBM Planning Analytics Tips & Tricks: Creating Buttons for TurboIntegrator Scripts

by Leave a Comment

In today’s IBM Planning Analytics video tutorial, our FP&A Technical Director, Lee Lazarow, shows you how to easily create buttons for TurboIntegrator (TI) scripts. When you create buttons for your TI scripts, you simplify tasks for your end users and create a much better Planning Analytics experience for them.

In many situations you’ll have a TurboIntegrator script that you’ll want your end users to run. But you should have an easy way for them to run that script. The solution is to create a button in the Planning Analytics Workspace (PAW) environment.

Watch our video Creating Buttons for TurboIntegrator Scripts in IBM Planning Analytics to learn the steps to create a button. These include:

  • Going into properties
  • Turning the properties for the button target into a process
  • Choosing if you want a prompt, and how you want that prompt to appear

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!

Watch more IBM Planning Analytics Tips & Tricks videos:

Planning Analytics Administration

Dimension Maintenance in IBM Planning Analytics

Regions with Rules in IBM Planning Analytics

Subscribe to Revelwood’s YouTube channel to watch all of our IBM Planning Analytics Tips & Tricks videos.

Home » Planning Analytics video

IBM Planning Analytics Tips & Tricks: Simplifying Dimension Maintenance

by Leave a Comment

Watch our latest IBM Planning Analytics Tips & Tricks video to learn how to simplify dimension maintenance in Planning Analytics. Once you master these easy techniques, you’ll be able to do all of your dimension maintenance from the Planning Analytics Workspace (PAW) administration screen.

In this video, Lee Lazarow, Revelwood’s FP&A technology director, demonstrates how to maintain your dimensions in PAW. Lee shows you how to move elements using both a standard drag-and-drop approach and a wizard-based approach. You’ll also see how to create new hierarchies and how to manipulate your dimension structure without going to a different screen.

By merging all aspects of a dimension together, you can do all your dimension maintenance from the PAW administration screen.

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!

Check out our IBM Planning Analytics Tips & Tricks video series:

Regions with Rules in IBM Planning Analytics

Bookmarking in IBM Planning Analytics

Snap Commands in IBM Planning Analytics

Pivoting & Selecting Shortcut in IBM Planning Analytics

Home » Planning Analytics video

IBM Planning Analytics Tips & Tricks Video: Bookmarks in IBM Planning Analytics Workspace

by Leave a Comment

In our latest IBM Planning Analytics Tips & Tricks video, Revelwood’s FP&A Technical Director, Lee Lazarow explains and demonstrates how bookmarks work in IBM Planning Analytics Workspace (PAW). Bookmarks in PAW are quick and easy to use and make a big difference when navigating through many items in Planning Analytics.

Watch Bookmarking in IBM Planning Analytics and learn:

  • How to add or remove a bookmark
  • How bookmarks are used to quickly move to a certain spot
  • How bookmarks are used to go to a specific view

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!

Watch other videos in our IBM Planning Analytics Tips & Tricks series:

Regions with Rules in IBM Planning Analytics

Creating Dimensions in IBM Planning Analytics

Creating Dashboards in IBM Planning Analytics

Creating a Cube in IBM Planning Analytics

Home » Planning Analytics video