Did You Know PS Query can execute Advanced Analytics?

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!

2 Likes
Recent Stories
Did You Know you could create a Calendar view in Tableau in 8 easy steps?

What's a Chief Data Officer? An Interview with Nick Stevens, University of Kansas

PeopleSoft in the Oracle Cloud