Changing websheet properties

Websheet properties determine how an Excel file displays and behaves when viewed as a websheet in TM1® Web.

All users can view websheet properties, but you must have Write access to an Excel file within an application to edit the websheet properties.

Note: You can manage websheet properties only by using Server Explorer, which is the user interface where you add Excel files to TM1 applications. The ability to manage websheet properties is not available directly in TM1 Web.

Procedure

  1. In the Tree pane of Server Explorer, locate the TM1 application that contains the Excel file for the corresponding websheet.
    Note: You can access Server Explorer from IBM® TM1 Perspectives or TM1 Architect.
  2. Right-click the Excel file and click Properties.

    The TM1 Web Properties dialog box opens, with two tabs:

    • General
    • Display Properties
  3. If necessary, click the General tab to change the general properties.
    TM1 Admin Hosts
    Shows one or more admin hosts to which your server was registered when you generated an Excel slice. You can be connected to one or more admin hosts, and specify more than one admin host. Delimit each entry in the list with a semicolon.
    Allow Write Back from Web
    Allows users to modify TM1 data by entering values in the websheet. Disable this option to make the websheet read-only.
    Print Properties
    Sets a limit on the number of pages users can print from this websheet. The system default is 100. You can set this number to any value that is appropriate for this websheet. For example, to set the maximum number of pages users can print to 110, in the Print Properties section, enter 110 in the Limit Number of Sheets to box.
  4. Click the Display Properties tab to change the display properties.
    Display Title Element Selectors

    Enable this option to display the Subset Editor buttons for title dimensions in the websheet. When this option is enabled, you can use the Display Selector option to selectively show/hide the Subset Editor button for individual title dimensions.

    Clear this option to hide the Subset Editor buttons for all title dimensions in the websheet.

    Title Dimensions

    The Title Dimensions grid lists all title dimensions in the websheet. The grid has the following columns:

    • Dimension - The name of the title dimension.
    • Address - The cell address of the title dimension in the websheet.
    • Display Selector - When the Display Title Element Selectors option is enabled, you can selectively show or hide the Subset Editor button for a title dimension in the websheet.

      To show the Subset Editor button for a title dimension, select the corresponding check box in the Display Selector column.

      To hide the Subset Editor button for a title dimension, clear the corresponding check box in the Display Selector column.