Oracle by Example brandingUpdate an Oracle Analytics Cloud - Essbase Cube Using an Application Workbook

section 0Before You Begin

This 15-minute tutorial shows you how to do an incremental update of a single dimension in an Oracle Analytics Cloud - Essbase cube using a modified application workbook.

Background

You can modify an application workbook to use for incremental updates. To do this, remove worksheets you don't plan to change.

To update one dimension, first reduce the size of the workbook by removing worksheets that are not needed for the update, as shown in this tutorial.

What Do You Need?

  • Access to Essbase as a power user
  • Access to an Essbase cube built from the sample_dynamic_basic.xlsx application workbook
  • The sample_dynamic_basic.xlsx file, downloaded to your computer.
  • Microsoft Excel
  • Smart View
  • Cube Designer (a Smart View extension)

You need the following to connect to Essbase to support Cube Designer:

  • Service URL for the Essbase service
  • Connection from Smart View to the Essbase service
  • User name and password of a power user

section 1Remove Unnecessary Sheets from the Application Workbook

When you update a cube using an application workbook, you don't need to include unchanged dimension, data, calc, and query sheets. You can delete these unnecessary sheets to reduce the size of the application workbook, to improve processing time.

  1. Open sample_dynamic_basic.xlsx.
  2. On the cube designer ribbon, click Designer Panel and then at the bottom of the Designer Panel, click From Sheet.
  3. In the Designer Panel, on the Cube tab, delete every dimension except Product.
  4. On the Data tab, select Basic and press the Delete key.
  5. Click Yes to confirm.
  6. On the Calc tab, select calcall and press the Delete key.
  7. Click Yes to confirm.
  8. Navigate to the Query.Sample tab in the application workbook, right-click, and select Delete.
  9. Click Delete to confirm.
  10. Click To Sheet to update the application workbook.
  11. Click Save.

section 2Modify the Product Dimension Sheet

Remove the Diet product hierarchy and replace it with the Water Beverages product hierarchy.

  1. On the Dim.Product tab, in the Incremental Mode field, delete Merge and type Remove Unspecified in its place.
  2. Select all of the rows in the Diet product hierarchy and press the Delete key.
    diet hierarchy
    Description of the illustration diet_hierarchy.png
  3. Select all of the rows in the 400 product hierarchy and press Ctrl + C to copy.
  4. Move your cursor to the row directly below the 400 product hierarchy you copied, and press Ctrl + V to paste.
    fruit soda 400 hierarchy
    Description of the illustration 400_hierarchy.png
  5. In the copy of the 400 product hierarchy, change all of the 400s to 500s and change Fruit Soda to Water Beverages.
  6. Change Grape to Sparkling, Orange to Sparkling Lemon, and Strawberry to Sparkling Lime.
  7. Select the foreign language content under the ALIAS.languageNames column headings and press the Delete key to delete the content.

    Language represents a portion of the column names, for example, ALIAS.ChineseNames.

    water beverages 500 hierarchy
    Description of the illustration 500_hierarchy.png
  8. Press Ctrl + S to save the application workbook.

section 3Update the Cube

  1. In Excel, on the cube designer ribbon, click Build Cube.
  2. Log in with your Essbase power user credentials.
  3. In the Build Cube dialog box, accept the default to incrementally update the cube.
  4. Wait until you are notified that the job is complete, and click Yes to open the Job Viewer.
  5. Confirm that the build was successful by checking the Status column in the Job Viewer dialog box.
  6. Close the Job Viewer.

section 4View the Updated Cube in the Web Interface

Open the updated outline in the Essbase web interface and check your updates in the Sample_Dynamic.Basic outline.

  1. Log in to the Essbase web interface.
  2. On the home page, expand the Sample_Dynamic application and select the cube, Basic.
    expand sample dynamic
    Description of the illustration expand_sample_dynamic.png
  3. From the Actions Actions menu menu to the right of the cube name, select Outline.
  4. Expand the Product dimension, and expand 500.
  5. Verify that the outline reflects your updates.
    product dimension
    Description of the illustration expand_sample_dynamic.png

more informationWant to Learn More?