Versions Compared

Version Old Version 27 New Version 28
Changes made by

DevaDarshini.S

DevaDarshini.S

Saved on

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 detail:

Column NameDescription
APPLICATION_IDSIGMA
DATA_SRC_IDIt displays all the data source ID used in the Data builder.
REFERENCE_KEYA 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_IDA 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.


...