Page Comparison

Reports are configured in SigmaStudio eMACH-Sigma Studio by operation or IT users. Report consumers can log-on to eMACH-Sigma Application (portal) and generate or schedule the reports they are entitled to access (based on the entitlement settings).

eMACH-Sigma Studio is used for creating the reports/ dashboards. It facilitates quick configuration of reports & dashboards using single-click and drag-and-drop interface. Typically, eMACH-Sigma Studio is used by the Bank’s operations or IT staff who have access and are aware of the functional data entities and wanted to configure reports or dashboards for end-users to consume.

eMACH-Sigma Application is used by end users (report consumers) to generate and schedule reports. eMACH-Sigma Application can be used by Bank’s operations staff or business users who need to generate reports on behalf of customers.

• Configure data

  • Create Data sources from database, or web service

  • Merge data from multiple sources / systems & create formulas using data builder option

• Formatting & Customization

  • Create labels, group, sort & filter data

  • Choose Paper, Layout, font, format fields

  • Add customizations at Client Level

• Execution of EOD reports through Online

• Entitlements setting & permissions

  • Configure entitlements to set up which data needs to be accessed by which user

Report consumers can perform the following actions:

• 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.

  • Choose contacts and notification channels

• Save base reports with customizations as derived reports.

• 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 report groups.

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 SIGMAeMACH-Sigma for more details.

No. The report designers (eMACH-Sigma Studio users) can configure or enable specific formats for each report based on their business requirements.

Report consumers or generators (eMACH-Sigma Application users) can generate the reports choosing the respective formats from the formats enabled for that report in eMACH-Sigma Studio.

eMACH-Sigma provides role-based access to reports in eMACH-Sigma Application based on the entitlements configured for those respective reports. When users log-on to eMACH-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 SigmaStudioeMACH-Sigma Studio.  Refer Enabling Role-based access to reports for more details.

Using eMACH-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

Yes. eMACH-Sigma Studio provides following options for aggregating report columns' data:

• Average

• Count

• Maximum

• Minimum

• Sum

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

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

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

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 eMACH-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.

A user can add any number of columns without any limit using eMACH-Sigma. However, the column length (width) must be specified appropriately to avoid error scenarios.

For example, if you specify 10 characters for an address column, the values for that column should not exceed that limit. Also, depending upon the number of columns, the report page size and orientation needs to be configured accordingly.

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

Yes, this is feasible and supported in SIGMAeMACH-Sigma. Open the report in eMACH-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.

Though the end of report option is enabled for all, it can be modified using the report configuration option under Add Labels Screen in eMACH-Sigma Studio.

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.

Once a report is generated successfully, it can be downloaded from the 'Generated Reports' tab in eMACH-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.

In eMACH-Sigma portal, on the Generated Reports tab, select the 24 Hours, 3 Days, and 7 days filters to view reports that are generated in the past accordingly.

1. eMACH-Sigma Studio provides support for the following currency formats:

• Indian

• EURO

• US

• South Africa

• Egyptian

eMACH-Sigma Studio provides support for the following languages:

• English

• Arabic

• Chinese

If you need to add a new language to the eMACH-Sigma application, Refer /wiki/spaces/sigma2021/pages/2577957192 for more information.

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

Yes, SigmaStudio eMACH-Sigma Studio 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.

Yes, eMACH-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 eMACH-Sigma Application helps in the same. Refer Totals and Subtotals in SIGMAeMACH-Sigma for more details.

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.

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

• Minute

• Hourly

• Daily

• Weekly once

• Monthly

Refer Scheduling Reports for more information.

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

The logs for the Report Schedule are displayed in ctschedulerLog.log file in eMACH-Sigma.

eMACH-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 SigmaStudioeMACH-Sigma Studio.

When report generation fails in eMACH-Sigma Application (portal), users can view the failure reason upon which they can take further action. eMACH-Sigma also offers options when scheduling reports to specify the  number of times for retrying report generation in case of failures.