Create a Universal Report when connected to multiple sources

You can now create a Universal Report while connected to multiple databases or datasources.

In previous versions of Planning Analytics for Microsoft Excel, this action would cause the Universal Report to fail.

There are three cases in which a Universal Report continues working while you are connected to multiple databases or datasources:

  • If you are signed into one datasource and one server, the TM1PRIMARYDATASOURCE() and TM1PRIMARYDBNAME() functions are used respectively.
  • If you are signed into one datasource and multiple servers, the datasource will use TM1PRIMARYDATASOURCE() and the server is set to the active server.
  • If you are signed into multiple datasources and multiple servers, TM1PRIMARYDATASOURCE() and TM1PRIMARYDBNAME() are set to the active datasource and server.

To learn more about creating a Universal Report, see Create a Universal Report from scratch.