DataMaestro Knowledge Base

DataMaestro is a data orchestration platform designed specifically for the IBM Planning Analytics/TM1 environment. It offers a fast and friendly interface for system administrators to be able to execute the movement of data within and across cubes – doing so in far less time and requiring significantly less effort and skill set when compared to traditional methods. It comes in both cloud and on-premise versions, depending upon your Planning Analytics deployment method.

Some of the features of DataMaestro include:

• A rich, easy-to-use web-based interface that isn't reliant on Excel

• The ability to create snapshots and streamline your data management processes by creating ad hoc scenarios, updating budgets and more (including features like copy, zero out, multiply, add and export)

• Enhanced features like detailed history tracking and package scheduling

• The ability to execute data processes within a single cube or across multiple cubes based on common dimensions in one simple setup

• A friendly environment that proactively warns users if they have made a mistake setting up a task 

• A "set and forget" feature to create scheduled processes for your recurring tasks

• Messaging, alerts and email notifications for when processes succeed or fail

Some of the ways you might use DataMaestro include:

• Copy Budget v1 to Budget v2, increasing all values by 10%

• Zero out all data for Europe

• Move a set of data from Salesperson A to Salesperson B

• Snapshot the entire forecast across all cubes for archival or comparison purposes

• Instantly move all data associated with a renamed element

• Export a set of data to upload to the G/L