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

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

Column NameDescription
APPLICATION_IDSIGMA
DATA_SRC_IDBrings It displays all the data source ID used in the Data builder.
REFERENCE_KEYwhen ever we generate A unique key is generated, when a report , a unique key is generated.
DATA_SRC_INSTANCE_IDRandom A random data source 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.


...