WhatisaReport.ppt

OracleAS Reports Services Problem Statement To simplify the process of managing, creating and execution of Oracle Reports. What is a Report? A document which dynamically retrieves, formats and distributes database information. A General Reporting System Oracle Report Service Architecture Limitations of Oracle Solution Embedded Parameter Form Lack of report categorization Lack of report access description Limited report parameter description Inability to build reports from the web Complete Dependence on Oracle Reports Service to view reports Complete dependence on Oracle Report Builder to create reports Improvements in the Developed System Single Dynamic Parameter Form Additional METADATA stored in oracle database to handle Report Categorization User Access Multiple Parameter Lookups NONE SQL Query Date LOV from Help Table Improvements in the Developed System (contd) Ability to Create Reports from the web Handled by XML Reports compliant with oracle reports DTD Complete independence from Oracle Reports Builder and Service Handled by the ADHOC reporting subsystem Report Added Value Report Types RDF Legacy Systems with existing oracle reports Created using Oracle Reports Builder Published using Oracle reports Service Individual Parameter forms not required Report Types XML No dependence on Oracle Reports Builder Report is created on the fly using the system Based on the Metadata provided Adheres to the oracle reports DTD Report is automatically deployed. Report Types SCRIPTS(ADHOC) No dependence on Oracle reports builder or Oracle Reports Service. Based on a simple parameterized query. Example Select * from emp where emp.salary ‘P_1’ and emp.age ‘P_2’ Modules Report Maintenance ADHOC Report Module XML Report Generator Report Scheduler Report Execution Viewer Report Maintenance Module used to prepare and create reports. A simple user interface provides this functionality. Modules stores the metadata required for every report in the database. Re