Configuration settings for working with TM1 worksheet functions

You can configure server connection information and specify the sandbox to use when working with TM1® worksheet functions.

If IBM® Planning Analytics for Microsoft Excel does not recognize the TM1 server required by TM1 worksheet functions, you are prompted to select the host and server. The server connection information is saved to the CognosOfficeXLLSettings.xml file. On Windows 7, this configuration file is installed to Users\[user name]\AppData\Local\Cognos\Office Connection.

When you create a connection to a TM1 server to support working with TM1 worksheet functions, the default connection information does not identify a sandbox. To specify a sandbox, you must edit the connection information in the CognosOfficeXLLSettings.xml file to change the default sandbox setting from null to the sandbox name. The following is an example of a connection string showing the default sandbox setting.

<userSettings>
<setting name="ServerMap">{"Servers":[{"Name":"SData","RESTuri":null,
     "Sandbox":null}]}
</setting>
</userSettings>