CubeGrid Export Functionality

[pci-abarbaro]

Version: v12.1p_2021-07-21/Enterprise Deployment
Browser: Chrome(latest)

Currently the Cube Grid exports externally to Excel with aggregated column header titles, as seen in the attached showcase. Is it possible to have stacked column titles exported to Excel such that they look the same as in the CubeGrid? If not are there any plans to make this happen? Attached is an example of what we are trying to accomplish.

Thank you for your time.

[Isomorphic]

Do you mean the taking the repeating values (like “Q1 2020” in the column headers) and making that into a single column-spanning cell? And doing similarly for repeated row headers?

If so, that’s a possible sponsorship, but we believe we encountered issues in this area, either with specific version of spreadsheet viewers or with the POI API at the time.

However, if those issues have been resolved since we looked, you may be able to do this yourself. If you call DSResponse.getExportObject() from a DMI after using DSRequest.execute() to get the default response, you can then modify the default POI spreadsheet we create, which might be as simple as iterating along and merging cells with the same titles.