Versions Compared

Version Old Version 19 New Version 20
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
titleWhere are the generated reports get stored?

The generated reports are stored in the server where Sigma is deployed. However, you can specify custom location to store the reports, such as a specific target folder, FTP directory or cloud storage.


Sigma Studio (for Configuring Reports)

...

Expand
titleAre all the formats automatically enabled for all reports?

No. The report designers (Sigma Studio users) can configure or enable specific formats for each reports. Report consumers or generators (Sigma Application users) can generate the reports in the enabled formats only.


Expand
titleDoes Sigma store functional or business data in its schema?

No. Sigma fetches the functional data from the configured data entities at the time of report generation.


Expand
titleHow does user entitlement for reports work in Sigma?

The users and roles must be defined in the authentication and authorization system. The roles must be re-defined and mapped to the entitlements in Sigma Studio. The entitlement must be configured for the reports. Sigma provides role-based access to reports in Sigma Application based on the entitlements configured for the reports. When users log-on to Sigma Application (portal), they get to see the reports that they are entitled to view.

...

Expand
titleWhat are the integration options Sigma provides for functional data required for reports?

Sigma Studio provides following integration options for fetching functional data - Database, JNDI, REST Web Services, Excel Import, and Google Sheets.

Expand
titleDoes Sigma store functional or business data in its schema?

No. Sigma fetches the functional data from the configured data entities at the time of report generation.


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
titleWhat level of control Sigma provides for the report columns?

Using Sigma Studio you can configure the following for report columns:

  • Column positions
  • Column alignment (by default number/amount columns of float data type are automatically right-aligned)
  • Column width
  • Column data aggregation (average, count, maximum, minimum, and sum)
  • Display names for columns
  • Column visibility
  • Column datatype
  • Date and time, currency formats

...

Expand
titleIs it possible to password protect the report files in Sigma?

Yes. Password protection can be enabled for PDF, DOCX, and XLS formats. Refer Configuring Password Protection for Reports for more information.

Expand
titleHow to view a report generated a week back?

In Sigma portal, on the Generated Reports tab, you can use the 24 Hours, 3 Days, and 7 days filters to view older reports.


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

In Sigma Studio, the HTML editor in Template Designer can be used to design the reports. Refer Template Designer Configuration.

...

Expand
titleWhat actions report-consumers can perform on Sigma Application (portal)?

Report consumers can perform the following on Sigma Application (portal):

  • Generate and download reports
    • Choose report formats from among those configured
    • Change column positions
    • Add or remove configured columns
    • Change column-level configurations
    • Change report orientation and page size
    • Use sort and group by columns if configured
    • Choose contacts and notification channels
  • Save base reports with customizations
  • Regenerate executed reports
  • Schedule reports
    • Configure multiple schedules for a report
    • Configure retry frequency in case of failures
    • Pause, resume and delete report schedules
  • Create group reports


Expand
titleHow to view a report generated a week back?

In Sigma portal, on the Generated Reports tab, you can use the 24 Hours, 3 Days, and 7 days filters to view older reports.


Expand
titleHow to view the reports generated in Sigma?

Once a report is generated successfully, it can be downloaded from the 'Generated Reports' tab in Sigma Application.

...