Active Forms in TM1 Web

If a Microsoft Excel worksheet containing an Active Form is added to TM1® applications, the Active Forms can be accessed in TM1 Web through the corresponding websheet.

The following two new buttons are on the websheet toolbar to simplify working with Active Forms.

Button Name Purpose

Rebuild button

Rebuild

Rebuilds the Active Forms according to the form definition in the TM1RPTVIEW function.

Column Resize button

Column Resize

Widens the column in a websheet to display all cell data. Select the column and click the button.

Note: If an Excel worksheet contains multiple Active Forms that originate from more than one TM1 Server, your username/password combination must be identical on all servers to successfully view the corresponding websheet.

For example, if a worksheet contains one Active Forms from ServerA and one Active Forms from ServerB, the username/password combination you use to access ServerA must be identical to the username/password combination you use to access ServerB to successfully view the Active Forms in a single websheet. If your username/password combination is not identical on all TM1 Servers represented in a websheet, the websheet will display incomplete data.