You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Groovy to retrieve data from Essbase

Accepted answer
31
Views
7
Comments
edited Mar 5, 2021 2:39AM in Planning 7 comments

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!