Sumário Itens Encontrados: 536Preface 1Chapter 1: Understanding the Oracle BI 11g Architecture 9Looking backward and looking forward 9Let's look at the big picture 10What is Oracle Fusion Middleware? 11An application server by any other name 12A database repository â for what? 12Overall components 13Java components 14System components 15WebLogic Server 17A few software nuances 17WebLogic Domain 18WebLogic Administration Server 18WebLogic Managed Server 19WebLogic Node Manager 20System tools controlled by WebLogic 21Oracle Process Management and Notification system 22Security 23Backwards compatibility 24Managing by application roles 25Security providers 25Identity Store 25Credential Store 25Policy Store 26System requirements 27Client Tools 27Multiuser Development Environment 28Certification matrix 30Scaling out Oracle BI 11g 30Preconfiguration run down 31Shared storage 31Clustering 31Vertical expansion versus horizontal expansion 32Oracle BI Server (system component) Cluster Controller 32Failover and high availability 33Enterprise deployment guide 33Directory folder structure 34Log files (diagnostics) 34Configuration files 35A review â what I should now know! 36Additional research suggestions 36Summary 37Chapter 2: Installing the Metadata Repository 39Repository Creation Utility (RCU) 39What is the metadata store? 40Technical metadata 40Business metadata 40Process metadata 41Oracle Metadata Services (MDS) 41Repository schemas 42Non-repository metadata 43Downloading the software 43Running the RCU 44Setting up your database 45Oracle 45MS SQL Server 46Preparing for your installation 47Linux 4764 bit Linux 48Standard installation steps 48Adding repositories 60Customizing your installation 61Other common changes 63Schema installations 65Oracle CREATE USER Script 66Silent installation 66Example creation 68Useful scripts 69Usage tracking script 69A review â what I should now know! 71Summary 71Chapter 3: Installing on Windows Server 2008 73Installation media 73System requirements 75Installation 77A review â what I should now know! 91Summary 92Chapter 4: Installation Options 93Oracle BI on its own server 93High availability and failover planning 94Simple versus Software Only Installation 95Software Only Install 95Installing your own JDK 95Simple Install 96Silent installation 96Custom static ports 97Creating your own staticports.ini file 98Installing Oracle BI 11g on *Nix 100Listening on port 80 100Ensuring IIS web server Role Services are installed 102Getting the WebLogic Server Proxy IIS plugins 103Creating and configuring an IIS Website 104Enabling compression in IIS 7.x 107Automate starting and stopping 108Leveraging the WebLogic Server Windows Service installer command 109Creating start-up and shutdown scripts 111Creating desktop shortcuts 113Creating boot.properties files 114Ancillary application integration awareness 115Recommendations for further learning 116A review â what I should now know! 116Summary 117Chapter 5: Understanding the Systems Management Tools 119Let's talk about management tools 119WebLogic Server Administration Control 120First access and checkpoint 121Servers 122Clusters 122Machines, IP address, or DNS 123Data sources or JDBC connections 124Security realms 126WebLogic Server is its own application 128Using WLST 129Enterprise Manager Fusion Middleware Control 131Getting around in EM 132BI Foundation Domain dashboard 132Coreapplication 133The Overview tab 134The Availability tab 134The Capacity Management tab 134The Diagnostics tab 135The Security tab 136The Deployment tab 136Managing Oracle BI 11g artifacts 137Creating a new Presentation Catalog 138Deploying an existing Presentation Catalog 140Deploying an RPD 140Starting/stopping system components 142Checking the logs 143Creating the Tennis users, roles, and associations 144Creating users and groups in WLS 145Assigning users to groups 146Creating and assigning application roles 147Configuring an LDAP identity provider in WLS 149Setting up the identity provider 150Establishing Fusion Middleware Control security linkage 153Restarting the WebLogic Server and Managed Server 156Assigning the LDAP Service Account Role Privileges 158JMS modules for BI Publisher communication 160Refreshing Presentation Catalog GUIDs â sync it up! 160JMX, MBeans, and Java 163Migrating FMW Security to other environments 163FMW core security files 163Project Amelia 164Downloading Project Amelia 164Getting the FMW Security file 165Running the script and generating the WLST script 165Migrating the security script and running it on the target server 166FMW Security Import/Export utility 166Using the Security Realm Migration utility 167Using the migrateSecurityStore function via WLST 168Oracle BI Publisher system management 169Monitoring system performance 169Have a backup plan! 170Recommendations for further learning 170A review â what I should now know! 171Summary 171Chapter 6: Upgrading the RPD and Web Catalog to 11g 173Upgrading an RPD and Web Catalog 173Upgrade Assistant 175Verification 183Upgrading BI Scheduler 184Manual migration 188Consistency check 188Security 189Regression testing 190Unit test 190Full regression testing 191User Acceptance testing 191A review â what I should now know! 192Summary 193Chapter 7: Reporting Databases 195Theories and models 196Reporting databases 197Relational modeling 198Dimensional modelling 198Why is database theory important? 200Designing your database â objectives, rules, and goals 201Objectives 202Rules 202Rule 1 â complete dimensions 203Rule 2 â build generic tables 204Rule 3 â partition large tables 204Rule 4 â prudent indexing 204Rule 5 â aggregate everything 205Rule 6 â constant analysis of usage and accuracy 205Rule 7 â manage statistics 205Rule 8 â understand the granularity 206Goals 206Goal 1 â keep it simple 207Goal 2 â minimize type 2 slowly changing dimensions 207Goal 3 â use data, not functions 207Goal 4 â minimize joins 207Goal 5 â reduce snowflaking 207Goal 6 â make it flexible 208Design summary 208Creating a warehouse 208Source system assessment 208Warehouse design 211Warehouse tables 211Populate and tune 214Monitor and maintain 214Some definitions 215A review â what I should now know! 216Summary 216Chapter 8: Developing a BI Repository 217Prerequisites 218Repository architecture 218Physical layer 218Business layer 218Presentation layer 219Physical layer 219Creating an RPD and importing metadata 219Elements of the physical layer 225Database object 226Connection pools 228Physical catalog and schemas 230Physical tables 230Physical join 232Consistency check 235Table aliases and naming conventions 236Business layer 238Business model 238Logical tables 239Logical table sources 242Logical columns 243Logical joins 246Dimension hierarchies 249Presentation layer 255Subject areas 256Best practices in the presentation layer 258Aliases 260Implicit fact 260Calculated measures 262Logical column calculation 262Expression Builder 264Physical column calculation 266Time series measures 268Level based measure 271Federated and fragmented content 273Vertical federation â aggregation or level based 273Horizontal federation 274Fragmentation 274Fragmentation example â content based 274Variables and initialization blocks 279A review â what I should now know! 286Additional research suggestions 287Summary 287Chapter 9: Features of the Presentation Catalog 289Integrated tools 290Analysis 290Dashboards 291Published reporting 291Actionable Intelligence 291Performance management 292Marketing 292Mapping 293Administration 293Briefing books 293Search 294Help 294Office integration 294The Home screen 294Common links 295Existing object links 295Create objects 296Browse catalog 296Helpful links 296Administration 296Groups and users 297Privileges 298Full privileges list 300Session management 300Maintenance and troubleshooting 303Issue SQL 303The Presentation Catalog 304Structure of the Presentation Catalog 304Hidden items 306File management 306XML files 306Object copying 306Multiple personal dashboards 307Catalog deployments 307Securing catalog objects 307Permission inheritance 309Practical steps to object security 309A review â what I should now know! 310Summary 310Chapter 10: Creating Dashboards and Analysis 311Analysis versus Reporting 311Creating an Analysis 312Analysis Editor 314Criteria Tab 314The Results tab 316Filters 317Selection Steps 320Saving an Analysis 324Basic table formatting 325Bins 328Pivot Tables 332Graphs 337Sectioned views 338View prompts and section sliders 340Conditional Formatting 342Building Dashboards 346Creating a dashboard 346Dashboard builder 347Editing a dashboard 350Adding a page 351Report Links 354Dashboard Prompt 356Presentation variable 361Protected and "is prompted" filters 363Repository/Session variable 364Some advanced options 366Column Selector 366View Selector 368Master-detail linking 371Hierarchical columns 374Security 376Object security 377Data security 379Design â best practices 385Additional research suggestions 386A review â what I should now know! 387Summary 387Chapter 11: Agents and the Action Framework 389Agents 390Actions 399BI navigation 399Web navigation and passing a parameter 402Conditionality 404Note on invoke actions 408A review â what I should now know! 409Additional research suggestions 410Summary 410Chapter 12: Developing Reports Using BI Publisher 411Don't miss the installation integration checkpoint! 412Where BI Publisher excels? 413What's all this XML talk? 413Yes, BI Publisher is now Published Reporting 414Oracle BI Foundation versus Oracle BI Publisher 415New features and enhancements 416Improved Oracle BI 11g look and feel 416Interactive Viewer 416Dynamic upload and source from MS Excel spreadsheets 417Leveraging LDAP user attributes in queries 417Sharing a Presentation Catalog with Oracle BI 11g 417Data Model Editor 417Leverage view objects â Application Development Framework 418Report design basics, terminology, and locations 418Report design components 418Data model 418Layout 419Properties 419Translations 419Where to administrate BI Publisher 419Default embedded BI Publisher configurations 420Where to build a data model 420Where to add a data source connection 420What is a JNDI data source? 421Let's get publishing 422Administration management of BI Publisher 422Accessing the BI Publisher Administration page 422Verifying application roles 423Creating the Tennis data source JDBC connection 424Creating a File (XLS) data source 425Verifying application role data source privileges 426Setting up a data model 426Creating a new Presentation Catalog folder 427Creating a new data model 428Creating a SQL query data set 429Adjusting data set display names 432Creating a parameter 433Creating a list of values 434Connecting the parameter to the list of values 435Getting the sample data 436Creating a BI Publisher report using Layout Editor 438Auditing and monitoring BI Publisher 441Modifying a few configuration files 442Connecting to the Audit Framework 443Enabling Audit Policy in the Fusion Middleware ControlEnterprise Manager 443Viewing the auditing log file 444BI Publisher nuances 445Timeout issues 445Connecting to Oracle BI server data sources 445BI Publisher Application Programming Interface (API) 446BI Publisher Scheduler 446High availability 446A review â what I should now know! 447Additional research suggestions 447Summary 448Chapter 13: Customizing the Style of Dashboards 449What's the idea? 449Multiple skins and styles in one environment 450A strategy for something seemingly simple 451Involve the Marketing department 451Don't boil the ocean 451Speed to implementation 452Build a focus group 452General knowledge and tools 453Third-party tools 454Oracle JDeveloper skinning tool 454BI Consulting Group Identity product 454Hands-on â go time! 455Overview 455Let's talk about tools and assumptions 457Locating existing styles and skins 457Developing/designing a new look and feel 458Getting analyticsRes deployed 459Good artists copy, great artists steal 462Modifying instanceconfig.xml 464Modifying skins and styles 465Changing the banner color 466Changing the global header menu link's color 466Changing the header separator bar 466Changing the header brand name 467Changing the Login page background 467Restarting Presentation services 467Restarting Presentation services from the command line 468Restarting Presentation services from Enterprise Manager 469Viewing the results 470Configuring a custom message 470Refreshing metadata files and custom messages 472Wrap it up! 473Advanced learning topics 473Firebug 474NetBeans IDE 474Formatting CSS (prettify) 474NQ_SESSION.SKIN and NQ_SESSION.STYLE session variables 474AnalyticsRes Application Caveat 475A review â what I should now know! 475Summary 475Chapter 14: Improving the Performance 477What is poor performance? 477Where can I improve the performance? 478Hardware 479Database 481BI Server 482More performance tips 484The use of cache 484Setting up the cache 485Web servers on top 487Domain setup 487A review â what I should now know! 487Summary 488Chapter 15: Using the BI Admin Change Management Utilities 489Problems with multiple developers 489Merges 490Three-way merge 490Two-way merger 494Multi-User development 494Online development 495Advantages and disadvantages 498Multi-User development 498Advantages and disadvantages 506A review â what I should now know! 507Additional research suggestions 507Summary 507Chapter 16: Usage Tracking 509What is usage tracking? 509System setup 510Setting up the database table 510Additional data 511Setting up the BI Server repository 512Updating the BI Server's configuration file 513Analyzing the usage 516Usage measures 516A review â what I should now know! 519Summary 519Chapter 17: Oracle Essbase and OLAP Integration 521A bit about OLAP 521Competition 522MOLAP, ROLAP, HOLAP, XOLAP 522Essbase's entrenched past 523Oracle Essbase Studio 524Oracle BI SampleApp v107+ â VM image 524Getting started â let's get set up 525Prepping the VM image 525Starting the virtual machine image 526Starting up Essbase 526Starting up Essbase Administration Services (EAS) 527Prepping Essbase 528Creating the base Essbase application and database 528Migrating the Essbase files 531Validating the Outline 531Loading data into the cube 532Anything needed to prep the Oracle BI Server? 533Modeling Essbase into Oracle BI 534A bit of Essbase to Oracle BI knowledge 534Importing Essbase as a data source 535A few OLAP adjustments before modeling 536Flattening the Measure dimension 537Getting the UDAs 538Dimension and hierarchy types 538Getting a quick win 540Incremental importing of Essbase metadata 541Federation of data 543Oracle BI/EPM roadmap 543Workspace integration 544Software license combo 544A review â what I should now know! 544Additional research suggestions 544Summary 545Appendix A: Programs and Definitions 547Stress testing 548XML â a better approach 553biserverxmlgen 553biserverxmlexec 554biserverxmlcli 555Working example using XML 556More repository management 558Admin tool 559A review â what I should now know! 561Summary 562Appendix B: Useful Resources: Join the Oracle BI Movement 563This book's resources 563OBI11gBook.com forums 563Author blogs 564Other Oracle BI practitioner blogs 564Oracle development team blogs 564Oracle BI user groups 565Oracle Development Tools Users'Group (ODTUG) 565Oracle Applications Users'Group (OAUG) 565Independent Oracle User Groups (IOUG) 566International Oracle Users'Group Community (IOUC) 566Conferences 566Oracle Open World (OOW) 566COLLABORATE 567KScope 567RittmanMead BI Forum 567Join the movement 568Further reading 568Summary 569