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 DataGridBuilder varying columns

Summary:


Content (please ensure you mask any confidential information):

Hi,

I got stuck on a groovy rule to build a DataGridBuilder with varying columns and don't know how to achive that. Here is my case.

Dimension period = operation.application.getDimension("Period",cube)
def rolling_periods = period.getEvaluatedMembers('&RollingMths',cube)

So, &RollingMths is a sub var, e.g. Apr:Dec

And I can get rolling_periods as [Apr,May,Jun,Jul,Aug,Sep,Oct,Nov,Dec] with no issue.

However, I need to build a DataGridBuilder as below

……………..

DataGridBuilder gridbuilder = cube.dataGridBuilder("MM/DD/YYYY",SYSTEM_USER)
gridbuilder.addPov(****)
gridbuilder.addColumn(rolling_periods.toString())

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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