Versions Compared

Key

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

General


Expand
titleHow does Sigma work?

Reports are configured in Sigma Studio by operation or IT users. Report consumers log-on to Sigma Application (portal) and generate or schedule the reports that they have access to based on their entitlement.

...

Expand
titleCan we include a report in another report?

Yes. Refer Sub-Reports for more information.


Expand
titleHow to view the Data builder performance metrics?

Refer the CT_DATA_SOURCE_METRICS table, to view the Data builder performance metrics collection in details:

Column NameDescription
APPLICATION_IDSIGMA
DATA_SRC_IDBrings all the data source ID used in the Data builder.
REFERENCE_KEYwhen ever we generate a report, a unique key is generated.
DATA_SRC_INSTANCE_IDRandom instance ID is generated.
REFERENCE_TYPEREPORT
DATA_REQUEST_INFOIt displays the query data source is used in the data builder, if not {} is displayed.
ROW_COUNTIt displays the number of records fetched. 
CREATED_DATEIt displays the report generated timestamp.
FETCH_TIMEIt displays the time taken to fetch the functional data.




Sigma Application (Portal for Generating Reports)

...