Versions Compared

Version Old Version 1 New Version Current
Changes made by

DevaDarshini.S

DevaDarshini.S

Saved on

Key

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

...

Expand
titleWhat is a data source? How is this different from a Data root or database?

A data source is a unique source created from any data root source that is already connected. The data sources should have a unique name and can be configured from any data root source, be it a database or an excel file.  Please refer to Data Sources creation in SIGMA for more details.

Expand
titleCan I create a data source with SQL statements in SigmaStudio?

Yes, you can create data sources from DB with SQL statements. Alternatively, you can also create data sources from DB tables, views, and stored procedures. Refer Applying constructed queries for SQL Data Sources for more details.

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 I create/ use an aggregated data source joining data from multiple data bases or sources, for my report?

Yes, you can use the data builder feature to create an aggregated data source, connecting data from multiple sources (irrespective of their data root sources). Refer to Join Types in DataBuilder for more information.However, the data will be processed in application memory. Hence, sufficient care to be taken while creating the data aggregator.

...

Expand
titleCan Charts be included in the report?

Yes. The App Designer feature in the Sigma Studio can be used to create the chart as an individual app (widget). The Template Designer in Report configuration can be used to map the chart to the report. The generated report displays the chart and the report data. Refer Improve Business Reports with Charts.

Expand
titleWhat type of charts are supported by SIGMA?

Sigma Studio supports the following Chart Types:

  • Bar

  • Column

  • Doughnut

  • Pie

  • Funnel

  • Pyramid

  • Multi-series combination

  • Bubble, Scatter and more.

Also, support the 3D version of the following chart types: Bar, Column, Doughnut, Pie, Multi-series Bar, Multi-series column, Stacked Column, Stacked Bar, Multi-series combination and Pareto.

...

Expand
titleHow does user entitlement for reports work in Sigma?

Sigma provides role-based access to reports in Sigma Application based on the entitlements configured for those respective reports. When users log-on to Sigma Application (portal), they can view those reports that they are entitled to view based on the entitlements configured.

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 SigmaStudio.  Refer Enabling Role-based access to reports for more details.

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
titleDo reports have Right to Left (RTL) support?

Yes, Sigma supports RTL capability. Refer Right-to-Left Text Capability for more details.

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 derived report created by one user shared with other users?

No, currently a derived report created by one user can only be consumed by that user.

...

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 we have drop-down values or list box (multiple selection) as report parameters while generating reports in Sigma?

Yes, drop downs or list boxes can be configured for reports in Sigma. Refer Enabling Drop-downs for Report Filters for more details.

Expand
titleCan we embed a report or dashboard within another report in SIgma?

Yes, any report can have another report embedded into them so that the main and the sub reports are connected by a common measure (primary key). Refer Sub-Reports for more information.

Expand
titleHow to view the generated reports in Sigma?

Once a report is generated successfully, it can be downloaded from the 'Generated Reports' tab in Sigma Application post which the report can be accessed accordingly Also, the status of the generation will also be shown here with various status messages for easy tracking.

...

Expand
titleWhat are all the languages supported in Sigma?

Sigma Studio provides support for the following languages:

  • English

  • Arabic

  • Chinese

If you need to add a new language to the Sigma application, Refer /wiki/spaces/sigma2021/pages/2577957192 Adding a New Language in Sigma Application for more information.

Expand
titleCan I create an incremental report in Sigma?

Yes, Sigma enables you to create incremental reports with simple and efficient configurations. Refer Incremental Reports for more information.

Expand
titleWhat will I have to do if scheduling fails?

You can retrigger the failed schedule based on the number of retries provided in the configuration of the report scheduling. Refer Scheduling Report for more information.

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 set passwords to restrict access to generated reports in SIGMA? Is there a way I can templatize the password?

Yes, passwords can be set up for report files in SIGMAStudio to protect your data. Refer Configuring Password Protection for Reports for more details.

Expand
titleWhat formats support password protection?

The password feature is applicable for PDF, XLS, and DOCX formats only. XLS reports when password protection  must be opened in Microsoft Excel only.

Expand
titleDoes Sigma enable reconciliation of data at intra day (near real time) instead of end of day?

Yes, the report can be scheduled to run to get the report data in incremental mode from the last report generation. Incremental reports can be scheduled on an hourly, daily, weekly or monthly basis as per needed. Refer Incremental Reports for more details.

Expand
titleCan I add static contents / templatize a report header or footer?

Yes, the report header and footer can have some free text and can be templated using the Template Designer feature. Refer Static Content using Template Designer for more details.

Expand
titleWhat are the allowed formats in Sigma for generating reports?

Sigma Studio provides support for the following report formats:

  • PDF

  • CSV

  • HTML

  • XML

  • XLS

  • DOCX

  • TXT

...

Expand
titleHow to combine multiple reports into a single file?

You can combine multiple report outputs into a single file using the Group Reports feature. Refer Grouping Reports in Sigma for more information.

Expand
titleIn what all possible ways grouped file outputs can be generated?

Grouped Report output can be generated in 3 different formats based on the requirements shared.

  • If you choose the Individual File option, PDF and XLS formats are supported.

  • If you choose the Single File option, PDF and XLS formats are supported.

  • If you choose the Multi Sheet option, only XLS format is supported.

Expand
titleWhat are the report scheduling options in Sigma?

Report consumers can schedule reports in the Sigma Application (portal) in the following frequencies:

  • Minute

  • Hourly

  • Daily

  • Weekly once

  • Monthly

Refer Scheduling Reports for more information.

Expand
titleIs it possible to set multiple schedules for a report?

Yes. In Sigma Application (portal), multiple schedules can be set for a report.

...

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.

Expand
titleCan I schedule and distribute report(s) to a single or a group contact / contact group?

Yes, the report bursting feature on Sigma helps in this. This feature enables you to schedule and distribute single or group reports to multiple contacts and contact groups. Each recipient gets a subset of the report data related only to them. Refer Report Bursting for more information.

Expand
titleWhen the report bursting is resumed, does it kick-start all instances or start from the next upcoming instances?

Report bursting schedules are executed like normal report scheduling. Pausing the report-bursting process essentially puts it on hold. The process stops at the point where it was paused. If report bursting is resumed, it fires the missed schedules once and continues with the next upcoming instances based on the given frequency. For example, when a report bursting is paused on August 1 and resumed on August 15, it kick-starts the report bursting on August 15 and continues with the next upcoming instances based on the given frequency.

...