OLAP Cube Dimensions

The OLAP Cube operates with the following dimensions:

Dimension Reference
Crew

One of the defined crews. A crew usually defines a number of employees.

See also: Operator.

Reference Edit: Groups | Configuration Items | Personnel | Crew.

CycleStatus

One of the defined cycle states.

Truck cycle states are:

Loading, Hauling, Queue at Dump, Travelling Empty or Queuing.

Loader cycle states are:

Loading Trucks or Waiting for Trucks.

Cycle states are Pitram defined for each site.

See also: Status

Destinations

A defined location that receives the mined material. For example, Drum, ROM, Crusher, Stockpile or Hoist.

See also: Locations, Source, Material

Reference Edit: Groups | Pitram | Locations | Location.

Equipment

Also:

Primary Equipment and Secondary Equipment

A unit of equipment used on site. The unit is defined by model type. It can also define the capacity and other associated measures.

Reference Edit: Groups | Pitram | Equipment | Equipment.

EquipmentFunction

One of the defined functions. For example, Bench Drilling, Charging, Hauling or Rock Bolting. A function may have an associated measure defined.

Reference Edit: Groups | Configuration Items | Equipment | EquipmentFunction.

EquipmentModel

The model type of a unit of equipment. The model can define the capacity and other measures for all units of that model type.

Reference Edit: Groups | Configuration Items | Equipment | EquipmentModel.

Loaders

A unit of equipment used to extract material. For example, Bogger or Loader.

See also: Equipment, CycleStatus

Reference Edit: Groups | Pitram | Equipment | Equipment.

Locations

The location that defined on site. For example, a drive, a bench, the workshop and more. Locations can define the material type, mine area, ore body and much more. A location can be a destination, a source or other location on site.

Reference Edit: Groups | Pitram | Locations | Location.

Material

Usually defines the material mined or of interest on site—High Arsenic Ore, High Oxide Ore and Waste, for example.

A material type can be associated with a location.

Reference Edit: Groups | Configuration Items | Locations | Material.

MaterialCategory

A more general term used to define Material. For example, High Grade, Overburden or Topsoil.

Reference Edit: Groups | Configuration Items | Locations | MaterialCategory.

MaterialGroup

The most general term in the hierarchy used to define Material. For example, Ore or Waste.

See also: Material

Reference Edit: Groups | Configuration Items | Locations | MaterialGroup.

Measures

Also: Cycle Measure

A defined measures. For example, Hours, Fuel, Metres, Tonnes and Truck Dumps. A measure can define the maximum and minimum value, decimal places, measure type (summed or cumulative) and more.

Reference Edit: Groups | Configuration Items | Measures | Measure.

Operator

One of the defined personnel on site who is operating a unit of equipment.

An Operator is defined by a hierarchy which includes,

Reference Edit: Groups | Pitram | Personnel | Person.

ShiftLog The shift (Day or Night), day, month and year of interest.
Source

A source is a location where material is extracted. Generally, it is the material of interest—ore.

See also: Locations

Reference Edit: Groups | Pitram | Locations | Location.

Status

Also: Allocated Status

A primary status that defines what a unit of equipment is doing or what is happening at a location. For example, Bogging, Transmission, Electrical, Drilling and many more.

Reference Edit: Groups | Configuration Items | States | Status.

StatusCategory

A status can be defined in terms of a Category. It is a more general term. For example, Operating Time (status = Bogging or Backfilling, for example) or Unscheduled Downtime (status = Transmission or Engine, for example).

Reference Edit: Groups | Configuration Items | States | StatusCategory.

StatusGroup

Highest level in the status definition hierarchy . Usually Down, Idle or Operating.

See also: Status

Reference Edit: Groups | Configuration Items | States | StatusGroup.

StatusType

The level below StatusGroup in the status hierarchy. A StatusType is defined in terms of a StatusGroup. For example, Delay Time, Idle Time and Operating Time.

Reference Edit: Groups | Configuration Items | States | StatusType.

Time Time in hours and minutes. Events in the Pitram database have the event time recorded.
Trucks

One of the defined equipment units.

See also: Equipment