KPI Definition Registry
Teams argue about seven definitions of revenue. EntiHub stores the official KPI definition so Fabric, Power BI, and AI cite one meaning.
Why this is needed
- Metric chaos wastes executive time.
- AI-generated KPI explanations need a governed formula.
- Controlling needs an owned catalog lighter than a full semantic-layer product.
Proposed entities in EntiHub
Governance settings
| Setting | Recommended value | Why |
|---|---|---|
approvalRequired |
true |
Only Finance can promote a definition to official. |
historyEnabled |
true |
History supports restatement narratives. |
allowSameAuthorApproval |
false |
Maker/checker separation for sensitive changes. |
deletedRetentionDays |
90 (or higher) |
Soft-delete retention for auditability. |
Entity definition (YAML sketch)
name: kpi_definition
displayName: KPI definition
domain: Controlling
description: KPI definition
version: "1.0.0"
approvalRequired: true
historyEnabled: true
deletedRetentionDays: 90
displayRefColumn: code
uniqueConstraints:
- name: uq_kpi_definition_code
columns: [code]
columns:
- name: code
dataType: string
nullable: false
maxLength: 64
- name: name
dataType: string
nullable: false
maxLength: 128
- name: formula
dataType: string
nullable: false
maxLength: 2000
- name: owner_team
dataType: string
nullable: false
maxLength: 128
- name: source_system
dataType: string
nullable: false
maxLength: 64
- name: frequency
dataType: string
nullable: false
maxLength: 32
- name: status
dataType: string
nullable: false
maxLength: 16
YAML sketches
Sketches highlight the important fields and governance flags. Trim or extend columns to match your domain. See Setup Entity for the full YAML reference.
Sample data
| code | name | formula | owner_team | source_system | frequency | status |
|---|---|---|---|---|---|---|
| EBITDA | EBITDA | EBIT + Depreciation & Amortization | Finance | SAP | monthly | official |
| REV_IFRS | Revenue (IFRS 15) | Recognized revenue per IFRS 15 | Finance | SAP | monthly | official |
Benefits for the company
- One official definition across BI and AI.
- Clear owner for each metric.
- Reduces dueling dashboards.