Exporting data from IBM Planning Analytics (TM1) is easy with OneCloud's out-of-the-box connectivity to target systems including Salesforce, Tableau, Workday, plus relational and text files. For this tutorial, create an extract data chain.
The following step-by-step tutorial will demonstrate streaming tabular data directly from an instance of IBM PA to a flat file.
Primary Learning Objective
This exercise is designed to highlight the extracting of data to a data file from IBM PA.
Secondary Learning Objectives
Step 1: Create a New Chain
Create a new chain:
Select Build from the left-side panel.
Hover over the blue (+) icon in the lower-right corner.
Click "Create Chain".
Name the Chain "Extract Data from PA"
Save the Chain.
Step 2: Add the First Command
Add the Read View Cells Command.
Select IBM Planning Analytics TM1 ➡️ Data Operations ➡️ Read View Cells.
💡 Use the Find tool to search for "IBM" and "Read". Data Operations is a subcategory of the BizApp.
Double-click the icon to auto-load the Command into the Chain Start circle.
Set the Cube Name to the value in the Environment.
Set the View Name to the value in the Environment.
Scroll down to enable "Skip empty cells".
Save the Command.
Step 3: Add Another Command
Add the List File Content Command
Select the File Utilities ➡️ List File Content Command.
💡 Use the Find tool to search for "File Utilities" and "List File Content".
Click-and-drag the icon onto the canvas.
Connect the "Read View Cells" Command to the "List File Content" Command.
Click and hold the 🔽 at the bottom of the "Get" Command, then drag to the 🔽 at the top of the "List File Content" Command.
Edit the "List File Content" Command.
Ensure the BizApp has the appropriate Runner. For this example it's CloudRunner.
Set the File name parameter to be the output of "Read View Cells" Command.
Click the 🔽 to the right of "Read View Cells"
Select "View Data"
Set the Preview lines to 10.
Save the changes.
Step 4: Publish and Run the Chain
Publishing is an important feature in OneCloud. Chains must be published, before they can be run. A Chain and its respective Commands will not be executed otherwise. Whether making one alteration or many, the Chain must be published every time a Chain or Command is edited.
Publish ➡️ Execute ➡️ Run Chain.
To publish a Chain, click "Publish" near the upper-right corner.
Optionally, add a Publish Chain Comment. For this example, leave it blank.
Once published, the "Execute" button becomes active. Click it.
Once executed, the "Run Chain" button is activated. Click it.
The Chain will animated when it is running.
Click on the Anaplan Upload File Command.
When the Chain has been run, the outputs will be available to view by clicking on a given Command and selecting "LOGS" from the right-side panel.
📚 Related Topics from this Section: