Reporting and Analysis users can create ad hoc reports, standard reports, and custom reports. The reports contain data from different sources, and vary in complexity.
Report comparison
Report type |
Ad hoc |
Standard |
Custom |
---|---|---|---|
Design complexity |
Simple to medium |
Medium |
Simple to advanced |
Data source |
Model |
Model and SQL |
Model and SQL |
Database schema |
Reporting |
Reporting |
Transactional and Reporting and Analysis |
Revisions |
Current* |
Current** |
All |
Data blinding |
Inherent in model |
In SQL |
In SQL |
* For ad hoc reports, you can see all revisions for operational data only.
** The audit trail standard report covers all revisions.
Copyright © 2012 - 2015 Oracle and/or its affiliates. All rights reserved. |
---|