Since the release of Oracle Database 11g, Oracle has introduced database level advanced analytical capabilities. Some of these capabilities are accessible through PS Query and can be put to good use when you write reports and queries. Among other features, grouping by ROLLUP and CUBE in a query can automatically add totals and subtotals across multiple dimensions of your data output.
Database Data Warehousing Guide
Aggregate reporting in multiple dimensions using PS Query
Alliance 2019 – Reporting and BI Presentations
Please reply to this post with your comments, feedback, and share a tip or two!
Financial Systems
HCM Systems
Student Success
CRM
Connected Campus
Project & Change Management
Alliance
International / Regional
E-Academy
Attendee Terms & Policies
HEUG Code of Conduct