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 |