Dimension KPI is structured in a GSheet 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.
Currently the Gsheet is stored in drive, in the following link: https://drive.google.com/file/d/1vnYDK9zdy13-Xm31a1SE0nCLGmC6J8Qo_-sdLPToSFg/view
This Excel is to be process by Talend Daily (??)