Groovy setSuppressMissingSuppressesZero never work
Summary:
Hi,
With a groovy rule to build a grid like below for reading data
FlexibleDataGridDefinitionBuilder gdb = cube.flexibleDataGridDefinitionBuilder()
gdb.setSuppressMissingSuppressesZero(true)
gdb.setSuppressMissingRowsNative(true)
gdb.setSuppressMissingColumns(true)
gdb.setPov(CurYr)
gdb.addColumn('Actual', etc……….,'dynamic calc Account%')
gdb.addRow('ILvl0Descendants("BU")','ILvl0Descendants("Input Currencies")')
'dynamic calc Account%' is a parent with two child(% acct1, % acct2) rolling up.
The whole set of rows would be like 1000, however only 100 of those have non-zero values in 'dynamic calc Account%', rest all have zero value.
I would expect the grid only return 100 rows with the setting
Tagged:
0