Groovy to retrieve data from Essbase
Can somebody throw me some light how to get value from Essbase for a specific member combination? A very simple example will be much appreciated.
I know how to save values to Essbase through DataGridBuilder but I don't know the other way round for retrieving values.
I'm stuck at the code below and don't know what to do next to get the value of 'Counter XYZ'->'Next Number" at that POV? I guess there's something like getValue() ?
Cube cube = operation.application.getCube("Plan1") DataGridDefinitionBuilder builder = cube.dataGridDefinitionBuilder() builder.addPov('No Year','OEP_No Scenario','OEP_No Version','OEP_No Entity','BegBalance') builder.addColumn('Next Number') builder.addRow(['Counter XYZ'])