Publishing TM1 Applications to TM1 Web

All references to cubes, views, files, and URLs in IBM® Cognos® TM1® applications are automatically available in TM1 Web.

As of IBM Cognos TM1 version 10.2, to view a Microsoft Excel worksheet as a Websheet in Cognos TM1 Web, the file must be in the .xlsx or .xlsm format for Microsoft Excel 2007 or later.

Assume North American Sales is a public application that contains references to a collection of TM1 objects and Excel files. When you access the sdata IBM Cognos TM1 server through TM1 Web, these references are displayed under Applications.

When working in TM1 Web, you can click on a reference to open and display it as follows:

  • Cubes and views display directly in TM1 Web.
  • Excel files display as TM1 Websheets directly in TM1 Web.
    Note: Excel files that have been protected through the Excel command, Tools, Protection, cannot be accessed through TM1 Web.
  • Non-Excel files open and display in their associated program.
    Note: Some file types and programs may not be viewable from TM1 Web.
  • URL references open and display in a separate web browser.

For example, click on an Excel file to open it in TM1 Websheet format.

Note: TM1 determines the column widths of the Websheet based on the Excel file from which the Websheet is generated. If the columns in the Excel file do not accommodate the full display of row and column labels, the corresponding labels in the Websheet are truncated.

You can access both public and private applications and references through TM1 Web. Only the user who creates a private application or reference can access the item through TM1 Web. Access to public applications and references in TM1 Web is determined by the security privileges defined for the source applications and references on the TM1 server. For details on setting security privileges, see Assigning Security Privileges for TM1 Applications and References to User Groups.