Change the model and cube used by a Dynamic Report

Update the cube and datasource of a Dynamic Report to switch from a test to a production environment, for example, or to access information from a different set of financial data, such as a submission.

You need to update the formulas in the Dynamic Report to reference a new cube or datasource. If your formulas reference cells to obtain the cube and datasource name, you will need to update the referenced cells.

You need to modify the following formulas:
  • TM1RPTVIEW
  • SUBNM formulas for context members
  • TM1RPTROW for the first row title member
  • DBRW formulas for the cells in the data area
Note: You may need to unhide the rows to reveal the format range.

The first parameter of the TM1RPTVIEW formula specifies the model and cube name to use in the Dynamic Report. Make the TM1RPTVIEW formula visible by revealing the format range for the Dynamic Report so that you see the server name and data source name. Edit the TM1RPTVIEW formula to use a different server and data source. For more information on revealing the format range, see Report format.

Context members are defined by SUBNM formulas. The first parameter of each SUBNM formula specifies the model and cube name. Modify the SUBNM formulas to use the new model and cube.

Row title members are defined by a TM1RPTROW formula in the first row title. The second parameter of the TM1RPTROW formula specifies the model and cube name. Modify the TM1RPTROW formula to use the model and cube.

Cells in the data area are populated by DBRW formulas. The first parameter of a DBRW formula specifies the model and cube name. Modify the formulas to use the new model and cube name. Or, if the DBRW formulas reference a cell containing the model and cube name, update the referenced cell.
Tip: You can modify DBRW formulas in a range of cell by using the Function Editor. For more information, see Modify a range of DBR and DBRW functions.

Alternatively, return to the Exploration View that you used to create the Dynamic Report, change the model and cube name, and then convert the Exploration View to a Dynamic Report.