• Skip to primary navigation
  • Skip to main content
  • Skip to footer
Revelwood

Revelwood

  • 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
      • Advisory Services
      • Customer Care
        • Help Desk
        • System Admin
        • Performance Tune-Up
      • Training
        • Workday Adaptive Planning Training
        • IBM Planning Analytics / TM1 Training
    • PRODUCTS
      • DataMaestro
      • Lightspeed Planning & Reporting
      • IBM Planning Analytics Utilities
  • How We Help
    • Workday Adaptive Planning Use Cases
    • IBM Planning Analytics Use Cases
    • Client Success Stories
  • How We Think
    • Knowledge Center
    • Events
    • News
    • User Groups
  • Contact Us

IBM Planning Analytics Tips & Tricks: How to Make Action Button Messages Dynamic

This is a guest post from Revelwood’s Jay Apwah. Did you know that in Planning Analytics for Microsoft Excel (PAx) and Perspectives you can customize action button messages? Well you can go one step further and make those messages dynamic. In this blog, we will walk through the following steps: Setup cells in a PAx […]

IBM Planning Analytics Tips & Tricks

IBM Planning Analytics Tips & Tricks: How to Make Action Button Messages Dynamic

 

Tips & Tricks

June 12, 2018

By Revelwood

This is a guest post from Revelwood’s Jay Apwah.

Did you know that in Planning Analytics for Microsoft Excel (PAx) and Perspectives you can customize action button messages? Well you can go one step further and make those messages dynamic.

In this blog, we will walk through the following steps:

  1. Setup cells in a PAx workbook for the custom messages.
  2. Edit an action button to use the custom messages.

In this example, we have a PAx worksheet that allows users to click an action button to run a TI process using two parameters: the name of a file to load, the period to which the data will be loaded in a cube called bpmFinance. Whenever this process is executed, it logs statistics into a control cube: Number of records in the source file and Number of skipped records.

Below are the custom messages that we want to be shown to the user upon clicking the action button:

  • Confirmation message: “Are you sure you want to load the <file name> into the <period> period?”
  • Success message: “Process completed successfully – <X of X> records loaded”
  • Failure message: “Process failed. Records in file: <X>. Skipped Records: <Y>

Step 1: Setup custom messages

In any row that can be hidden, use a combination of Excel and TM1 worksheet functions to construct the custom messages. In this example, we will end up hiding rows 13-15. This is where our custom messages are constructed.

Figure 1: Example of formula to construct the confirmation message.

Make action buttons in IBM Planning Analytics dynamic

Formula:

=”Are you sure you want to load the “&C4&” file into the “&C5&” period?”

Figure 2: Example of formula to construct the success message.

Learn how to make action buttons in IBM Planning Analytics dynamic

Formula:

=”Process completed successfully – “&DBR(“<server>:bpmControls”, “Value”, “GL Actual File – Total Count”)&” of “&DBR(“<server>:bpmControls”, “Value”, “GL Actual File – Total Count”)&” records loaded.”

Note: The formula above retrieves the process statistic: “GL Actual File – Total Count” from a cube called bpmControls.

Figure 3: Example of formula to construct the failure message.

Making action buttons in IBM Planning Analytics dynamic

Formula:

=”Process failed. Records in file: “&DBR(“HQCorp:bpmControls”, “Value”, “GL Actual File – Total Count”)&”. Skipped records: “&DBR(“HQCorp:bpmControls”, “Value”, “GL Actual File – Skipped Count”)

Note: The formula above retrieves the process statistics: “GL Actual File – Total Count” and “GL Actual File – Skipped Count” from a cube called bpmControls.

Step 2: Edit action button to use the custom messages

  • In the properties of the action button that runs the TI process, click “Options”How to make action buttons in IBM Planning Analytics dynamic
  • The default success, failure and confirmation messages are displayed.
dynamic action buttons in IBM Planning Analytics
  • Since the custom confirmation, failure and success messages are in cells C13, C15 and C14, respectively. Change the default messages from hard-coded words to the appropriate Excel references as shown below.
making dynamic action buttons in IBM Planning Analytics

Result

Dynamic confirmation message

Now when the “Run” action button is clicked, a confirmation message appears. The confirmation message is dynamic and picks up the parameter values entered/selected by the user.

learn about dynamic action buttons in IBM Planning Analytics

Dynamic success message

When the confirmation is accepted, if the process completes successfully, the dynamic success message would appear. Notice how the success message displays the statistics that the process logged in the control cube.

how to make dynamic action buttons in IBM Planning Analytics

Dynamic failure message

When the confirmation is accepted, if the process failed, the dynamic failed message would appear. Notice how the success message displays the statistics that the process logged in the control cube.

making dynamic action buttons in IBM Planning Analytics

IBM Planning Analytics 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!

    • Categories

      • Awards & Recognition
      • FP&A Done Right
      • IBM Planning Analytics Tips & Tricks
      • Modern Accounting
      • News & Events
      • Success Stories
      • Tech Bulletins
      • Workday Adaptive Planning Insights
      • Workday Adaptive Planning Tips & Tricks

    Popular Posts

    • Workday Adaptive Planning Tips & Tricks: The Formula Assistant – How To, Where & Why
    • Workday Adaptive Planning Tips & Tricks: Templates
    • IBM Planning Analytics Tips & Tricks: Troubleshooting Planning Analytics for Excel
    • Workday Adaptive Planning Named a Leader in Gartner Magic Quadrant for Cloud Financial Planning and Analysis Solutions 2020
    • Workday Adaptive Planning Tips & Tricks: Excel Reporting Using a Report Template

    Sign up for our newsletter

    Connect

    Authors

    • John Pra Sisto
    • Revelwood
    • Adam Riskin
    • Ailenette Cruz
    • Brian Combs
    • Dave Miersch
    • Dillon Rossman
    • Gary Leiffer
    • Ken Wolf
    • Koury Reid
    • Lee Lazarow
    • Lisa Minneci
    • Marc Assenza
    • Mary Luchs
    • Michelle Song
    • Nina Inverso
    • Summer Jeter
    • Tara Byrnes
    • Thanh Chau
    • Wesley DeMarco

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

Contact:
25B Vreeland Road, Suite 111
Florham Park, NJ 07932

201.984.3030
info@revelwood.com

© Revelwood Inc. All rights reserved. Revelwood® and the Revelwood logo are registered marks of Revelwood Inc. 

News & Events

The Customer Insights’ Imperative for

News & Events

News & Events

Embracing Continuous Planning

News & Events