Kubes - Analytical Cubes

What is a Kube?

Kubes are Data Models or the metadata layer that helps DataKubes understand how data is structured in the databases it manages. This includes precise details about the tables that hold related data, as well as the types of fields present in those tables. This methodology enables a more comprehensive and organized representation of the information stored in the database, facilitating a precise understanding of how data is interconnected and structured across various tables, as well as the nature of the fields within them.

How to Create a Kube

To create a Kube, follow these steps:

Step 1: From your Orchestrator's Home page, select the Kube tool. You can choose either of the two options indicated in the image.

Kube Tool

Step 2: You will then be taken to a new window where you can see all the Kubes you've created listed, along with the repository they are located in. To create a new Kube, click the + button.

Create Kube

Step 3: A new screen will open for pre-configuration, and you should fill it in with the relevant information.

Configure Kube

The following table explains each section of the form in more detail:

RepositorySelect the repository from which the data will be used to create the new Kube.
TypeChoose between Realtime Kube or DataWorkshop Object. Realtime Kubes allow you to join multiple tables and select the data you want to display, while DataWorkshop Objects represent objects from DataKubes Workshop that run code in cloud computing and display their output in an output file saved by the object.
NameEnter a name for your Kube.
CategoryOptionally, you can assign a category to your Kube, which helps you organize the Kubes in your repository.
SubcategoryThis section is optional, and you can add a subcategory to your Kube if desired.
DescriptionOptionally, you can add a description for your Kube.

Step 4: Click the SAVE button.

Step 5: Next, you will continue configuring your Kube, where you will first see the Properties section that was configured in the previous step.

Kube Properties

Step 6: Select the Tables option. Here, you will choose the primary table for your Kube, which comes from the repository you selected earlier.

Select Primary Table

Step 7: If you want to organize more data within your Kube, select the ADD TABLE button.

Add Table

Step 8: Choose the table you want to relate to the primary table.

Select Related Table

Step 9: Select the type of JOIN you want to perform between the two tables.

Select JOIN Type

The following table provides more detailed explanations of the JOIN types:

Join TypeDescription
JOINTakes common elements in both tables and displays only those elements that match in both.
LEFT JOINTakes all elements from the first table and looks for matches in the second table. If there are matches, they are displayed along with the information from the first table. If there are no matches in the second table, the fields remain blank.
RIGHT JOINRIGHT JOIN works similarly to LEFT JOIN, but in this case, all rows from the right table are included in the final result along with the matching rows from the left table. If there are no matches in the left table, null fields are shown for those records. It's like taking all the items from the right list and finding their matches in the left list, but if there are no matches, blank spaces are shown.

Step 10: After that, you should click the ADD RELATIONSHIP button and select the two columns that will be used as references for the JOIN.

Add Relationship

Step 11: Then, select the Fields option and click the ADD MULTIPLE FIELDS button to add columns to your Kube.

Add Fields



This function only works the first time you add columns massively to the Kube.

Step 12: Select the columns you want to add and click ADD.

Select Fields

Step 13: If you want to add another column, click the + TABLE FIELD button and select the column you want to add, as in the previous step.

Add Another Field

Step 14: If you want to add a field with a special function, such as performing a calculation or having a singular value, click the + SQL FIELD button. After adding the field, enter a Field Name, and click the f(x) VIEW SQL button.

Add SQL Field


Remember to Reload when Changing Fields

Currently, the DataKubes Kube designer needs to be reloaded to load the report fields in the various necessary options. Therefore, we recommend pressing the "Reload Fields" button when making changes.

Step 15: A screen will then open where you can write the function of the field or the SQL value. Afterward, click the APPLY button.

Configure SQL Field


Variable "COUNT"

It is recommended to add an SQL-type variable named COUNT with a value of '1'. This helps count each record in the cube, depending on the field configuration.

Step 16: To configure each field, click the ⚙️ button.

Field Configuration

Step 17: You can configure the Field Count type if you want a grouper for sum, count, average, and more. You can also choose how data is displayed with Value Formatting.

Configure Field Count and Formatting

Step 18: Select