DC Demand Plan Quantity

Type

Cross-cube

Description

Cube

Demand

Measure

Adjusted Demand Plan Quantity

Measure Formula

"DC Demand Plan Quantity" = div (Demand."Adjusted Demand Plan Quantity"* lookup("DC_Sourcing_RS", memberName(sourceMember(Geography)), memberName(member(DistributionCenters)),"SOURCING_PERCENT"), siblingCount(Manufacturing))

Onchange Formula

"DC Demand Plan Quantity" = "DC Demand Plan Quantity" + div (deltaValue(Demand."Adjusted Demand Plan Quantity")* lookup("DC_Sourcing_RS", memberName(sourceMember(Geography)), memberName(member(DistributionCenters)),"SOURCING_PERCENT"), siblingCount(Manufacturing))

Dimension Summarizations