Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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: Essbase Error(0) Invalid member name

Hi all,

I am trying to retrieve the date from a combination using DataGridDefinitionBuilder and extract year, month and day from it.

The approach might be a bit long but I am converting the data retrieved to long followed by string.

But, when I am using substring() function to extract year, month and day, the calculation manager is throwing the below error. I haven't written any Essbase Calculation in the groovy script.

The following the full code for your reference:

def valuestartdate
def strstartdate

def Strstartdateyear
def Strstartdatemonth
def Strstartdateday
long longVar

Cube cube = operation.application.getCube("Plan1")

DataGridDefinitionBuilder builder = cube.dataGridDefinitionBuilder()

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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