I work for an organization that has a relatively massive Oracle 11g database. We currently invest a lot of time in producing custom reports - the queries are quite complex and not something to be inflicted on a business user, but the time we have developers working on report layouts strikes me as a waste.
Do you, dear reader, have experience with a reporting package for Oracle that:
- sucks less than the DIY alternative
- is usable by ordinary business people to generate report layouts?
- COTS or open-source
EDIT: we have other solutions for aggregation & other BI functions. This purpose, currently solved with homegrown SQL packages, extracts data from 5-30 tables (some of which have hundreds of columns - that's a different conversation) representing several TB of data. We have emerging reporting requirements for state governments. The queries may need to be tweaked somewhat across agencies, and the extract layout (e.g. what columns are included) will almost always vary. I'm fairly new to this domain as well as the "big data" world, thus the search for decent leads here.