Skip to Main Content

Breadcrumb for learning path

Main Parent

Learning Path Details Parent

bubbles_banner

Information

learning_path_info

Use Cube Designer to Build and Modify a Sample Cube

In this learning path, you learn to install required components, build an Oracle Analytics - Essbase cube from a sample application workbook in cube designer, and perform an incremental cube update using a modified sample application workbook.

Enroll the User-Public

Learning_path_filler

Learning_path_icons

beginner Beginner
duration 36 Min
modules 4 Modules

Learning Path Contents

Module Sections Topics and more

  • Before You Begin
      duration 0 Min
    In this Learning Path, you'll learn how to install Smart View, create private connections from Smart View to Oracle Analytics Cloud - Essbase, and install cube designer, a Smart View extension. Then you'll learn how to build a sample Oracle Analytics Cloud - Essbase cube in cube designer using an application workbook. Finally, you'll learn to perform an incremental update of the sample cube you created using a modified application workbook. Modifying the workbook to remove unneeded dimension, data, query, and calculation sheets can improve processing time.
     
    Hide
    Get Access to Oracle Analytics
    • To complete the tutorials of this learning path, you need access to Oracle Analytics as a service administrator.

      Need access? Use free credits to try Oracle Analytics.

  • Install Components and Create Connections
      duration 11 Min
    Before you can build and modify the sample cube in cube designer, you’ll need to install Smart View, create private connections from Smart View to Oracle Analytics Cloud – Essbase, and install cube designer. Cube designer is a Smart View extension.
     
    Hide
  • Build a Sample Cube
      duration 10 Min
    You’ll build a sample cube in cube designer using a sample application workbook. An application workbook is a structured Microsoft Excel workbook that contains the information needed to build a cube.
     
    Hide
  • Modify the Cube you Created
      duration 15 Min
    You'll modify the sample application workbook and upload it to change one dimension in the cube you created. You’ll modify the Product dimension sheet to add a new product group, and then you’ll remove some sheets in the workbook that remain unchanged.
     
    Hide