Skip to content

TeamOne feature list

On this page we tried to list the main TeamOne features and explain them briefly. Please refer to TeamOne documentation where you can find more information including live examples.

Querying IBM PA data

There are several ways how you can bring IBM PA data directly to Google Sheets:

  • =TEAMONE() formula - the easiest and fastest way to query IBM PA data with no technical skills, for instance you don't need to specify IBM PA dimension or hierarchy names, you don't have to specify even all the dimensions, one formula can be used to bring a whole slice of data: img

  • =ATTR() is used to retrieve element attributes: img

  • tm1data task. Use an existing cube view, custom MDX or specify directly dimensions/elements to export IBM PA data in one click: img

  • TeamOne Explorer. Similarly to a cube viewer in IBM Planning Analytics Workspace, you can use the TeamOne sidebar UI to build IBM PA explorations and see the data directly in the sheets grid: img

Writing data back into IBM PA

  • tm1import task can be used to import Google Sheets data back into IBM PA: img

Comparing data

  • tm1datacompare task allows comparing of an existing tm1data task query results (a cube view, MDX or specified dimension elements\subset) in the same or different IBM Planning Analytics environment. img

A good use case would be to see if there is any data discrepancy "Before vs After" a release deployment or to compare data between 2 cubes from the same or different environments: img

IBM PA processes

On the Processes tab of TeamOne sidebar you see IBM Planning Analytics processes in the selected IBM PA server: img

You can also:

  • execute processes
  • rename or delete processes
  • compare code between 2 environments
  • deploy processes

Use the Target environment dropdown to select the second environment. img

The processes can also be easily added as tm1process tasks

tm1process task

tm1process task is used to run TI processes by specifying the process name, parameters and values directly in Google Sheets. By adding multiple tasks you to create one-click automations for different IBM Planning Analytics routines: img

IBM PA no code development

You can create, update and localize IBM Planning Analytics cubes, views, dimensions, hierarchies, elements, attributes and subsets without single line of code. img

You can manipulate with subsets expressions using MDX mods instead of the actual MDX. For instance, compare this MDX expression:

{FILTER( {TM1FILTERBYLEVEL( {TM1DRILLDOWNMEMBER( {[Period].[Period].[FY2022],[Period].[Period].[FY2023]}, ALL )}, 0 )}, [Period].[Period].[quarter] = "Q3" )}
{FILTER( {TM1FILTERBYLEVEL( {TM1DRILLDOWNMEMBER( {[Period].[Period].[FY2022],[Period].[Period].[FY2023]}, ALL )}, 0 )}, [Period].[Period].[quarter] = "Q3" )}

to the equivalent expression using MDX mods:


wildcard expressions are supported as well:


IBM Planning Analytics code

And you can even write and execute TI code directly in Google Sheets. You can use multiple prolog, epilog and comment blocks img

Or you can use the built-in TM1 console: img

User and group management

You can manage all your users and groups on a single sheet and TeamOne can sync it automatically with IBM PA server: img

For existing models TeamOne can genegate such security sheet for you and populate it with the existing users and groups.

Or you can edit users manually: img

You can see who is online, disable, enable, log off and delete users: img

You can even copy security groups between users: img

Use integrated TM1 top console to see what exactly is happening and cancel user session threads: img

Object security

You can define/document object security directly in Sheets, including cube security, dimension security, element security, application security, process security.

You can define IBM Planning Analytics objects on the rows and security groups on the columns. You can use one object per row or comma delimited list, or wildcard expression or MDX mods or real MDX or even mix all together: img

Search IBM PA model

You can open Model search screen from the main menu to search across cubes, processes and chores:


Message log

On the Logs tab you can see and search IBM PA server message log. Use the filter button to filter the records by date or containing some keywords:


Transaction log

Available to ADMIN users from the sidebar menu, using the Transaction Log viewer you can see and search IBM PA server transaction records. Use the query button to filter the records by cube, user, elements and time period:


Audit log

Available to ADMIN users from the sidebar menu, using the Audit Log viewer you can see and search IBM PA server audit records. Use the query button to filter the records by user, object type, description and time period:


Security tracer

Using TeamOne Security tracer you can quickly and easily troubleshoot users access and instantly get the full picture of the selected cube, dimension, hierarchy, element and data security. Simply select a user and a cube cell and TeamOne will show and explain the user's security level.


Compare models

Using Model compare screen can compare 2 IBM PA servers sides by side: img

and see the exact difference for model for processes, chores, rules and views:



You can select and promote multiple objects between the environments in both directions: