Updating Cube Linkage for Individual Cubes

Before beginning this procedure, complete the steps in Before Updating Cube Linkage for Individual Cubes.

  To update the cube linkage for all cubes built using Essbase Studio:

  1. In Essbase Studio Console, select Tools, and then Update Cube Linkage.

  2. In Update Cube Linkage, ensure that Update selected Essbase application and database is selected.

    This default selection applies the new Essbase Studio Server that you specify (in the subsequent steps of this procedure) only to the selected Essbase cube.

  3. Under Essbase Connections, expand the applicable Essbase connection and application, and then select the Essbase cube whose linkages you want to change.

    You can update linkage only for cubes built by Essbase Studio. Cubes that have entries under Cube Linkage Essbase Studio Server and Cube Linkage Essbase Model are built by Essbase Studio and can be updated. Cubes with blank entries in those columns cannot be updated.

  4. Click Update to launch the Cube Linkage dialog box.

  5. Enter the new Essbase Studio Server name and port number in the following format:

    essbase_studio_server_name:port_number

    For example:

    aspen3:5300

    Tip:

    Essbase Studio remembers previously entered server name and port number combinations. If a desired combination is available in the drop-down list, you may select it.

    Note:

    Essbase Studio does not validate the server name and port number combinations that you enter. No error message is displayed if you enter this information incorrectly, and you will not see the error until you perform a cube deployment.

    Note:

    If you are updating cube linkage only because login information for the data source changed, you need not enter a new Essbase Studio Server name or port. Enter a new server name or port only to point to a new server or port.

  6. Select an Essbase model name from the list.

    You can also manually enter an Essbase model name. Ensure that the Essbase model name that you enter exists in the catalog associated with the Essbase Studio Server entered in step 5.

    Note:

    Essbase Studio does not validate model names that you enter. No error message is displayed if you enter this information incorrectly, and you will not see the error until you perform a cube deployment.

    Note:

    If you are updating cube linkage only because login information for the data source changed, you need not enter a new model name. Enter a new model name only to point to a new model.

  7. Click OK to return to Update Cube Linkage.

  8. For the selected cube, verify the entries under Cube Linkage Essbase Studio Server and Cube Linkage Essbase Model.

  9. Repeat step 3 through step 8 for all cubes that require updates.

  10. To exit, click Close.