Groovy to retrieve data from Essbase

Content

Hi

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() ?

 

Thanks!

Sunny

Code Snippet

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'])