The Planning
Quest

// Groovy Battle 2: Revenue-Proportional Overhead Allocation // Part V — used in production at $2.8B Vision Corporation def entities = cube.getEssbaseCube() .getMember("Entity", "Total_Operating_Entities").getLevelZeroMembers() // Pass 1: sum total revenue — guard against zero def totalRev = 0.0 entities.each { e -> totalRev += getCell(e.getName(), "Total_Revenue", "Full_Year", "FY2025", "Budget", "Working") ?: 0 } if (totalRev == 0) { println("Guard: No revenue — abort allocation"); return } def pool = getCell("Corporate", "IT_Shared_Cost", "Full_Year", "FY2025", "Budget", "Working") ?: 0 def writes = [] // Stage all writes — ONE network call at the end // Pass 2: calculate each entity's proportional share entities.each { e -> def rev = getCell(e.getName(), "Total_Revenue", "Full_Year", "FY2025", "Budget", "Working") ?: 0 writes << [e.getName(), "IT_Allocated", "Full_Year", "FY2025", "Budget", "Working", pool * (rev / totalRev)] } operation.grid.setDataCellValues(writes) // 8 entities, 1 round-trip — not 8