Defining and Editing Field Formulas

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

When you edit a custom table, any changes you make are saved when you click Save unless the expression did not successfully parse. In this case, you are prompted to save a draft of the invalid expression.

If you save the invalid expression, Sisense continues to use the last valid expression that was saved when building an ElastiCube, but the next time you open a preview of the table, the invalid expression will be displayed. This allows you to continue building working ElastiCubes while letting you save incomplete expressions for later.

If you wish to display the last valid expression, you can click the Refresh button in the menu bar and then press Save.

To edit a custom table's SQL expression:

1. Select the custom table you want to edit and click .

   

   The custom table area is displayed

2. Enter SQL statements to access tables and fields that exist in the schema. See related topics for more details on SQL Quick Reference and Data Functions for Custom Tables and Fields.

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

   Note:

   At least one build including the relevant base table must have been completed in order to preview results.

4. Click Save to save your changes.