Please ensure Javascript is enabled for purposes of website accessibility
Powered by Zoomin Software. For more details please contactZoomin

AVEVA™ BI Gateway

OEECalculations

  • Last UpdatedFeb 05, 2024
  • 1 minute read

This Azure function custom query returns the OEE Calculations. The custom query expression supports the following parameters:

Parameter Name

Parameter Choice

Example

Description

QueryName

Required

OEECalculations

Azure function query name

The following properties are returned from the Azure function query for "OEECalculations".

Property Name

Datatype

Description

Namespace

String

The namespace for the piece of equipment to which this OEE calculation definition applies.

Name

String

The name for the equipment.

DefaultRate

Int32

The default quantity of items being produced on this piece of equipment.

DefaultRate.UOM

String

The UOM (unit of measure) for the default production rate.

DefaultRate.Time

String

The default amount of time that is required to produce the default rate quantity of items on this piece of equipment.

TargetAvailability

Int32

The target setpoints for Availability for the equipment.

TargetQuality

Int32

The target setpoints for Quality for the equipment.

TargetPerformance

Int32

The target setpoints for Performance for the equipment.

TargetOEE

Int32

The target setpoints for KPI OEE for the equipment.

StartUtilizationReason

String

If a valid utilization reason is provided in this column, a utilization event with this utilization reason will be added when a production run is started.

CompleteUtilizationReason

String

If a valid utilization reason is provided in this column, a utilization event with this utilization reason will be added when a production run is completed.

For more information, see the OEE calculation definition columns section in the AVEVA Insight Online Help.

TitleResults for “How to create a CRG?”Also Available in