• 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: Combining the DIMIX and DIMNM Functions

IBM Planning Analytics Tips & Tricks

IBM Planning Analytics Tips & Tricks: Combining the DIMIX and DIMNM Functions

 

Tips & Tricks

January 11, 2022

By Lee Lazarow

In a previous blog, we defined how to convert an alias back to the original element name within a TurboIntegrator script. The DimensionElementPrincipalName function is only valid for TI scripts, so what happens if you need to perform the same logic in a rule?

You can convert an alias back to the Principal Name by using a combination of two functions: DIMIX and DIMNM.

The DIMIX function defines the index number of an element within a dimension. The syntax of the command is:

DIMIX (dimName, elementName)

The DIMNM function returns an element that corresponds to a specific index number. The syntax of the command is:

DIMNM (dimName, IndexNumber)

When combined, we can determine a principal name via the following approach:

  1. Determine the index number of the element using the alias value
  2. Look up the principal name via the index number from the first step

For example:

The following details exist in a dimension called Names:

IBM Planning Analytics Tips & Tricks: Combining the DMIX and DIMNM Functions

DIMNM (‘Names’, DIMIX (‘Names’, ‘Johnny’)) will result in the value ‘John’

This is done by defining the index number of Johnny (index #1) and then using that value to define the principal name. This can be used in conjunction with rules in your model. If I have an input cell for a person’s name, then I don’t know if users will enter John or Johnny. I can therefore create logic to convert the input value back to the element name.

IBM Planning Analytics, powered by TM1, is full of new features and functionality. Need advice? Our team here at Revelwood can help. Contact us for more information at info@revelwood.com. We post new Planning Analytics Tips & Tricks weekly in our Knowledge Center and in newsletters!

Read more IBM Planning Analytics Tips & Tricks:

IBM Planning Analytics Tips & Tricks: Converting an Alias Back to the Element Name in TurboIntegrator

IBM Planning Analytics Tips & Tricks: TM1PRIMARYDBNAME

IBM Planning Analytics Tips & Tricks: Fill Function

    • 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. 

Modern Accounting: The Importance of Rob

Modern Accounting

Modern Accounting: Enhancing BlackLine I

Modern Accounting