Monday, April 11 1:15pm – 2:15pm 211 Technical Session BI/Data Warehousing/EPM
Oracle Database 11g OLAP provides several new features that can used to enhance performance of Oracle-based data warehouses. In addition while providing a complete summary management capability they can add additional calculation capabilities. Views are automatically created that allow standard SQL to access the original data as well as any additional measures. By placing the calculations in the database all of your business rules and measures can be securely stored in the database. All of this content can be accessed with any application including Oracle Business Intelligence Enterprise Edition Oracle Application Express Oracle Discoverer BI Publisher Oracle SQL Developer as well as non-Oracle tools.