This tables contains data to render all kpi portlets, other than the Six Sigma control charts. This data is aggregated periodically by a server process, from data in the kpi_process_stats table.
| Column Name | Column Datatype | Column Null Option | Column Comment |
| kpi_data_uuid | table_key | not null | |
| kpi_id | integer | with null | Primary table key |
| datetime | date | not null | Timestamp for data record |
| chart_element_label | varchar(255) | not null | Datapoint label |
| dimension_1 | float | not null | 1st metric value associated with data point |
| dimension_2 | varchar(255) | with null | 2nd metric value associated with data point |
| dimension_3 | varchar(255) | with null | 3rd metric value associated with data point |
| child_kpi_id | integer | with null | KPI key to drill to for further analysis (not used in r10) |
| parent_id | integer | with null | KPI key from which a drill was made for further analysis (not used in r10) |
Product Name: BPM
Table Type: Table