Requisition measures
| Measure | Measure source | Cube rule | Notes |
|---|---|---|---|
| Requisition Count | Requisition | ||
| Req Line Count | RequisitionLine | ||
| Req Line Value | RequisitionLine | Quantity * UnitCost | |
| Quantity | RequisitionLine | Quantity | |
| UnitCost | RequisitionLine | UnitCost | |
| AOC Total | Requisition | AOCTotal | |
| Approved Line Count | RequisitionLine | When Approved | |
| Not Approved Line Count | RequisitionLine | When not Approved | |
| Return Quantity | RequisitionLine | ReturnQuantity | |
| Return Value | RequisitionLine | ReturnQuantity * UnitCost | |
| Killed Quantity | RequisitionLine | KilledQuantity | |
| Killed Value | RequisitionLine | KilledQuantity * UnitCost | |
| Killed Line Count | RequisitionLine | When KilledQuantity = Quantity | |
| Lines To Sourcing Count | RequisitionLine | When CreatePurchaseOrder and SourcingEventRequired | |
| Lines To Sourcing Value | RequisitionLine | CreatePurchaseOrder and SourcingEventRequired | |
| Pcard Order Count | RequisitionLine | When UseProcurementCard | |
| Pcard Order Value | RequisitionLine | When UseProcurementCard then Quantity * UnitCost | |
| Days From Req Creation To Approval | Calculation | If at the req line level, show the base value then DaysFromReqCreationToApproval else DaysFromReqCreationToApproval / ReqLineCount | Show average if not viewing at the Req Line level |
| Days From Req Approval To PO Creation | Calculation | If at the req line level, then DaysFromReqApprovalToPoCreation else DaysFromReqApprovalToPoCreation /ReqLineCount | Show average if not viewing at the Req Line level |
| Average Req Line Quantity | Calculation | Quantity / ReqLineCount | |
| Average Req Line Value | Calculation | ReqLineValue / ReqLineCount | |
| Distribution Amount | RequisitionLineDistribution | If (DistributionByQuantity) return (DistributionQuantity * RequisitionLine.LandedUnitCost) else if (DistributionByPercent) return (DistributionPercent * RequisitionLine.LandedUnitCost * RequisitionLine.Quantity) else return (DistributionAmount) | |
| Item Average Cost | ItemLocation | If CreateDimensionElement = Y, then AverageCost | |
| Item Backordered Quantity | ItemLocation | If CreateDimensionElement = Y, then Backordered Quantity | |
| Item Backordered Value | ItemLocation | If CreateDimensionElement = Y, then Backordered Value | |
| Item On Order Quantity | ItemLocation | If CreateDimensionElement = Y, then OnOrderQuantity | |
| Item On Order Value | ItemLocation | If CreateDimensionElement = Y, then OnOrderValue | |
| Item Stock On Hand Quantity | ItemLocation | If CreateDimensionElement = Y, then StockOnHand Quantity | |
| Item Current Inventory Value | ItemLocation | If CreateDimensionElement = Y, then CurrentInventoryValue |
*Show average if not viewing at the Req Line level