PS Query & SQL

 View Only
Back to Library

Aggregate reporting in multiple dimensions using PS Query 

01-18-2025 02:43 PM

This session will explain and showcase the use of PS query for advanced analytical statistics available from your Oracle database, without a need to develop custom SQR, AE, or other means to obtain the needed data for operational decision making.

Campus Solution data will be used for the demo and examples. However, the method is applicable to any application supporting the ability to query data.

https://www.heug.org/communities/community-home/librarydocuments/viewdocument?DocumentKey=d3e7a584-12a0-44bb-b79c-f5e31052ea3f


#Longin_Gogu
#PSQuery
#Analytics
#Advanced
#Partition
#ROLLUP
#CUBE
#SQL

Attachment(s)
Download All
pptx file
2019 Aggregate Reporting in multiple dimensions using PS ....pptx   4.50 MB   1 version
Uploaded - 01-18-2025
 
Download
zip file
5691- PS Project.zip   5 KB   1 version
Uploaded - 01-18-2025
 
Download

Related Entries and Links

No Related Resource entered.