ElastiCube Manager

Before you can analyze dashboards, you need to add data to an ElastiCube and then build it in the ElastiCube. The ElastiCube Manager is a visual environment where you can import and structure multiple data sources, create relationships between data, and perform ETL (Extract, transform, and load) processes to prepare data for analysis and visualization.

The topics below describe how to access the ElastiCube Manager and how to navigate its interface.

Accessing the ElastiCube Manager

Navigating the ElastiCube Manager

Accessing the ElastiCube Manager

You can access the ElastiCube Manager through the Data tab displayed at the top of the Sisense Web Application.

Only users with Administrator or Data Administrator privileges can see the Data tab.

There are two ways from the Data page to access the ElastiCube Manager, by creating a new ElastiCube or by editing an existing ElastiCube.

For more information about ElastiCubes, see Managing ElastiCubes from the Data Page.

To access the ElastiCube Manager:

  1. In the top of the Sisense Web Application, click Data. The Dashboard list is displayed.
  2. For new ElastiCubes, click .

For existing ElastiCubes, click the relevant ElastiCube.

The schema is displayed.

Navigating the ElastiCube Manager

The first time you create an ElastiCube, its empty until you start adding some data. Once you move some data into the ElastiCube, its represented in the ElastiCube in circular nodes. Each node is a table. The color and size of the table reflects its source and how big the data is in relation to your other tables. So, a small table from one data source will appear as a small circle in a color and another large table from a different source will appear large and in another color. For example:

The Conditions time of stay table is from a custom table and is smaller than the Admissions table that is from a CSV file.

The ElastiCube Manager contains a variety of information and functionality that lets you prepare your data model as needed. A sample screen is shown below.

  1. Navigation Pane: This area contains a list of your tables and their columns. On the left side of the table name is an icon that indicates what type of data is included, Date, Numeric or Text. On the right side is a join icon when the column is connected to another table.
    See Finding Tables and Fields more information.
  2. Schema: The schema contains your data model that represents all the data to be added to the ElastiCube and the relationships between the table. Some of your tables might appear with icon attached them. These indicate the status of your build and table. For example, indicates that the table has changed since the last ElastiCube build while indicates that a custom expression is currently in draft mode. See Working with Data for more information.
  3. Schema Menu: This menu lists the following buttons:
    Data: Click to add a new table to your ElastiCube.
    Custom: Click to add a custom table to your ElastiCube.
    Relationships: Click to open a preview window where you can join two tables. See Creating Relationships for more information.
    Build: Click Build or Build Changes to initiate an ElastiCube build.
    : Click these buttons to undo or redo any recent changes to your schema.
  4. Legend: The legend lists a description of all your data sources in the ElastiCube and the color that represents them in your schema.