Versions Compared

Version Old Version 3 New Version 4
Changes made by

DevaDarshini.S

DevaDarshini.S

Saved on

Key

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

...

Expand
titleI want some SQL statements to be executed before a report is generated 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 for more details.

Data Composer (Multiple/ Aggregated Data Sources)

...

Expand
titleCan the template used to render the report be modified?

In SigmaStudio, the HTML editor in Template Designer can be used to design the reports. Refer Template Designer Configuration for more details.

Expand
titleWhat is a derived column?

A derived column is a custom column which is created to perform computations using multiple fields in the aggregated DS, and store computation values to use them in the report. The computation formulas used between fields is restricted to use only JEXL operators. Refer Adding Formulas in Data Aggregator and JEXL Operators  for more information.

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. Refer JEXL Operators for more information.

Expand
titleWhat is a derived report?

A derived report is a customized report version where the user can customize all the values (like filters, format etc.) in the report and saves them as a local copy in Sigma Portal for themself. These derived reports  help in saving time for the user as the users can use these reports (with all selections in place) every time instead of customizing all the options again and again.  Refer Saving reports with custom configurations for more details.

...

Expand
titleCan a report be pivoted based on a specific field?

Yes, the report pivot option is available in Sigma. Refer Pivot reports for more details.

Expand
titleCan we avoid adding empty pages with no data message in the report, when an aggregated source with no child record is used?

Yes, this is feasible and supported in SIGMA. Open the report in Sigma Studio and navigate to the Report Parameters tab. Select the Generate output for no data drop-down to control the report generation in these cases.

...

Expand
titleCan I mask PII data and protect reports with passwords in SigmaStudio?

Yes, SigmaStudio enables you to protect your PII data by masking the relevant data and configuring passwords for the reports. Refer Data Masking and Password Protection for more information.

Expand
titleCan totals and subtotals be created at a column level in a report?

Yes, Sigma enables you to perform specific actions like  displaying the grand total, average,    count, etc, for a column in a report. The “Select Group Header” attribute in Sigma Application helps in the same. Refer Totals and Subtotals in SIGMA for more details.

...

Expand
titleCan I create a template for each notification channel?

Yes, Sigma allows you to do two-layer templating.

  1. Delivery medium level (SMS, SMTP or INBOX)

  2. Delivery status level (Success or Failure) 

Refer Notification Template for Reports for more information.

Expand
titleWhat are the notification options available for reports in Sigma?

Sigma Application (portal) users can choose either SMS or email notification and select contacts or contact groups that must receive the notification when the report is generated. The contacts and contact groups must be defined in SigmaStudio.

...