Viewing relational data in TM1 Web

Removed in v2.0.8 You can view relational data in TM1 Web by running queries that were created in Microsoft Excel.

Note: You can format the data in TM1. However, you cannot write back to the relational database.

Procedure

  1. Start TM1 Web by typing the following URL:

    http://tm1_server_name:9510/tm1web

  2. Expand the application folder that contains the uploaded Excel worksheet.
  3. Open the worksheet.

    1. Before the TM1® Web server displays the worksheet, it checks the RDBMS account information against the proxy account information that was defined by your administrator.

      If this information matches, the worksheet is displayed in your TM1 Web window.

    2. If proxy account information is not found that matches the RDBMS account information, the TM1 Web server checks the RDBMS account information against your TM1 user name and password (Integrated Security mode 1 only).

      If this information matches, the worksheet is displayed in your TM1 Web window.

    3. If neither the proxy account nor your TM1 account match the RDBMS account information, you are prompted to enter a user name and password that matches that of the relational data source.

      If you enter a user name and password that matches that of the relational data source, the worksheet is displayed in your TM1 Web window.

      Note: After three failed attempts, an error message appears. If this occurs, talk to your administrator to get a valid username and password.