The ElastiCube Manger makes it easy to edit custom tables. You can use SQL to customize the fields contained within a custom table.

  1. Click the custom table you want to edit or add an SQL expression.
  2. Place the mouse cursor above the table name until the preference icons appear. Click the Edit table SQL expression icon.
  3. The Table Editor will open where you can enter SQL statements to access tables and fields that exist in the ElastiCube Manager schema. See related topics for more details on SQL and Function References.
  4. Once you complete an SQL statement click on the top right icon Parse SQL Expression to validate the statement.
  5. To view results based on the SQL statement, click on the top right icon Preview result table(NoteAt least one build including the relevant base table must have been completed in order to preview results.)
  6. To save changes or save and exit, click on the top right icon.

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 table as A
  • You can add comments in expressions by using the ‘–’ for a single line or /…/ for blocks.
  • A good reference on compatible SQL commands is available on Microsoft MSDN.

SQL Left Join Example

Case Statement Example

Union Statement Example