Skip to content

Latest commit

 

History

History
129 lines (71 loc) · 5.26 KB

Kylin Cube Creation Tutorial.md

File metadata and controls

129 lines (71 loc) · 5.26 KB
Raw

Kylin Cube Creation Tutorial

I. Create a Project

  1. Go to Query page in top menu bar, then click Manage Projects.

  2. Click the + Project button to add a new project.

  3. Fulfill the following form and click submit button to send a request.

  4. After success, there will be a notification show in the bottom.

II. Sync up a Table

  1. Click Tables in top bar and then click the + Sync button to load hive table metadata.

  2. Enter the table names and click Sync to send a request.

III. Create a Cube

To start with, click Cubes in top bar.Then click +Cube button to enter the cube designer page.

Step 1. Cube Info

Fill up the basic information of the cube. Click Next to enter the next step.

You can use letters, numbers and '_' to name your cube (Notice that space in name is not allowed).

Step 2. Dimensions

  1. Set up the fact table.

  2. Click +Dimension to add a new dimension.

  3. There are different types of dimensions that might be added to a cube. Here we list some of them for your reference.

    • Dimensions from fact table.

    • Dimensions from look up table. 

      ![](https://raw.githubusercontent.com/KylinOLAP/kylinolap.github.io/master/docs/tutorial/8%20dim-typeB-2.png)

    • Dimensions from look up table with hierarchy.

    • Dimensions from look up table with derived dimensions.

  4. User can edit the dimension after saving it.

Step 3. Measures

  1. Click the +Measure to add a new measure.

  2. There are 5 different types of measure according to its expression: SUM, MAX, MIN, COUNT and COUNT_DISTINCT. Please be carefully to choose the return type, which is related to the error rate of the COUNT(DISTINCT).

    • SUM

    • MIN

    • MAX

    • COUNT

    • DISTINCT_COUNT

Step 4. Filter

This step is optional. You can add some condition filter in SQL format.

Step 5. Refresh Setting

This step is designed for incremental cube build.

Choose partition type, partition column and start date.

Step 6. Advanced Setting

Step 7. Overview & Save

You can overview your cube and go back to previous step to modify it. Click the Save button to complete the cube creation.

IV. What's next

After cube being created, you might need to:

  1. [Build the cube so that it can be queried](Kylin Cube Build and Job Monitoring Tutorial.md)
  2. [Grant permission to cubes](Kylin Cube Permission Grant Tutorial.md)