...
Actual PPM = Total / Uptime [minutes]
Expected PPM = Expected / Scheduled [minutes]
PPM Gauge = Actual PPM - Expected PPM
Blending different Job Rates and Cycle Factors
[Fact Core].[Expected Production] is the Job rate. (see https://slxdev.atlassian.net/wiki/pages/resumedraft.action?draftId=743112705)
In a situation where cycle factor or job rate is changing (over longer reporting periods) or needs to be represented in the aggregate, consider using blended formulas.
Blended Rate = [Fact Core].[Expected Production] / [Fact Core].[Scheduled Hours]
Blended Cycle Factor = [Fact Core].[Expected Production] / [Fact Core].[Expected Cycles] *
| Info |
|---|
[Dim Jobs].[Job Max Run Rate] is a numerical value on a dimension (dim). The tool defaults a SUM(), but since its a dimension you will likely want to apply a MIN(). This field is replicated to [Fact Core].[Expected Production] for convenience. |
* Note: use a measure filter to remove unscheduled time from Expected and Actual Cycle fields:
...