1. Using Oracle Essbase
  2. Design and Create Cubes Using Application Workbooks
  3. Create a Cube from an Application Workbook

Create a Cube from an Application Workbook

Import an application workbook to create an Essbase cube. Optionally, you can change the application name, select whether to load data and execute calculation scripts, and view dimensions to be created.

  1. In the Essbase web interface, on the Applications page, click Import.
  2. In the Import dialog box, select File Browser to browse to a sample application workbook you previously downloaded.
    You cannot import Excel files that contain spaces in the filename.
  3. Your application and cube names are populated based on the names you specified in the application workbook on the Essbase.Cube worksheet.

    • (Optional) You can change the application and cube names on this screen.

    • (Required) If an existing application in Essbase matches the name of the application you are importing, then you must ensure that the cube name is unique. For example, if the name of the application and cube in the Excel workbook is Sample Basic and Essbase already has a Sample Basic cube, then you’re prompted to rename the cube.

  4. (Optional) Choose a build option and whether to load data and execute calculation scripts.
  5. (Optional) Select View Dimensions, which allows you to view the mapping of workbook columns to the dimensions to be created.
  6. Click OK.
    The application is listed on the Applications page.
  7. View the outline:
    • In the Redwood Interface, open the application, open the database (cube), and then click Launch Outline.
    • In the Classic Web Interface, expand the application; then click the Actions menu to the right of the cube name, and launch the outline editor.

When you import an application workbook that was created using the command-line 11g Cube Export Utility, some member names might be rejected. See Review Member Names Before you Import an Application Workbook Created by the 11g Cube Export Utility.

If you import an application workbook and then export the cube you created to a new application workbook, the layout of the dimension sheets in the new application workbook might differ from the original, however the new workbook functions the same as the original workbook.