ZSF_DS_METRIC_SRC_GT
It is an internal temporary table persisted at the session level for storing intermediate results during metric computation.
Details
-
Schema: FUSION
-
Object owner: ZSF
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Comments |
|---|---|---|---|---|
| METRIC_CODE | VARCHAR2 | 100 | Foreign Key to zsf_ds_metric_defn table | |
| DIM1_KEY | NUMBER | 18 | Dimension value of the first dimension of the metric | |
| DIM2_KEY | NUMBER | 18 | Dimension value of the second dimension of the metric | |
| DIM3_KEY | NUMBER | 18 | Dimension value of the third dimension of the metric | |
| DIM4_KEY | NUMBER | 18 | Dimension value of the fourth dimension of the metric | |
| DIM5_KEY | NUMBER | 18 | Dimension value of the fifth dimension of the metric | |
| METRIC_SRC_PK1 | NUMBER | 18 | PK value of first metric source table | |
| METRIC_SRC_OVN1 | NUMBER | 30 | OVN value of first metric source table | |
| METRIC_SRC_PK2 | NUMBER | 18 | PK value of second metric source table | |
| METRIC_SRC_OVN2 | NUMBER | 30 | OVN value of second metric source table | |
| METRIC_SRC_PK3 | NUMBER | 18 | PK value of third metric source table | |
| METRIC_SRC_OVN3 | NUMBER | 30 | OVN value of third metric source table | |
| METRIC_VALUE | NUMBER | Amount/Value of the metric. |