1 / 26

Oracle Business Intelligence SIG: OBIEE Administration

Oracle Business Intelligence SIG. Introduction Roll CallOBIEE for Dummies, Reference for the Rest of UsA Little Something for the Techies SPIN Control for Project SponsorsStatements of Direction from OracleQ

lyndon
Download Presentation

Oracle Business Intelligence SIG: OBIEE Administration

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

    2. Oracle Business Intelligence SIG Introduction Roll Call OBIEE for Dummies, Reference for the Rest of Us A Little Something for the Techies SPIN Control for Project Sponsors Statements of Direction from Oracle Q&A Networking

    3. Introduction Kofi Singleton Sr. Principal Consultant Optimum Solutions OBIEE Implementations BI for APPS Standalone OBIEE Fusion Intelligence BI Publisher Supporting Technologies Application Server 10.1.3.x Web Center / Webroot Portlets Application Server 10.1.2/4 Portal / JSR-168 via WSRP 10.2 DB Informatica / DAC Industries Education

    4. Roll Call Group: Small/Med Business Owners Technology Evaluators for a larger firm New to Business Intelligence New to OBIEE, but experienced in Business Intelligence I know this better than you do, Kofi!! Find a Cohort Group Elect a Captain Now, Whats your problem?!

    5. OBIEE Overview Oracle Business Intelligence Server Dashboard Answers (ad hoc query and analysis) Delivers (proactive detection and alerts) Publisher Disconnected Analytics Server Administrator

    6. Something for the Techies About Architecture & Additional Data Sources Web Catalog Manager Administrator and RPD Plumbing underneath BI for Apps Informatica ETL & DAC Security Oracle Support Partner Support

    7. BI Apps Architecture

    8. Web Catalog Overview Role based dashboards Covering more than 100 roles Navigation Most reports have at least one level of navigation embedded Drill to details from many interactive elements, e.g. chart segments Guided Navigation Conditional navigational links Analytic Workflows Action Links Direct navigation from record to transactional while maintaining context Alerts Scheduled and Conditional iBots Highlighting Conditional highlighting that provides context on metrics (is it good or bad?)

    9. OBI EE Vs OBI Apps Admin

    10. Physical to Business Model

    11. Business Model to Presentation

    12. OBI Apps Plumbing

    13. OBI Apps Plumbing

    14. OBI Apps Plumbing

    15. Informatica Repository Console

    16. DW Application Console (DAC) Minimize installation, setup, and configuration time Create a physical data model in the data warehouse Set language, currency, and other settings Design subject areas and build execution plans Manage metadata driven dependencies and relationships Generate custom ETL execution plans Automate change capture for the Siebel transactional database Capture deleted records Assist in index management Perform dry runs and test runs of execution plans Provide reporting and monitoring to isolate bottlenecks Perform error monitoring and email alerting Perform structured ETL analysis and reporting Utilize performance execution techniques Automate full and incremental mode optimization rules Set the level of Informatica session concurrency Load balance across multiple Informatica servers Restart from point of failure Queue execution tasks for performance (See Figure 2-2.) Minimize installation, setup, and configuration time Create a physical data model in the data warehouse Set language, currency, and other settings Design subject areas and build execution plans Manage metadata driven dependencies and relationships Generate custom ETL execution plans Automate change capture for the Siebel transactional database Capture deleted records Assist in index management Perform dry runs and test runs of execution plans Provide reporting and monitoring to isolate bottlenecks Perform error monitoring and email alerting Perform structured ETL analysis and reporting Utilize performance execution techniques Automate full and incremental mode optimization rules Set the level of Informatica session concurrency Load balance across multiple Informatica servers Restart from point of failure Queue execution tasks for performance (See Figure 2-2.)

    17. DW Application Console (DAC) DAC is a metadata driven administration and deployment tool for ETL and data warehouse objects Used by warehouse developers and ETL Administrator Warehouse Deployment Application Configuration Manages metadata-driven task dependencies and relationships Allows creating custom ETL execution plans Allows for dry-run development and testing Execution Enables parallel loading for high performance ETL Facilitates in index management and database stats Automates change capture for Siebel OLTP Assists in capturing deleted records Fine grain restartability Monitoring Enables remote admin and monitoring Provides runtime metadata validation checks Provides in-context documentation

    18. Informatica & DAC

    19. Extraction

    20. Load

    21. Security Object Security What parts of the application can you see? Business Logic Object Security Controls access to Subject Areas, Tables and Columns EBS to OBIEE Responsibility Mapping Web Object Security Limits access to Dashboards, Reports and Web Folders Query Blocking Specified combinations of columns in queries can be blocked from running and the user is notified of the illegal query

    22. Oracle Statement of Direction Informatica and Oracle Data Integrator (formerly Sunopsis) to be supported Informatica PowerCenter OEM distribution extended together with full support for existing customer, including new Informatica versions Informatica use: any sources, any extension of BI Applications, must be used to target BI Applications Oracle Data Integrator (ODI) Plan to offer as alternative to Informatica Full ongoing support for both Informatica and ODI DAC to support both Informatica and ODI

    23. Spin Control for Project Sponsors Why OBIEE? Tell me about Total Cost of Ownership Just how long does this take? How do I get started? Strategic Roadmap Just how technical does my team need to be? How can I involve executives and business users? Is there anyone who can help? Part-Time? Full-Time? Is there a set Methodology for accomplishing this?

    24. Questions & Answers PM Slide, Overview needs to be shorter, Brand it a little (#Booth), Draft of Stuff for techies, timing.PM Slide, Overview needs to be shorter, Brand it a little (#Booth), Draft of Stuff for techies, timing.

    25. Optimum Session Presentations

    26. Contact Information

    27. Thank You

More Related