• 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 Maintain a Hierarchy via a TurboIntegrator Process

This is a guest blog post by Revelwood's Nina Gorday. Did you know it is best practice to maintain a hierarchy in Planning Analytics via TurboIntegrator (TI) process whenever possible? There are five key functions that can be used to do so.

IBM Planning Analytics Tips & Tricks

IBM Planning Analytics Tips & Tricks: How to Maintain a Hierarchy via a TurboIntegrator Process

 

Tips & Tricks

June 18, 2019

By Revelwood

Did you know it is best practice to maintain a hierarchy in Planning Analytics via TurboIntegrator (TI) process whenever possible? There are five key functions that can be used to do so.

HierarchyExists(DimName, HierName)

HierarchyExists is used to determine whether a specific hierarchy already exists on the server. The first parameter is the name of the dimension that contains the hierarchy to check, and the second parameter is the name of the hierarchy to check.

HierarchyCreate(DimName, HierName)

HierarchyCreate is used to create a new hierarchy in an existing dimension. The first parameter is the name of the dimension in which to create the hierarchy, and the second parameter is the name of the hierarchy to create.

HierarchyDeleteAllElements(DimName, HierName)

HierarchyDeleteAllElements deletes all elements from a hierarchy. The first parameter is the name of the dimension in which the hierarchy exists, and the second parameter is the name of the hierarchy from which to delete all elements.

HierarchyElementInsert(DimName, HierName, InsertionPoint, ElName, ElType)

HierarchyElementInsert adds an element to a hierarchy. The first and second parameters are once again used to specify the names of the applicable dimension and hierarchy (respectively). The third parameter can be used to specify the element before which the new element will be inserted. If it’s left blank, the new element will be inserted at the end of the dimension. The fourth parameter is the name of the new element, and the fifth parameter is the element type. The letter N signifies a numeric element, the letter S signifies a string element, and the letter C signifies a consolidated element.

HierarchyElementComponentAdd(DimName, HierName, ConsolidatedElName, ElName, ElWeight)

HierarchyElementComponentAdd adds a child to a consolidated element. The first and second parameters are once again used to specify the names of the applicable dimension and hierarchy (respectively). The third parameter is the name of the parent or consolidated element, the fourth parameter is the name of the child element, and the fifth parameter is the weight of the child element in the consolidation.

The following code example is used to create the Delivery Format hierarchy in the Publication dimension of this server. The metadata section of the code could then use attribute values or information from the data source to determine where in the hierarchy to place each base level publication.

IBM Planning Analytics Tips & Tricks: How to maintain a hierarchy via a TurboIntegrator Process

The full list of hierarchy manipulation TI functions can be found here.

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 blog posts in the IBM Planning Analytics Tips & Tricks Series:

IBM Planning Analytics Tips & Tricks: The Benefits of Using Hierarchies

IBM Planning Analytics Tips & Tricks: Workarounds for Unsupported Excel Functions in TM1 Web

IBM Planning Analytics Tips & Tricks: Recaclulating Excel Worksheets

Need more help? Learn about our Customer Care options for IBM Planning Analytics & TM1 users. 

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

FP&A Done Right

FP&A Done Right: There Is Life Afte

FP&A Done Right

Awards & Recognition

Adaptive Insights Earned Gartner Peer In

Awards & Recognition