Navigating the Model Editor

The first time you create an ElastiCube or a Live data model, it's 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, it's 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 node reflects 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. An example is shown below.

  1. Navigation Pane: 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.
    For more information, see Finding Tables and Columns.
  2. Schema: The schema contains your data model that represents all the data to be added to the ElastiCube and the relationships between the tables. Some of your tables might appear with icons attached to them. These indicate the status of your build and table. For example:
    • indicates that the table has changed since the last ElastiCube build
    • 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: Add a new table to your ElastiCube.
    Custom: Add a custom table to your ElastiCube.
    Relationships: Open a preview window where you can join tables. See Creating and Removing a Relationship between Tables for more information.
    Build: Initiate an ElastiCube build.
    Undo/Redo: Undo or redo any recent changes to your schema.
  4. Legend: A description of the data sources in your ElastiCube, and the color that represents them in your schema.