Page Comparison

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

Please write to canvas.technology@intellectdesign.com for any assistance / requests regarding eMACH-Sigma, and the team will get back to you accordingly.

eMACH-Sigma Studio supports the following connections for fetching functional data – Different Databases (i.e.Oracle, MySQL, POSTGRES, SQL), JNDI, REST Web Services (APIs), MS Excel, Amazon S3, Amazon SNS, Google Sheets etc.

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.

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.

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

eMACH-Sigma enables generation of reports in the following 7 formats - CSV, DOCX, HTML, PDF, TXT, XLS, and XML.

eMACH-Sigma does not have any internal storage to store any functional or business data. The generated reports are stored in the server where the eMACH-Sigma application is deployed. However, the user can also specify custom locations to store the reports, such as a specific target folder, FTP directory or cloud storage on need basis.

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 eMACH-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, drop downs or list boxes can be configured for reports in eMACH-Sigma. Refer Enabling Drop-downs for Report Filters for more details.

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, 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, passwords can be set up for report files in eMACH-Sigma Studio to protect your data. Refer Configuring Password Protection for Reports 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.

eMACH-Sigma Studio provides support for the following report formats:

• PDF

• CSV

• HTML

• XML

• XLS

• DOCX

• TXT

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.

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