Creating Cube

Following are the steps to create a cube:

  • Click an existing domain which has access to source tables and the pipeline tables, which are required for the Cube design. These are the Fact and Dimension tables. Alternatively, create a new domain, and add the required source tables to it. The pipelines, cubes and workflows available in the selected domain, is displayed in the Domain page as shown below:
  • Click the Cube icon. The Cubes page is displayed with a list of existing cubes.
  • Click New Cube. The following page is displayed.

New Cube Field Description

FieldDescription
Duplicate Existing Cube

Drop-down.

Name of the required existing cube that you want to duplicate. If you want to create a new cube, select the Create New Cube option, that appears in the drop-down menu.

NameEnter the cube name.
DescriptionEnter description, if required.
Storage FormatSelect the required format in which the cube tables must be stored (ORC or Parquet).
HDFS PathThe star schema for the cube model will be saved on HDFS.
Hive Schema NameEnter the schema name where the tables will be stored.

Enter these details, and then click Save. The list of cubes created in the domain will be displayed.

Type to search, ESC to discard
Type to search, ESC to discard
Type to search, ESC to discard