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

TurboIntegrator

Introducing DataMaestro, the Data Orchestration Platform for IBM Planning Analytics / TM1

May 23, 2022 by Revelwood Leave a Comment

News & Events

We’ve just released a new product designed to make the lives of IBM Planning Analytics / TM1 systems administrators’ easier. DataMaestro is a solution for managing and moving data that saves Planning Analytics / TM1 users significant time and money by making it easier to manage data processing tasks with just a few simple steps. It reduces the need to create TurboIntegrator processes, which require developer-level scripting skills.

Previously DataMaestro was available only to Revelwood clients. We’re now offering it to any Planning Analytics / TM1 user. DataMaestro has earned many rave reviews from our clients.

“I have been an IBM Planning Analytics/TM1 user for many years and I wish DataMaesto was available years ago!” said Collin Duncan, senior director of FP&A, Extra Space Storage. “Moving data across all cubes is so efficient and makes my life so much easier. On a scale from 1-10, I give DataMaestro a 10.”

“DataMaestro has a great layout and is so intuitive,” added Theresa Alexopoulos, director of budgeting, Berkeley College. “It gives me a birds-eye view of what data movements need to be done. The Package History is easy to find, and I can see a complete list of processes – when they were run, how often and in what order. The email notification feature for scheduling Packages is one of my favorite features. I know immediately whether a Package ran successfully. Best of all, you can manage your data movements with just a few clicks. No more need for TI processes.”

Watch this short demo to see how DataMaestro enables you to:

  • Create a task (similar to a TurboIntegrator process)
  • Process data within a single cube or multiple cubes simultaneously via a single task
  • Make decisions about each dimension of cube data to process
  • Run tasks on the fly
  • Save tasks to reuse later, and more.

“For 27 years we have been offering best-in-class products and services for IBM Planning Analytics / TM1,” said Ken Wolf, CEO, Revelwood. “The original vision behind TM1 was to make the lives of financial analysts better and more enjoyable. Our vision for DataMaestro is to do the same for system administrators – reducing the time, cost and complexity involved in managing their Planning Analytics environments.”

DataMaestro is available for IBM Planning Analytics / TM1 in the cloud and on-premises.

Interested in learning more about DataMaestro? Join us for a 20-minute webinar on Wednesday, June 22, 2022, at 1pm ET. Register here: https://bit.ly/3FWMQgJ

Read the DataMaestro press release.

Home » TurboIntegrator

Filed Under: News & Events Tagged With: DataMaestro, IBM Cognos TM1, IBM Planning Analytics tools, move data + Planning Analytics, move data + TM1, Revelwood DataMaestro, TM1 tools, TurboIntegrator, TurboIntegrator processes

IBM Planning Analytics Tips & Tricks: Code Char

August 3, 2021 by Lee Lazarow Leave a Comment

Tips & Tricks

Have you ever written a TurboIntegrator script and wanted to check the first character of a value to see if it was a number or a letter? Have you ever needed to insert a single or double quote into a string without “breaking” your code? Have you ever wanted to easily convert a lower case letter into an upper case letter? All of this can be done by referencing the ASCII code associated with the character.

ASCII is an abbreviation for American Standard Code for Information Interchange and is used as a standard for electronic communication. ASCII codes represent text for computers. Every key on your keyboard has a defined code number. Tables associated with these codes can be found via a simple Internet search.

There are two functions in IBM Planning Analytics / TM1 that allow you to reference the ASCII code:

  • CHAR returns the character associated with a numeric ASCII code. For example, CHAR(76) returns a capital L.
  • CODE returns the numeric ASCII code associated with a character. For example, CODE(‘Lee’, 1) returns 67 since the first character is a capital L.

These functions can be used in conjunction with other functions and logic to perform various tasks:

  • If the first character of a value has an ASCII code in the range of 48-57, then the value is a number.
  • If the first character of a value does not have an ASCII code in the range of 48-57, 65-90, or 97-122 then the value is not a number or a letter.
  • ASCII code 39 is a single quote and ASCII code 34 is a double quote.
  • All capital and lowercase codes have the same ASCII code value difference, so you can add or subtract 32 to convert between uppercase and lowercase.

These functions allow you to check and manipulate data without having to ignore the rules of TurboIntegrator coding.

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: Creating Buttons for TurboIntegrator Scripts

IBM Planning Analytics Tips & Tricks: Maintaining Subset-Driven Consolidations

IBM Planning Analytics Tips & Tricks: Compatibility of Views and Subsets

Home » TurboIntegrator

Filed Under: IBM Planning Analytics Tips & Tricks Tagged With: code char, Cognos TM1, IBM Planning Analytics, TI, TM1, TurboIntegrator

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

World Headquarters

Florham Park, NJ | 201 984 3030

European Headquarters

London & Edinburgh | +44 (0)131 240 3866

Latin America Office

Miami, FL | 201 987 4198

Email
info@revelwood.com

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