Versions Compared

Version Old Version 20 New Version 21
Changes made by

Ravikumar Babu CTOO (Unlicensed)

Ravikumar Babu CTOO (Unlicensed)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Expand
titleCan we create a DB datasource with SQL statements in Sigma Studio?

Yes, in Sigma Studio you can create datasource with SQL statements. Alternatively, you can create datasource for DB tables, views and stored procedures.


Expand
titleI want to some SQL statements to be executed before a report is generated in order to prepare the data for the report. Is this possible in Sigma?

Yes, you can execute stored procedures as pre-hooks before a report is generated. Refer Using Stored Procedure as pre-hook for Creating Reports.

...

Expand
titleCan derived columns be created based on conditions?

Yes and it achieved in two ways:

  • Using the CASE WHEN expression in the SQL select statement itself.

OR

  • Using the Java Expression Language (JEXL) conditional statements in the Derived Column field in Sigma Studio.

...