Create a Cube Table in the Physical Layer

Manually create a cube table in the semantic model's physical layer when you can't import a multidimensional cube table.

Note:

Oracle recommends that you import cube tables rather than manually creating them.
If you manually create cubes, you must build each cube one hierarchy at a time and test each hierarchy before building another. For example, create the time hierarchy and a measure and then test the hierarchy. Then when the cube is correct, you create the geography hierarchy and test it. Creating and testing the cubes you create manually in this sequence ensures that you've set up each cube correctly, and helps you identify any errors as you add each element to the cube.
See What Are a Physical Table's General Properties?, Create a Cube Dimension, and Set a Measure Column's Properties.
  1. On the Home page, click Navigator and then click Semantic Models.
  2. In the Semantic Models page, click a semantic model to open it.
  3. Click Physical Layer Physical layer icon.
  4. In the Physical Layer pane click Create Create icon and then click Create Cube Table.
  5. In Create Cube Table, go to Name and enter a table name. Then go to Location and browse for and select a location for the new table.
    For Essbase cube tables, expand an Essbase physical database and then browse for and select a catalog to add the cube table to.
  6. In the new table's tab, click General and specify the table's properties.
  7. Click Dimensions and add dimensions and hierarchies to the table, and click Measures to add measures to the table.
  8. Click OK.
  9. Click Save.