Oracle Business Intelligence Enterprise Edition 11g: A Hands-On Tutorial -- Table of Contents -- Oracle Business Intelligence Enterprise Edition 11g: A Hands-On Tutorial -- Credits -- About the Authors -- About the Reviewers -- www.PacktPub.com -- Support files, eBooks, discount offers and more -- Why Subscribe? -- Free Access for Packt account holders -- Instant Updates on New Packt Books -- Preface -- What this book covers -- What you need for this book -- Who this book is for -- Conventions -- Reader feedback -- Customer support -- Downloading the example code -- Errata -- Piracy -- Questions -- 1. Understanding the Oracle BI 11g Architecture -- Looking backward and looking forward -- Let's look at the big picture -- What is Oracle Fusion Middleware? -- An application server by any other name -- A database repository - for what? -- Overall components -- Java components -- System components -- WebLogic Server -- A few software nuances -- WebLogic Domain -- WebLogic Administration Server -- WebLogic Managed Server -- WebLogic Node Manager -- System tools controlled by WebLogic -- Oracle Process Management and Notification system -- Security -- Backwards compatibility -- Managing by application roles -- Security providers -- Identity Store -- Credential Store -- Policy Store -- System requirements -- Client Tools -- Multiuser Development Environment -- Certification matrix -- Scaling out Oracle BI 11g -- Preconfiguration run down -- Shared storage -- Clustering -- Vertical expansion versus horizontal expansion -- Oracle BI Server (system component) Cluster Controller -- Failover and high availability -- Enterprise deployment guide -- Directory folder structure -- Log files (diagnostics) -- Configuration files -- A review - what I should now know! -- Additional research suggestions -- Summary -- 2. Installing the Metadata Repository.

Repository Creation Utility (RCU) -- What is the metadata store? -- Technical metadata -- Business metadata -- Process metadata -- Oracle Metadata Services (MDS) -- Repository schemas -- Non-repository metadata -- Downloading the software -- Running the RCU -- Setting up your database -- Oracle -- MS SQL Server -- Preparing for your installation -- Linux -- 64 bit Linux -- Standard installation steps -- Adding repositories -- Customizing your installation -- Other common changes -- Schema installations -- Oracle CREATE USER Script -- Silent installation -- Example creation -- Useful scripts -- Usage tracking script -- A review - what I should now know! -- Summary -- 3. Installing on Windows Server 2008 -- Installation media -- System requirements -- Installation -- A review - what I should now know! -- Summary -- 4. Installation Options -- Oracle BI on its own server -- High availability and failover planning -- Simple versus Software Only Installation -- Software Only Install -- Installing your own JDK -- Simple Install -- Silent installation -- Custom static ports -- Creating your own staticports.ini file -- Installing Oracle BI 11g on *Nix -- Listening on port 80 -- Ensuring IIS web server Role Services are installed -- Getting the WebLogic Server Proxy IIS plugins -- Creating and configuring an IIS Website -- Enabling compression in IIS 7.x -- Automate starting and stopping -- Leveraging the WebLogic Server Windows Service installer command -- Creating start-up and shutdown scripts -- Creating desktop shortcuts -- Creating boot.properties files -- Ancillary application integration awareness -- Recommendations for further learning -- A review - what I should now know! -- Summary -- 5. Understanding the Systems Management Tools -- Let's talk about management tools -- WebLogic Server Administration Control -- First access and checkpoint -- Servers.

Clusters -- Machines, IP address, or DNS -- Data sources or JDBC connections -- Security realms -- WebLogic Server is its own application -- Using WLST -- Enterprise Manager Fusion Middleware Control -- Getting around in EM -- BI Foundation Domain dashboard -- Coreapplication -- The Overview tab -- The Availability tab -- Process -- Failover -- The Capacity Management tab -- Metrics -- Scalability -- Performance -- The Diagnostics tab -- Log Messages -- Log Configuration -- The Security tab -- The Deployment tab -- Presentation -- Repository -- Scheduler -- Marketing -- Mail -- Managing Oracle BI 11g artifacts -- Creating a new Presentation Catalog -- Deploying an existing Presentation Catalog -- Deploying an RPD -- Starting/stopping system components -- Checking the logs -- Creating the Tennis users, roles, and associations -- Creating users and groups in WLS -- Assigning users to groups -- Creating and assigning application roles -- Configuring an LDAP identity provider in WLS -- Setting up the identity provider -- Establishing Fusion Middleware Control security linkage -- Restarting the WebLogic Server and Managed Server -- Assigning the LDAP Service Account Role Privileges -- JMS modules for BI Publisher communication -- Refreshing Presentation Catalog GUIDs - sync it up! -- JMX, MBeans, and Java -- Migrating FMW Security to other environments -- FMW core security files -- Project Amelia -- Downloading Project Amelia -- Getting the FMW Security file -- Running the script and generating the WLST script -- Migrating the security script and running it on the target server -- FMW Security Import/Export utility -- Using the Security Realm Migration utility -- Using the migrateSecurityStore function via WLST -- Oracle BI Publisher system management -- Monitoring system performance -- Have a backup plan! -- Recommendations for further learning.

