In an IBM Planning Analytics Tips & Tricks video, I showed how to use a drag and drop approach to load data into a cube. Since that time, the wizard has been updated to allow you to save your import as a new TurboIntegrator process and to also schedule the process within a chore.
After dragging the file onto the cube, the first screen that appears is a confirmation of the file with some file-based setup aspects such as the delimiter, the quote character and the number of header rows:
After clicking the continue button, the second screen appears which allows you to define the columns and aspects associated with the data load (before and during):
The bottom, right corner of this screen allows you to save the import as a process and/or a chore:
Once executed, the process will be saved and can be referenced using PAW’s process functionality:
This approach within Planning Analytics allows you to use a drag and drop approach to create and save Planning Analytics code.
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 firstname.lastname@example.org. And stay tuned for more Planning Analytics Tips & Tricks weekly in our Knowledge Center and in upcoming newsletters! You can also sign up to get our Planning Analytics Tips & Tricks sent directly to your inbox!
Read more IBM Planning Analytics Tips & Tricks:
IBM Planning Analytics Tips & Tricks: Reviewing Chores
IBM Planning Analytics Tips & Tricks: Creating Buttons for TurboIntegrator Scripts
IBM Planning Analytics Tips & Tricks: How to Maintain a Hierarchy via a TurboIntegrator Process