Retrieve data from multiple TM1 databases in a websheet

You can now retrieve data from more than one TM1 database in a websheet. Limitations to this ability that were present in previous releases have been removed.

Planning Analytics SC 2.0.62 introduced the ability to retrieve data from multiple TM1 databases in a websheet, but imposed two limitations:
  • all databases referenced in a websheet had to be registered on the same Admin host
  • you could use multiple TM1 databases in a websheet only on Planning Analytics Local

These limitations have been removed. A websheet can now reference databases that are registered on different Admin hosts. You can also retrieve data from multiple TM1 databases in a websheet on both Planning Analytics Workspace Local and Planning Analytics on Cloud.

You can retrieve data from multiple databases only in Custom Reports and Dynamic Reports, which use the VIEW function to retrieve data.

To successfully reference multiple databases in a websheet:
  • Database names must be static; computed database names are not supported.
  • All databases must be configured to use the same authentication mode.
  • Users must have common credentials across databases.

If one of the referenced databases is not running or a connection cannot be established, you will see an error in the websheet.

Authentication error

You can learn more about websheets in the Websheets overview.