Check out our LinkedIn page and YouTube playlist for TeamOne demos and tutorials.
TeamOne can be added to Google Sheets™ from Google Workspace Marketplace™ (registered trademark owned by Google LLC ) by following this link. Our clients do not have to buy a Google Workspace™ subscription. It can work even with a free account. Though if you have a paid plan, you will be able to install TeamOne for all your users at once.
IBM PA Local only. To prevent SSL warnings in your browser we recommend configuring a custom SSL certificate (signed by a trusted certificate authority) for your TM1 server. Here are the IBM instructions for How to Configure SSL on IBM Planning Analytics
You can find TeamOne under the Extensions menu. It contains options to open the TeamOne Sidebar, TeamOne Configuration, TeamOne Getting started, access additional tools and see the About page which displays the current add-on version and your license information.
TeamOne Getting Started
TeamOne Getting Started describes the main TeamOne features, provides a built-in TeamOne documentation search, allows adding new IBM Planning Analytics connections and contains useful TeamOne links:
You can manage TeamOne add-on settings either in TeamOne Configuration or on a sheet named TEAMONE. Using TeamOne Configuration you can define personal, document and domain IBM PA connections and tasks. And using the TEAMONE sheet you can make the settings dynamic, for instance you can add a tm1process task and calculate the process parameter values with sheets formulas.
You can define private IBM PA connections and private tasks in My Settings. Personal Settings are stored in your Google account and they are shared for all your Google Sheets documents where you use TeamOne add-on. No other users can see these settings. You can copy and move settings:
Document Settings are stored in the current Google Sheets document properties and available to all users, but only Admin users can see and edit these settings.
Domain Settings are available to all corporate accounts, but only designated domain administrators can see and edit these settings:
You can also specify the permissions and list the users who can use each IBM PA connection:
You can define TM1 connections and tasks directly on TEAMONE sheet. You can use Sheets formulas, copy\paste settings, comment out individual settings or entire settings blocks.
If you have the same named Personal, Document, Domain and TEAMONE sheet settings, they will be merged in the next order:
- Domain Settings
- Document Settings
- Personal Settings
- TEAMONE sheet
For instance, as an admin user, I would like to define a new IBM PA connection named IBM Cloud PROD in the Domain or Document Settings, this is where I would define the server host, port and namespace (in case of CAM authentication). Then other users can also define IBM Cloud PROD connection in their Personal Settings, but populate the username/password fields only. Finally on TEAMONE sheet we can aslo define IBM Cloud PROD connection and specify a different value for the securitySheet. When opening TeamOne Sidebar, all the settings will be merged, so IBM Cloud PROD connection will get the host, port and namespace from the Domain or Document Settings, the secret from the Private Settings, finally the securitySheet value defined on the TEAMONE sheet.
By default you have no security defined when you start using TeamOne add-on in a new Google Sheets document. That means all users can see the Document Settings and change the Security. On the Security tab you add user emails and specify who should have Admin permissions. Once you added your first account, other users will not be able to edit the Document Settings and Security tabs, unless they are added on the Security tab with Admin permissions.
Use Google Sheets sharing options to specify who can see your document and who can edit it. You can also use Protected sheets and ranges to control who can modify the TEAMONE config sheet.
You will need at least one IBM PA connection. As mentioned above, you can define it in TeamOne Configuration or in TEAMONE sheet. The connection consists of the next parameters:
- -name (how it will appear in the connection list, it can be different from the actual TM1 server name)
- -host specify your TM1 server host FQDN
- -port should be equal to HTTPPortNumber in tm1s.cfg file, you can ommit this parameter if using 443 (for HTTPS)
- -server (IBM Planning Analytics Cloud only) specify your TM1 database name, case sensitive!
- -proxy (IBM Planning Analytics Cloud only), a special setting for paid clients to specify TeamOne proxy server to improve the PA Cloud connection speed. Leave it empty if you have a free TeamOne license.
- if using IntegratedSecurityMode 4 or 5 specify the -namespace configured in Cognos Analytics (usually "LDAP"). Use "LDAP" for IBM Planning Analytics Cloud connections (as it requires a non-interactive user account).
- When creating or updating TM1 connection in TeamOne Configuration, you can specify your TM1 -username and password, TeamOne will automatically generate and store the corresponding secret. Otherwise you can use Extensions > TeamOne > Tools > Secret maker menu to generate a base64 encoded -secret and set it manually.
See how you can add ::tm1env definition to TEAMONE sheet.
You can also use securitySheetName parameter, which will enable users, groups and permissions synchronization from the specified sheet. You can read more about this feature on the Users page.
When connecting to TM1 server, TeamOne will check if user account has ADMIN security group and if yes, you will enable additional functionality in the sidebar, like Users, Logs and Processes tabs or TM1 console, TM1top and Compare models menu options.
Planning Analytics Cloud connection
To connect to IBM Planning Analytics Cloud please use the welcome kit document provided by IBM. First of all you will need your IBM Planning Analytics Workspace URL which usually looks like: YourCompany .planning-analytics.ibmcloud.com You should use this URL for the -host connection parameter.
Then you will need to find your -server name, which is basically your TM1 server name which you see in the PAW database list. Please note, the server name is case sensitive!
Finally you should specify the -namespace connection parameter as LDAP and use a non-interactive user account credentials provided in the welcome kit:
So in the end your connection should look like this:
If you are located outside of North America, you can significantly increase the connection speed between TeamOne and IBM Cloud using the -proxy connection parameter. Please contact us to get the proxy URL for your geographic region.
You can access TeamOne Sidebar from Extensions menu. If you have no TM1 connection defined, TeamOne Configuration screen will pop up automatically where you can add one.
The sidebar toolbar allows you to select the current environment, refresh the config (if you made any changes on TEAMONE sheet or in Configuration menu) and do several quick actions from the main menu:
- Search TM1 model
- Compare models
- Update security, if you defined a server secruity sheet
- Save data on TM1 server
- Open TI console
- Open TM1 Top
- Open TeamOne Configuration
Configuration is automatically reloaded when you open TeamOne sidebar. After you make any changes on TEAMONE sheet or through TeamOne Configuration, you should use the Refresh config button: