Relationships specify the connection between tables and enable you to pull data together in meaningful ways. For example, order information is more useful when you know which customer placed each order.

However you don’t need to store both the customer and order information in the same table. Customer and order data can be stored in two related tables with a relationship specified between the two tables to view each order and its corresponding customer information.

In practical terms relationships allow you to query and combine data from multiple tables in your dashboard.

To manually create a relationship between tables in the ElastiCube Manager:

  1. Locate the field within each table to specify the relationship. For example, two tables may both have customer ID.
  2. Ensure both fields that you are using to create the relationship are of the same type, for example decimal fields.

To check or change the field type, click the relevant field and a menu will appear listing the field type. Click on the drop down menu to change the field type.

Make sure the data contained within the field is compatible with the field type. For example, text data needs to have a field type of text.

  1. On the right side of the field click and hold down the ‘merge icon’ and simultaneously drag the link to the corresponding table until the mouse cursor is over the related field.
    The link will become green and a ‘Drop to merge’ message will appear when a relationship can be created. Let go the mouse button and a link between the two fields will appear.

To remove an existing relationship:

  1. Click on any part of the existing relationship. The line will become highlighted.
  2. An icon will appear, click Click to remove current selection.

Create and Remove Relationship

Image: Create and Remove Relationship

Image Item  Description
1. Manually create relationship
2. Remove existing relationship