Install the Smart View Cube Designer Extension

You can install Cube Designer either from Smart View or from the Console in the Essbase web interface.

Before you perform this procedure, you must complete the steps in Connect to Essbase.

Install Cube Designer from Smart View

  1. On the Smart View ribbon, select Options, and then Extensions.

  2. Click the Check for updates link.

    Smart View checks for all extensions that your administrator has made available to you.

  3. Locate the extension named Oracle Cube Designer and click Install to start the installer.

  4. Follow the prompts to install the extension.

    Note:

    • This method is for installing or updating an existing Cube Designer installation. To downgrade, uninstall and then install again.
    • Oracle recommends that you install Cube Designer by downloading from the Essbase web interface and running the .svext file.

Install Cube Designer from Essbase web interface

  1. In the Essbase web interface, on the Home page, click Console.

  2. Navigate to the Cube Designer download option:
    • In the Redwood Interface, select Desktop Tools, expand Smart View, and click the Download icon on the Cube Designer Extension tile.
    • In the Classic Web Interface, on the Desktop Tools tab, to the right of Cube Designer Extension, click Download .
  3. Follow the steps for your browser to download the Cube Designer installer, and save it to a folder on your computer.

  4. Close all Microsoft Office applications and make sure Microsoft Office applications are not running in the background.

  5. Double click the installation file.

  6. Restart Microsoft Office applications.

Connect to Essbase from Cube Designer

  1. Create a private connection to the Essbase Server from Smart View.

    After you do this, the private connection will be available in the Connections dialog box.

  2. On the Cube Designer ribbon, click Connections Image of the Cube Designer ribbon connections icon.
  3. In the Connections dialog box, select your Essbase URL and click Save.

    This saves the Essbase URL as your default Essbase connection. To switch to a different Essbase instance, repeat the steps, using the new URL.

Set WebView2 to Enable for UI from Smart View

Cube Designer works correctly only when the WebView2 Runtime is either enabled for UI or completely disabled. To make the necessary changes to the WebView2 Runtime settings in Smart View:

  1. Open Excel and go to the Smart View ribbon.
  2. Click the Help dropdown menu and select Health Check.
  3. Under Smart View Options, locate WebView2 Runtime.
  4. In the Tab section, ensure that WebView2 is set to Enable for UI, or use the Fix/Update/Info dropdown menu next to WebView2 and select Enable for UI.
  5. Click Update Settings, then restart Excel.