Blogs

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!