Proposed Receipts from Plant

Type

Derived

Description

Netted DC Demand Quantity* lookup(Plant_Sourcing, parent(parent(Product)), dc-name, plant-name, percent-column)

Measure Formula

"Proposed Receipts from Plant" = lookup("Plant_Sourcing_RS", memberName(parent(parent(Product), Product)), memberName(member("DistributionCenters")), memberName(member("Plants")), "SOURCING_PERCENT") * Netted DC Demand Quantity"

Dimension Summarizations