There is a more general remark about the export of Reports that I’d like to make:
I like the ability to open/expand or close groups of rows in the Qonic UI. But when exporting the data to Excel this is not always the way we want to see it. Currently - I believe - this CSV export is kind of a data dump without any formatting, logic, … It contains both the individual rows as well as groups, subgroups, … And they all look the same.
I think it would be much more interesting if the ‘raw data’ would be put in a real (Excel) table and that the Report functionality would be recreated using pivot table. Or at least with formatting so that it looks like a report. And using formulas to sum the values of individual rows into subtotals on group level. => Anyway, I’d prefer the first option with a table and separate formatting because that would be more interesting to do something with.
I would prefer the implementation of a BI dashboard, where reports (standard or user-defined) are created and can be versioned. LOD backups and comparisons to document the planning history would be very helpful. In the future, this could extend to model- and element-based costing, tendering, awarding, and billing.
How far does Qonic intend to go in this regard, or will it involve partners?