Page Comparison

CT- Sigma is a cloud-ready Data Enterprise Application powered by Intellect’s Canvas Technology Platform. It enables users to create Dashboards & Reports  based on data from multiple systems/ sources on the fly.

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

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

Refer the CT_DATA_SOURCE_METRICS table, to view the Data builder and SQL query data source performance metrics collection in detail:

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.

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.

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

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.

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.

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.

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.

Sigma Studio provides support for the following report formats:

• PDF

• CSV

• HTML

• XML

• XLS

• DOCX

• TXT

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

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.