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

DataGridBuilder error

edited May 30, 2024 7:55AM in Planning 1 comment

Summary:

Hi,

Got a weird error when building a DataGridBuilder. Here's the code snippet:

/*RTPS: {RTP_Year} */

String str_Year = rtps.RTP_Year

DataGridBuilder gridbuilder = cube.dataGridBuilder("MM/DD/YYYY")
gridbuilder.addPov(str_Year, 'Actual', 'Final')

………………

DataGridBuilder.Status gridstatus = new DataGridBuilder.Status()
DataGrid grid = gridbuilder.build(gridstatus)

……………….

So, if the runtime prompt selection is "FY24", it failed saying "A method called by the script failed on line: 86, with error: The member "FY24" does not exist for the specified cube or you do not have access to it."

However, if I hardcode the year: gridbuilder.addPov("FY24", 'Actual', 'Final') or gridbuilder.addPov('FY24', 'Actual', 'Final') it's working good.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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