Versions Compared

Version Old Version 1 New Version 2
Changes made by

DevaDarshini.S

DevaDarshini.S

Saved on

Key

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

General

Expand
titleWhat is SIGMA?

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.

...

Expand
titleI am interested in SIGMA. Whom to contact and how to take this forward?

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

Data Source Configuration

Expand
titleWhat are the data root connections supported by SIGMA, for fetching the required functional data for reports/ dashboards?

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.

...

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
titleHow to view the Data builder performance metrics?

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

Column Name

Description

APPLICATION_ID

SIGMA

DATA_SRC_ID

It displays all the data source ID used in the Data builder.

REFERENCE_KEY

A unique key is generated, when a report which has data builder configured is generated and hence this can be used to analyze the metrics of that particular report instance.

DATA_SRC_INSTANCE_ID

A random data source instance ID is generated.

REFERENCE_TYPE

REPORT

DATA_REQUEST_INFO

It displays the query of the SQL data source, if not {} is displayed.

ROW_COUNT

It displays the number of records fetched. 

CREATED_DATE

It displays the report generated timestamp.

FETCH_TIME

It displays the time taken to fetch the functional data.

Information Workspace Designer (Dashboards)

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.

Report Designer (Configuration & Creation)

Expand
titleWhat report formats can be generated using Sigma?

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

...

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

Delivery Designer (Delivery & Notifications)

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.

...