Adding a Custom Table

With Sisense , you can easily create custom tables that can combine existing data. This is useful for preparing and cleansing data. Follow the steps below to learn how to add custom tables using SQL.

For a short video overview of adding a custom table to your data model using SQL, see below:

To create a custom table:

  1. In Sisense , open the schema of the ElastiCube you want to add to a custom table to.

  2. In the menu bar of the schema, click . The New Custom Table area is displayed.

  3. Enter the name of the custom table, and click .

  4. Enter SQL statements to access tables and fields that exist in the Sisense schema. See also SQL Reference and Functions Overview.

  5. To view results based on the SQL statement, click .

    Note:

    You can save an incomplete or invalid SQL expression, however when you build the ElastiCube . only the last valid expression will be included. If you have not built an ElastiCube with a valid expression, then the invalid or incomplete expression will not be saved.

  6. Click Save to save your changes.

Limitations

  • Builds with custom tables using full outer joins are not supported

Tip

  • Press Ctrl + Space to complete an SQL statement.
  • To make it easier to access table fields, give the table name an alias and reference the alias to bring up the related fields. For example SELECT A. FROM A.
  • You can add comments in expressions by using the ‘–’ for a single line or /…/ for blocks.

.r.