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 © 2014 Oracle and/or its affiliates. All rights reserved. |
---|