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
Alliance 2020 Reporting & Business Intelligence Sessions

Subscribing to the TRAG Community forums

TRAG #communitymingle Contest Reminder