public interface DataGridBuilder
The data grid object should be built using the withCloseable construct to ensure that it is automatically closed when it goes out of scope.
Example call from Groovy to build a grid on behalf of the user executing this script:
Cube cube = operation.application.getCube("Plan1") DataGridBuilder builder = cube.dataGridBuilder("MM/DD/YYYY") builder.addPov('Salary', 'Current', 'Local', 'BU Version_1') builder.addColumn('FY16', 'FY16', 'FY16', 'FY17', 'FY17', 'FY17') builder.addColumn('Jan', 'Feb', 'Mar', 'Jan', 'Feb', 'Mar') builder.addRow(['Department 1', 'Employee 1'], [30000, 30000, 30000, 33000, 33000, 33000]) builder.addRow(['Department 5', 'Employee 2'], [40000, 40000, 40000, 50000, 50000, 50000]) builder.addRow(['Department 1', 'Employee 3'], [30000, 30000, 30000, 30000, 30000, 30000]) DataGridBuilder.Status status = new DataGridBuilder.Status() builder.build(status).withCloseable { grid -> println("Total number of cells accepted: $status.numAcceptedCells") println("Total number of cells rejected: $status.numRejectedCells") println("First 100 rejected cells: $status.cellsRejected") // Save the data to the cube cube.saveGrid(grid) }Example call from Groovy to build a grid on behalf of the system user:Cube cube = operation.application.getCube("Plan1") DataGridBuilder builder = cube.dataGridBuilder("MM/DD/YYYY", SYSTEM_USER) builder.addPov('Salary', 'Current', 'Local', 'BU Version_1') builder.addColumn('FY16', 'FY16', 'FY16', 'FY17', 'FY17', 'FY17') builder.addColumn('Jan', 'Feb', 'Mar', 'Jan', 'Feb', 'Mar') builder.addRow(['Department 1', 'Employee 1'], [30000, 30000, 30000, 33000, 33000, 33000]) builder.addRow(['Department 5', 'Employee 2'], [40000, 40000, 40000, 50000, 50000, 50000]) builder.addRow(['Department 1', 'Employee 3'], [30000, 30000, 30000, 30000, 30000, 30000]) DataGridBuilder.Status status = new DataGridBuilder.Status() builder.build(status).withCloseable { grid -> println("Total number of cells accepted: $status.numAcceptedCells") println("Total number of cells rejected: $status.numRejectedCells") println("First 100 rejected cells: $status.cellsRejected") // Save the data to the cube cube.saveGrid(grid) }
Modifier and Type | Interface and Description |
---|---|
static class |
DataGridBuilder.Status
This class contains the results of the build operation.
|
Modifier and Type | Method and Description |
---|---|
void |
addColumn(java.lang.String... headers)
Add a row of column headers to this grid.
|
void |
addPov(java.lang.String... pov)
Add POV members to this grid.
|
void |
addRow(java.util.List<java.lang.String> headers,
java.util.List data)
Add a list of row headers and data for the corresponding columns to
this grid.
|
DataGrid |
build()
Returns a grid built from the region defined by the caller.
|
DataGrid |
build(DataGridBuilder.Status status)
Returns a grid built from the region defined by the caller.
|
void addColumn(java.lang.String... headers)
This should be called once per dimension on the column, and the length of headers from each dimension should match.
Example call from Groovy that adds Jan, Feb, Mar from FY16 and FY17:
builder.addColumn('FY16', 'FY16', 'FY16', 'FY17', 'FY17', 'FY17')
builder.addColumn('Jan', 'Feb', 'Mar', Jan', 'Feb', 'Mar')
headers
- column members for a dimensionvoid addPov(java.lang.String... pov)
pov
- membersvoid addRow(java.util.List<java.lang.String> headers, java.util.List data)
Example call from Groovy that adds the row headers and data for each row:
builder.addRow(['Department 1', 'Employee 1'], [30000, 30000, 30000, 33000, 33000, 33000])
builder.addRow(['Department 5', 'Employee 2'], [40000, 40000, 40000, 50000, 50000, 50000])
builder.addRow(['Department 1', 'Employee 3'], [30000, 30000, 30000, 30000, 30000, 30000])
headers
- row membersdata
- dataDataGrid build() throws java.lang.Exception
Cells where row/column member names are invalid and do not exist are rejected.
java.lang.Exception
- if an unexpected fault occursDataGrid build(DataGridBuilder.Status status) throws java.lang.Exception
Cells where row/column member names are invalid and do not exist will be rejected.
status
- an optional status object that captures rejected cellsjava.lang.Exception
- if an unexpected fault occursCopyright © 2017, 2024, Oracle and/or its affiliates. All rights reserved.