Precompute KPI grains that are expensive, frequently reused, time-sensitive, or require governed business logic, especially shift, day, asset, work order, and lot-level facts. Compute on the fly for ad hoc slicing and exploratory analysis. In regulated plants, the right split depends on data latency, master data quality, validation burden, and how well MES, ERP, QMS, and historian data are reconciled.