Retrieve data from multiple TM1 databases in a websheet (Planning Analytics Workspace local only)

You can now retrieve data from more than one TM1 database in a websheet.

All databases referenced in a websheet must be registered on the same Admin host. 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.

You can learn more about websheets in the Websheets overview.