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

Create a table from DataGridDefinitionBuilder

edited Mar 4, 2021 9:03AM in Planning 6 comments

Content

Hi all,

We are trying to create table with groovy (to include in an email message) based on a DataGridDefinitionBuilder. What is the best way to do this? The datagridbuilder is build up as following:

Cube lookupcube = operation.application.getCube("Plan")
DataGridDefinitionBuilder builder = lookupcube.dataGridDefinitionBuilder()
builder1.setSuppressMissingBlocks(true)
builder1.setSuppressMissingRows(true)

builder.addPov(['Year', 'Scenario', 'Currency', 'Version','View'], [['FY21'], ['Forecast 1'], ['LC'], ['Working'], ['Total Plan']])
builder.addColumn(['Account','Product'], [ ['Revenue'],['All Products'] ])
builder.addRow(['Entity','Site','Period'], [ ['ILvl0Descendants("Total Company")'],['ILvl0Descendants("Total Cost Center")'],['ILvl0Descendants("Yeartotal")'] ])

The desired output is (this will be included in a HTML message):

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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