1 / 26

Alvin Daniel Senior Product Manager Oracle Discoverer Oracle Corporation

Alvin Daniel Senior Product Manager Oracle Discoverer Oracle Corporation. Session 40154. Best Practices in Building a BI Dashboard in Portal with Discoverer. Alvin Daniel Senior Product Manager Oracle Corporation. Agenda. Overview of the Discoverer Solution Architectural Underpinnings

dale
Download Presentation

Alvin Daniel Senior Product Manager Oracle Discoverer Oracle Corporation

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

  1. Alvin DanielSenior Product Manager Oracle Discoverer Oracle Corporation

  2. Session 40154 Best Practices in Building a BI Dashboard in Portal with Discoverer Alvin DanielSenior Product Manager Oracle Corporation

  3. Agenda • Overview of the Discoverer Solution • Architectural Underpinnings • Putting it all together: building a dashboard • Maximum Scalability & Performance

  4. Overview of Discoverer

  5. Discoverer Product Family • Discoverer Administrator 10gManage metadata, security, and performance • Discoverer Plus 10gCreate ad-hoc queries, analytics, and graphs • Discoverer Viewer 10gPivot, drill, and export existing queries

  6. Single User Interface Desktop Edition (C/S) Plus (Java) Viewer (HTML)

  7. Discoverer Portlets Worksheet Portlet: Graph Worksheet Portlet: Crosstab List of Workbooks Portlet

  8. Architecture

  9. 10g Database Discoverer Admin. Oracle Application Server Plus Viewer Discoverer Architecture • Dynamic results, database is a single source • Enforces database and Applications security • Each session uses “smart” middle-tier caching • Scalable n-tier design, fast performance

  10. Database 10g Plus Viewer Discoverer Portal Integration • Web Portlet Provider • Java Servlet • Provides access to worksheets, workbooks, etc. through a Portal wizard • Persistently manages portlet contents • Single Sign-On • Traditional “userid/pwd@db” and EUL now called a connection • SSO user can have multiple Discoverer connections associated • Also support Applications login • Supported outside of Portal too Oracle Application Server : Portal, Discoverer

  11. New Interactions with Discoverer • Portal gives context for Discoverer information • Portal integrates Discoverer at the information level • Portal publishes Discoverer information to communities

  12. D E M O N S T R A T I O N Building the Dashboard

  13. New Benefits • Publishing • Personalization • Promotion

  14. New Benefits- Publishing • Publish with All Discoverer Benefits • Still “connected” to Discoverer • Information is still managed, performant • Information is still secure • Covers All Scenarios • Single view (traditional web site) • Public/private view (public community site) • Per-user view (customer account site) • Flexible view (everything else!)

  15. New Benefits- Personalization • Supports Portal “customization” framework • Self-service customization without touching Discoverer • Re-usable ROI

  16. New Benefits- Promotion • Increase Portal site usage • Users want real content • Users want maximum personalization • Increase Discoverer usage • All users become Discoverer users • Click-throughs launch Discoverer at “full-power” • Self-sustaining cycle • Good content = more Portal users • More Portal users = more Discoverer users • More Discoverer users = more good content • lather, rinse, repeat...

  17. Maximizing Scalability & Performance

  18. Maximizing Scalability & Performance • Eliminate redundant queries by sharing results • Eliminate redundant queries by remembering results

  19. Database 10g Oracle Application Server “What’s up?” “What’s up?” “What’s up?” “What’s up?” “What’s up?” “What’s up?” “What’s up?” “What’s up?” The Ultimate BI FAQ • Today, users run queries to see “what’s up?” • User A & B each run the same weekly sales report • Why answer one question N times?! • Users may have different security • Users may need different customizations

  20. Database 10g Oracle Application Server The Ultimate BI FAQ • Today, users run queries to see “what’s up?” • User A & B each run the same weekly sales report • Portlet Provider acts like a “smart” cache • If users A & B run it using the same customizations, we fetch from cache • Complete transparency, zero delay “What’s up?”

  21. Database 10g Oracle Application Server The Ultimate BI FAQ • Today, users run queries to see “what’s up?” • User A & B each run the same weekly sales report • If users A & B run it using the same customizations, we fetch from cache weekly • If users A & B reload the page every 10 minutes, the report’s query is not re-executed • If users A & B want “live” results, click-through to Discoverer “What’s up?”

  22. Maximizing Scalability & Performance • Eliminate redundant queries by sharing results • Eliminate redundant queries by remembering results • Optimize user behavior • Essential information always on hand • Users are more focused when they ask deeper questions

  23. Summary

  24. Discoverer Portal Integration • Synergy- each promotes the other • Publishing without “disconnecting” • Security • Management, performance • Increase ROI through personalization • Increased scalability by optimizing user behavior

  25. Q & Q U E S T I O N S A N S W E R S A

More Related