Active Forms in TM1 Web

If a Microsoft Excel worksheet containing an Active Form is added to TM1® applications, the Active Form 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 Form 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 Form from ServerA and one Active Form 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.