We tried that (uptodata works at the same site as I do).
We also defined an aggregate materialized view that included the min(dim.desc), but it didn't do the job.
For some reason Cognos not only sums the measures, but also the dimension attributes, although there's only one per dim.key by definition.
Kind of frustrating: with 'normal' queries as a human would write them the response time = 32 milliseconds, Cognos generated query: 4 minutes
No, I mean that while running reports Cognos generates SQL that causes our trouble. Literally 'injecting' my own query works fine.
But the thing is, I don't wat to supply those queries for every possible combination one could select in Cognos.
I'm not really impartial, because I'm thinking quite 'database centric', but every time I see the capabilities of very expensive reporting tools I'm not impressed.
Fancy front end, not so fancy back end.