DataGridBuilder error
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.