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!
Finance
HCM
Student Systems
CRM
Technical
Careers
Alliance
International / Regional
E-Academy
Finance | HCM | Student Systems | CRM | Technical | Careers
Alliance / International / Regional / E-Academy