Export to XLSX - Overcome limitations of layout export with huge datasets
Idea:
We use the export functionality of Board intensively. For the layout export (procedure layout export or export to excel) it is annoying that we have to decide for the row entities whether we just want to see the code OR the description OR both concatenated when the default settings doesn’t match to our needs for the export. The entity blocks doesn’t help in this case.
For further processes in other functions and for dataquality checks we usually use the data in Excel and it is quite unpleasant to separate the code from the description in excel. Even further we can’t give this functionality to most end users as this is not user friendly enough.
Therefore, we would highly welcome a setting for the layout export that allows us to export the code and descriptions of the row entities each in separate columns. This would help us a lot and probably many customers, too.
In addition, sometimes we have to use the cube export as the layout export doesn’t run anymore (amount of data). Therefore, the description should also be exportable for cube exports. The new way of exporting cubes is a great improvement to previous versions and this change would make it perfect.