• 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
        • Adaptive Planning Training
        • IBM Planning Analytics / TM1 Training
    • Products
      • DataMaestro
      • LightSpeed
      • IBM Planning Analytics Utilities
  • How We Help
    • Workday Adaptive Planning Use Cases
    • IBM Planning Analytics Use Cases
    • BlackLine Use Cases
    • Client Success Stories
  • How We Think
    • Knowledge Center
    • Events
    • News
  • Contact Us

Planning analytics + MDX

IBM Planning Analytics Tips & Tricks: An Approach to Strengthening your MDX Skills

October 20, 2020 by Lee Lazarow Leave a Comment

Tips & Tricks

Are you new to IBM Planning Analytics and looking for a good way to learn about the various commands associated with MDX? The Planning Analytics subset editor offers a great way to teach you about MDX expressions that can be used to define elements within a dimension.

The example below shows the results of a subset that includes all descendants of Total Department. The subset was created by simply dragging Total Departments into the current set while having the member insertion defined as descendants.

IBM Planning Analytics Tips & Tricks: Subset MDX Button

Once created, I can see the MDX expression that is used by clicking the MDX button at the top, right corner of the screen. The resulting expression is:

IBM Planning Analytics Tips: Subset MDX button

However, this button is not only used to view your newly created MDX expressions. The button also allows you to edit the expression. In this case, I can change the root element to be Sales and Marketing by simply typing over the existing MDX expression.

IBM Planning Analytics Tricks: Subset MDX button

After clicking the OK button, the elements in the current set are updated.

Subset MDX button in IBM Planning Analytics

This approach can help you to learn the fundamentals of MDX expressions, which are helpful for many different components of 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!

Read more IBM Planning Analytics Tips & Tricks:

IBM Planning Analytics Tips & Tricks: Sort Elements Within a Subset

IBM Planning Analytics Tips & Tricks: Editing Chores While Active

IBM Planning Analytics Tips & Tricks: Creating Groups in PAW

Home » Planning analytics + MDX

Filed Under: IBM Planning Analytics Tips & Tricks Tagged With: Budgeting, Budgeting Planning & Forecasting, Financial Performance Management, IBM Cognos TM1, IBM Planning Analytics, lee lazarow, Planning & Forecasting, Planning & Reporting, Planning analytics + MDX, Planning Analytics Tips & Tricks, Revelwood, TM1

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

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