Groovy script to extract all level data of BSO cube
Summary:
Hi All,
We have a custom cube and we would like to extract all level in a specified csv file format , (any other groovy function will be helpful)
Cube cube = operation.application.getCube('xxxxx')
DataGridDefinitionBuilder builder = cube.dataGridDefinitionBuilder();
builder.addRow(['BULOB','DEPARTMENT','CUST','COM']
@idescendants("BULOB") -all sparse dimension and data store property is store
@IDESCENDANTS("TOTDEPARTMENT") all sparse dimension and data store property is store
@IDECENDANTS("CUST") all sparse dimension and data store property is store
@IDESCENDANTS("COM") all sparse dimension and data store property is store
Data exporter function cannot export all data only export level0 data
Tagged:
0