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

    1. Click Add Data in the top menu of the ElastiCube Manager.
    2. Under the Custom category, select Custom SQL Expression.
    3. In the window that opens, enter the name of the custom table, and click v icon.
    4. In the Table Editor, you can enter SQL statements to access tables and fields that exist in the ElastiCube Manager schema. See also SQL Reference and Function Reference.
    5. Once you complete an SQL statement, click on the Parse SQL Expression icon to validate the statement. parse sql
    6. To view results based on the SQL statement, click the Preview result table icon preview.important   You can save an incomplete or invalid SQL expression, however you will not be able to build the custom expression. Note: At least one build including the relevant base table must be completed in order to preview results.
    7. To save changes or save and exit, click on the top right icon.

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 table as A.
      • You can add comments in expressions by using the ‘–’ for a single line or /…/ for blocks.