Cube cube = operation.application.getCube("Plan1") String currentYear = operation.application.getSubstitutionVariableValue("OEP_CurYr") DataGridBuilder builder = cube.dataGridBuilder("MM/DD/YYYY") builder.addPov(currentYear, 'Current', 'USD', 'BegBalance', 'BU Version_1', 'No Entity') builder.addColumn('Min Salary', 'Max Salary', 'Min Bonus', 'Max Bonus') builder.addRow(['Grade 1'], [30000, 50000, '#missing', '#missing']) builder.addRow(['Grade 2'], [40000, 60000, '#missing', 5000]) builder.addRow(['Grade 3'], [70000, 90000, '#missing', 10000]) DataGridBuilder.Status status = new DataGridBuilder.Status() builder.build(status).withCloseable { DataGrid grid -> println("Total number of cells accepted: $status.numAcceptedCells") println("Total number of cells rejected: $status.numRejectedCells") println("First 100 rejected cells: $status.cellsRejected") cube.saveGrid(grid) }