Change the cube and datasource of Custom Reports

Update the cube or datasource that formulas reference to switch from a test to a production environment. For example, you can update the cube or datasource to access information from a different set of financial data, such as a submission.

Procedure

  1. From the worksheet you want to update, log on to the datasource and select the datasource.
  2. To update all formulas in the report, do one of the following steps.
    • If you are working with a Custom Report that you created from an Exploration View, edit the Cube in the information area above the report. Use the format server:cube. server represents the name datasource containing the cube and cube is the name of the cube.
      Note: You may need to unhide the rows to reveal the format range. For more information on revealing the format range, see Report format.
    • If you are working with a Custom Report that you created manually, modify the cells where you defined the server name and the cube name.
  3. To update specific formulas, locate the formulas and modify the server:name parameter.
    Tip: Use the Microsoft Excel search and replace function to update embedded references in the text of cell formulas.