Adding Custom Tables

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.

Watch this video about custom tables and columns:

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 Quick Reference and Data Functions for Custom Tables and Fields.

  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.

Adding Custom Tables for B2D

For B2D, you must select a dialect for the destination database:

  1. Click +Custom to add a custom table after the first complete build, and give it a name.
  2. Select the language from the drop-down list. The language selection options depend on the build destination selected.

Limitations

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

Tips

  • 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.