Map fields

When you create an action button that navigates to another worksheet, you can manually map fields between the source worksheet and the target worksheet. You can map dimensions, cells, and values from the source worksheet to the target worksheet.

Note: Manual mapping is applied after any automatic mapping has been applied by the Match Title Elements option.

To map fields, click Advanced options on the Navigate tab in the Action button properties dialog box.

The Advanced options dialog box includes a grid where you define the mapping of fields between the source and target worksheets. Use the Add and Delete buttons to manage the rows in the grid.

You map the source worksheet to the target worksheet by setting values for the source type, source object, target type, and target object in the Advanced Mapping grid.

Use the following steps to configure advanced mapping:
  1. Indicate the type of object to map by setting the Source Type.
  2. Determine the value for the type of object you are using by setting the Source Object.
  3. Indicate the type of cell to map by setting the Target Type.
  4. Indicate where to insert the value from the source object by setting the Target Object.
  5. Repeat these steps to create more mapping configurations.
Source Type
The Source Type field represents the type of object for the value you want to map.
  • SUBNM - Indicates that you are mapping from a cell that contains a title dimension in the source worksheet.
  • Selected DBRW - Indicates that you are mapping from a cell that contains a DBRW formula in the source worksheet.
  • Value - Indicates that you will enter a string or numeric value to send to the target worksheet.
Source Object
The Source Object field takes a value, or a Microsoft Excel expression that evaluates to a value, depending on what you selected in the Source Type field.
  • If Source Type is set to SUBNM, specify the name of the title dimension that exists in the source worksheet.
  • If Source Type is set to Selected DBRW, specify the name of a row or column title dimension that exists in the source worksheet.
  • If Source Type is set to Value, enter a string or numeric value to send to the target worksheet.
Note: You can also retrieve these values from the source worksheet by using a cell reference or a named range.
Target Type
The Target Type field specifies the type of cell in the target worksheet where the value from the Source Object field will be inserted.
  • SUBNM - Indicates that the target is a title dimension in the target worksheet.
  • Named Range - Indicates that the target is a named range in the target worksheet.
  • Range - Indicates that the target location is a cell in the target worksheet.
Note: If you set Target Type to either Named Range or Range, any pre-existing data or formula in the target cell will be overwritten when you click the action button. If the target cell contains a DBRW function, then the function will be lost and the cell will not be able to connect to, read from, or write to the IBM® TM1® server.
Target Object
The Target Object specifies the location in the target worksheet where the value from the source object will be inserted. This location can be the name of a title dimension, a specific cell location, or a named range in the target worksheet, depending on what you selected for Target Type.
  • If Target Type is set to SUBNM, specify the name of the title dimension in the target worksheet. When Target Type is set to SUBNM, you must also enter a value for the Subset and Alias fields.
  • If Target Type is set to Named Range, specify the name of the range in the target worksheet.
  • If Target Type is set to Range, specify the cell location in the target worksheet.
You can enter a value for the target object by entering the location value directly. Or, you can use a cell reference or a named range to retrieve the location.
  • Entering a value directly: To identify a location in the target worksheet, enter the value directly into the Target Object field without the equal sign =. For example, enter C3 to identify the location of the target object as the cell C3 of the target worksheet.
  • Using a cell reference or a named range: To reference a cell in the source worksheet that contains a location for the target object, include the equal sign =. For example, the cell A1 in the source worksheet might contain the value C3 to represent the cell location for the target object in the target worksheet.