Selecting dimension title elements for Websheet objects

You can set the current elements in a title dimension of a Websheet object for any cell that contains a SUBNM function.

You can specify the dimension by either sheet number, row number, and column number or by dimension name.

You can select the new element by either element name or element index.

Format and values

Use the following format to specify the dimension by sheet, row, and column number:

Title_S#-R#-C#=elementNameOrIndex

Use the following format to specify the dimension by dimension name.

Title_dimensionName=elementNameOrIndex

Use the following parameters:

Title_S#-R#-C#
Specifies the title dimension by sheet number, row number, and column number.

Replace the # symbols with the values for the sheet, row, and column location of the dimension SUBNM cell in the Websheet.

Title_dimensionName
Specifies the title dimension by dimension name.
elementNameOrIndex
The string value for the name or numeric value for the index of the new title element that you want to select.

If you want to select the new title element by element index, instead of element name, include the UseIndex parameter in the URL as follows:

Title_S#-R#-C#=ElementIndexNumber&UseIndex=true

Example

Use the following example to first open a Websheet and then change the title element.
  1. Copy and paste the following URL directly into the address bar of your web browser to first open the Websheet.

    http://localhost:9510/tm1web/UrlApi.jsp#Action=Open&Type=WebSheet&Workbook=Applications/Planning%20Sample/Management%20Reporting/Actual%20v%20Budget&AdminHost=localhost&TM1Server=Planning%20Sample

  2. To change the title element, copy and paste the following URL into the same web browser session.
    http://localhost:9510/tm1web/UrlApi.jsp#Title_S0-R11-C2=Canada
  3. Copy and paste only the Title_S#-R#-C# parameter to the end of the base URL to get the similar results.
    Tip: Only the parameter section of the URL needs to be updated when you use parameters to apply changes. The base URL can remain unchanged.
    Title_S0-R11-C2=US
  4. Use the following sample with the UseIndex parameter to select a new title by element index.
    Title_S0-R11-C2=3&UseIndex=true