Navigating the Model Editor

The first time you create an ElastiCube or a live data model, its empty until you start adding some data. Once you connect to your data source and select what data is going to be imported or queried, its represented in Sisense as circular nodes. Each node is a table. The color of a node is determined by its data source, for example, data imported from a CSV file is one color while data imported via SQL is another. The colors of the data source are described in the legend on the bottom right of the editor.

The size of the table reflects the number of relations and the number of columns the table has. So, a table with several relations and a lot of columns will be larger than a table with a single relation and fewer columns. For example:

The ‘Conditions time of stay’ table is a custom table with a single relation and the ‘Admissions’ table contains data from a CSV file and has four relations.

The Model Editor 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 to initiate an ElastiCube build.
    Undo/Redo: 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.