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:

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

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

• 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:

Writing data back into IBM PA ​

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

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.

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:

IBM PA processes ​

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

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.

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:

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.

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:

FY2022,FY2023>>expand>>level=0>>quarter=Q3

FY2022,FY2023>>expand>>level=0>>quarter=Q3

wildcard expressions are supported as well:

FY20*>>descendants>>level=0>>status=OP?N>>first=5

FY20*>>descendants>>level=0>>status=OP?N>>first=5

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

Or you can use the built-in TM1 console:

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:

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:

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

You can even copy security groups between users:

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

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:

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:

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

Deployments ​

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