Export Excel in Pentaho 7.1 with error Merge region caused by poi-3.15
Drillthrough
French translation updates
Instructions on how to verify changes:
When we add filters to columns and/or rows by clicking on the selected columns / rows, if we do not specify any totals type (Sum, Min, Max, Avg), "None" will be taken into account. Therefore, blank aggregators will be added to the Excel file exported (with aggregation columns added and also sub totals type "Bla" for "blank aggregator").
With this bug fix, blank aggregators will not be added to the Excel file exported, so aggregation columns and sub totals type "Bla" will not appear, when we add simple filters to columns / rows.
Levels marked as not visible (visible="false") in Mondrian schemas are still visible when we click on a higher level cell on the rendered table, then click "Include Level".
With this bug fix, levels marked as not visible in Mondrian schemas will no longer be visible when we do the above operations.
When we have exactly 1 measure, 1 dimension level on rows and 1 dimension level on columns, and then do Excel export, we will get systematically an error saying that the exported file is not available. This problem is caused by the 4 poi libraries in version 3.15, with a "Merge region..." error. By including the 4 poi libraries in version 3.12 in the build for Pentaho 7.1, this issue no longer exists.
With this bug fix, we can do normal export Excel with the above operations.
A lot of problems on the drilthrough feature (not drillthrough with export CSV, which works normally) on Saiku 3.15. If we select some dimensions, we encounter systematically an error. Also, the header row of the rendered table does not correspond to the body rows. This problem is due to the addition of the function drillthroughWithCaptions within ThinQueryService class.
By not using the new function and go back to the old function drillthrough, we can reselect dimensions and the drillthrough table is correctly rendered, without any problems.
Some French translation terms are added, please check the saiku-ui/js/saiku/plugins/I18n/po/fr.json file.
Fix bugs:
Instructions on how to verify changes:
When we add filters to columns and/or rows by clicking on the selected columns / rows, if we do not specify any totals type (Sum, Min, Max, Avg), "None" will be taken into account. Therefore, blank aggregators will be added to the Excel file exported (with aggregation columns added and also sub totals type "Bla" for "blank aggregator"). With this bug fix, blank aggregators will not be added to the Excel file exported, so aggregation columns and sub totals type "Bla" will not appear, when we add simple filters to columns / rows.
Levels marked as not visible (visible="false") in Mondrian schemas are still visible when we click on a higher level cell on the rendered table, then click "Include Level". With this bug fix, levels marked as not visible in Mondrian schemas will no longer be visible when we do the above operations.
When we have exactly 1 measure, 1 dimension level on rows and 1 dimension level on columns, and then do Excel export, we will get systematically an error saying that the exported file is not available. This problem is caused by the 4 poi libraries in version 3.15, with a "Merge region..." error. By including the 4 poi libraries in version 3.12 in the build for Pentaho 7.1, this issue no longer exists. With this bug fix, we can do normal export Excel with the above operations.
A lot of problems on the drilthrough feature (not drillthrough with export CSV, which works normally) on Saiku 3.15. If we select some dimensions, we encounter systematically an error. Also, the header row of the rendered table does not correspond to the body rows. This problem is due to the addition of the function drillthroughWithCaptions within ThinQueryService class. By not using the new function and go back to the old function drillthrough, we can reselect dimensions and the drillthrough table is correctly rendered, without any problems.
Some French translation terms are added, please check the saiku-ui/js/saiku/plugins/I18n/po/fr.json file.