Websheet overview

A websheet is a Microsoft Excel worksheet (.xls file) with IBM®TM1® data that you can view in a web browser. By publishing an Excel worksheet from the IBM software to an application folder, other users can view your worksheet by using their Web browser.

With a websheet, you can perform the following tasks:

  • Enter data in cells to which you have Write access. The IBM web client does not identify which cells are writable, so you must have some familiarity with your data to successfully enter data into the websheet. For more information, see Editing data in a websheet.
  • Use data spreading to enter or modify many websheet values at the same time. Spreading is frequently used for scenario testing and what-if analysis during a budgeting or financial planning process.
  • Drill to relational tables or other cubes. If the slice that you publish to the Web contains a cell with a defined drill-through rule, that drill function is available from your websheet.
  • View Excel charts. If the slice you publish to the Web contains a chart, the chart appears in your websheet. If the slice from which you built the chart has a drill-through rule that is defined, you can drill through to related information from the websheet chart.
  • Manipulate title element subsets in the Subset Editor.
  • Display alternate hierarchies. You can view hierarchies in TM1 websheets, but you cannot create and manage hierarchies in a websheet.
Note: TM1 Web websheets support the accessibility features available in the Firefox browser. However, you should not enable any accessibility features in Chrome when using TM1 websheets. Enabling accessibility features in Chrome (chrome://accessibility/) can result in performance degradation. For more details on accessibility features in TM1 Web, see Accessibility features.

The following Microsoft Excel ActiveX controls are supported in websheets:

  • Check boxes
  • Combo boxes
  • List boxes
  • Radio buttons
  • Text boxes
  • Labels

Diagonal borders are not supported in TM1 websheets.

You can retrieve data from more than one TM1 database in a websheet. To successfully reference multiple databases in a websheet:
  • Only reports that use the VIEW function to retrieve data can reference multiple databases. Specifically, Custom Reports and Dynamic Reports use the VIEW function to retrieve data.
  • 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