derived
“Associated Geography” for plants are not matching with Location values in Material Details data. Using plant name for now. property(Plants, “Associated Geography”)
"Lead Time Value" = round(lookup("Material_Details_RS", memberName(member("Product")), memberName(member("Plants")), "LEADTIME")/7)
| Dimension | Rollup | Rolldown |
|---|---|---|
| Manufacturing | None | None |
| Plants | None | None |
| Product | None | None |