Dimension KPI is structured in a Excel fileĀ with the following columns:
- Control Group: If it its ITGC or Sod KPI
- KPI Code: Id of KPI
- KPI Cluster: What SAP cluster is KPI from
- Owner: Owner of KPI
- Description: Description of KPI
- Where Clause: clause to be included when creating UST12_Filtered
- User Compliance: Query which verifies if bname matches all restrictions
- Has_Tcode Clause: Indicates if Bname has a row with TCode value
- Object List: The list of objects to consider
- Calculation: Calculation method of KPI
- Periodicity: How often KPI is to be refreshed