A review - what I should now know! -- Summary -- 6. Upgrading the RPD and Web Catalog to 11g -- Upgrading an RPD and Web Catalog -- Upgrade Assistant -- Verification -- Upgrading BI Scheduler -- Manual migration -- Consistency check -- Security -- Regression testing -- Unit test -- Full regression testing -- User Acceptance testing -- A review - what I should now know! -- Summary -- 7. Reporting Databases -- Theories and models -- Reporting databases -- Relational modeling -- Dimensional modelling -- Why is database theory important? -- Designing your database - objectives, rules, and goals -- Objectives -- Rules -- Rule 1 - complete dimensions -- Rule 2 - build generic tables -- Rule 3 - partition large tables -- Rule 4 - prudent indexing -- Rule 5 - aggregate everything -- Rule 6 - constant analysis of usage and accuracy -- Rule 7 - manage statistics -- Rule 8 - understand the granularity -- Goals -- Goal 1 - keep it simple -- Goal 2 - minimize type 2 slowly changing dimensions -- Goal 3 - use data, not functions -- Goal 4 - minimize joins -- Goal 5 - reduce snowflaking -- Goal 6 - make it flexible -- Design summary -- Creating a warehouse -- Source system assessment -- Warehouse design -- Warehouse tables -- The Match star -- The Tournament star -- Populate and tune -- Monitor and maintain -- Some definitions -- A review - what I should now know! -- Summary -- 8. Developing a BI Repository -- Prerequisites -- Repository architecture -- Physical layer -- Business layer -- Presentation layer -- Physical layer -- Creating an RPD and importing metadata -- Elements of the physical layer -- Database object -- Connection pools -- Physical catalog and schemas -- Physical tables -- Physical join -- Consistency check -- Table aliases and naming conventions -- Business layer -- Business model -- Logical tables -- Logical table sources -- Logical columns.

Logical joins -- Dimension hierarchies -- Presentation layer -- Subject areas -- Best practices in the presentation layer -- Aliases -- Implicit fact -- Calculated measures -- Logical column calculation -- Expression Builder -- Physical column calculation -- Time series measures -- Level based measure -- Federated and fragmented content -- Vertical federation - aggregation or level based -- Horizontal federation -- Fragmentation -- Fragmentation example - content based -- Variables and initialization blocks -- A review - what I should now know! -- Additional research suggestions -- Summary -- 9. Features of the Presentation Catalog -- Integrated tools -- Analysis -- Dashboards -- Published reporting -- Actionable Intelligence -- Performance management -- Marketing -- Mapping -- Administration -- Briefing books -- Search -- Help -- Office integration -- The Home screen -- Common links -- Existing object links -- Create objects -- Browse catalog -- Helpful links -- Administration -- Groups and users -- Privileges -- Full privileges list -- Session management -- Maintenance and troubleshooting -- Issue SQL -- The Presentation Catalog -- Structure of the Presentation Catalog -- Hidden items -- File management -- XML files -- Object copying -- Multiple personal dashboards -- Catalog deployments -- Securing catalog objects -- Permission inheritance -- Practical steps to object security -- A review - what I should now know! -- Summary -- 10. Creating Dashboards and Analysis -- Analysis versus Reporting -- Creating an Analysis -- Analysis Editor -- Criteria Tab -- The Results tab -- Filters -- Selection Steps -- Saving an Analysis -- Basic table formatting -- Bins -- Pivot Tables -- Graphs -- Sectioned views -- View prompts and section sliders -- Conditional Formatting -- Building Dashboards -- Creating a dashboard -- Dashboard builder -- Editing a dashboard.

Adding a page.