becki14's picture
From becki14 rss RSS  subscribe Subscribe

Developing Advanced Thin Client Applications with BI Beans 

Developing Advanced Thin Client Applications with BI Beans

 

 
 
Tags:  software configuration management  datamining  bi software 
Views:  464
Published:  December 16, 2011
 
0
download

Share plick with friends Share
save to favorite
Report Abuse Report Abuse
 
Related Plicks
Bug Huntress

Bug Huntress

From: clala
Views: 659 Comments: 0
Bug Huntress
 
See all 
 
More from this user
Boosting Sales

Boosting Sales

From: becki14
Views: 1048
Comments: 0

Parallels PPT Template

Parallels PPT Template

From: becki14
Views: 976
Comments: 0

Business Software On-Demand From GreenAppX

Business Software On-Demand From GreenAppX

From: becki14
Views: 904
Comments: 0

NicoláS Gunther

NicoláS Gunther

From: becki14
Views: 924
Comments: 0

SECTION 3

SECTION 3

From: becki14
Views: 880
Comments: 0

Social Media 101: Online Communication as Stakeholder Engagement

Social Media 101: Online Communication as Stakeholder Engagement

From: becki14
Views: 14032
Comments: 2

See all 
 
 
 URL:          AddThis Social Bookmark Button
Embed Thin Player: (fits in most blogs)
Embed Full Player :
 
 

Name

Email (will NOT be shown to other users)

 

 
 
Comments: (watch)
 
 
Notes:
 
Slide 1: Developing Advanced Thin Client Applications with BI Beans IOUG 2004 Paper 408 Chris Claterbos claterbos@vlamis.com (816) 729-1034 Vlamis Software Solutions, Inc. (816) 781-2880 http://www.vlamis.com Copyright © 2004, Vlamis Software Solutions, Inc.
Slide 2: Vlamis Software Solutions, Inc. • • • • • • Founded in 1992 in Kansas City, Missouri Oracle Certified professional services company Provides business solutions to international and domestic clients based on Oracle technologies. Authorized software reseller Creator of the first Oracle 9i Business Intelligence and Analytics tool. Core competency include: q q q q Certified designers, Developers, Implementers Nationally recognized technical authors, speakers and publishers. Copyright © 2004, Vlamis Software Solutions, Inc.
Slide 3: Who are we? • Chris Claterbos, Consulting & Development Manager q DBA and applications developer for Oracle products, since 1981. q Beta tester and early adopter of - including Oracle 8i and 9i, 9i OLAP, JDeveloper and BIBeans, Oracle 9IAS, Portal (formerly WebDB), and Reports. q Speaker and author. (new Article on OTN May 12th) q IOUG Focus Area Manager for Data Warehousing and BI q Utilized Oracle SQL, Pl/sql, Oracle Forms, Reports, Discoverer, Express, Express Objects, Web Objects, OWB, Designer and Oracle Applications (since version 7). Copyright © 2004, Vlamis Software Solutions, Inc.
Slide 4: In the Past • Previous development of BI and OLAP Applications required proprietary development environment • • • • Each deployment model required a different tool Development effort very labor intensive Concept to Deployment takes long time Requires specialized skills Copyright © 2004, Vlamis Software Solutions, Inc.
Slide 5: Business Intelligence the Old Way • Special purpose engines for differing tasks • Metadata migration tools ease replication • User interfaces generally different for different tools Copyright © 2004, Vlamis Software Solutions, Inc.
Slide 6: BI the New Way: Oracle 9iDB •Single business intelligence platform –Reduce administration, implementation costs –Faster deployment & Improved scalability and reliability Copyright © 2004, Vlamis Software Solutions, Inc.
Slide 7: Oracle OLAP – What Is It? • • • • • • • • Advanced analytics Integrated in RDBMS Common Metadata Easy to develop Easy to use Facilitate collaboration Flexible deployment Scaleable and performant Copyright © 2004, Vlamis Software Solutions, Inc.
Slide 8: Analysis Functions Oracle 9i/10g Supports • • • • • • • Ranking family Window Aggregate Reporting Aggregate family LAG/LEAD Linear Regression family Inverse Percentile family Hypothetical Rank and Distribution family FIRST/LAST Aggregates family Copyright © 2004, Vlamis Software Solutions, Inc.
Slide 9: Query Methods OLAP API Application OLAP API Select … from View/table Generic SQL Application OCI or JDBC Select … from View/table ‘OLAP aware’ SQL Application OCI or JDBC SQL Generator KPRB Select … from view RDBMS View Table Function Select … from OLAP_TABLE •DBMS_AW.EXECUTE •DBMS_AW.INTERP •DBMS_AW.INTERPCLOB Relational Multidimensional Copyright © 2004, Vlamis Software Solutions, Inc.
Slide 10: Oracle OLAP Architecture Rapid application development Analysis ready Java OLAP API Predictive analysis functions Scaleable data store Integrated meta data Summary management SQL analytic functions Copyright © 2004, Vlamis Software Solutions, Inc.
Slide 11: Clarifications * • BI Products with 10g in Names will run using 9.2.0.4.1 DB and above (i.e. do not require 10g Database!) • Minimum DB to run TODAY is 9.2.0.4.1 9.2.0.5 is most current. 10.1.0 also… • Disco 10g does not have OLAP components yet (see more tomorrow @2:15) Copyright © 2004, Vlamis Software Solutions, Inc.
Slide 12: Java OLAP API • Designed for OLAP on the internet q Java, object-oriented q Supports OLAP calculations q Schema independent • The API for analytical tools and applications q Oracle Business Intelligence Beans q Oracle Applications Copyright © 2004, Vlamis Software Solutions, Inc.
Slide 13: Deployment Models • Deploying BI Beans Apps q Thick Java Client – feature Rich! q Thin Client – More limited § JSPs § Servlets § UIXml § Oracle Portal Portlets q Reports 9i OLAP plug-in q Excel Add-in (Summer 2004*) q Discoverer 10g R2 (Summer 2004*) Copyright © 2004, Vlamis Software Solutions, Inc.
Slide 14: Business Intelligence Beans Table Cross Tab Graph Query Builder Excel - Addin Calculation Builder Query Meta Data Manager Connection Oracle9i OLAP Services Oracle9i Persistence Beans Repository Copyright © 2004, Vlamis Software Solutions, Inc.
Slide 15: Architecture: Java clients Oracle Business Components for Java Presentation Beans Analysis Bean - Client Analysis Beans Middle tier Oracle9i OLAP Services BI Beans runtime repository Web Browser Oracle9i BI Beans use of Oracle Business Components for Java: * communications protocol across tiers * deploying iBeans on the middle tier (EJB, 8i) * insulates application developer from “application plumbing” related to deployment Copyright © 2004, Vlamis Software Solutions, Inc.
Slide 16: Architecture: Thin client iAS/Web Server Servlet Engine Servlet BI Beans Analysis Beans Thin Presentation Beans Oracle9i OLAP Services BI Beans runtime repository Oracle9i Copyright © 2004, Vlamis Software Solutions, Inc.
Slide 17: JDeveloper Integration • Single Development tool for Relational and OLAP development • Key design-time integration objectives q Use JDeveloper concepts; extend when necessary q Live data access q Run application objects q Extensive use of Wizards to support rapid development q Leverage BI Beans runtime repository to enable multiple deployment options Copyright © 2004, Vlamis Software Solutions, Inc.
Slide 18: JDeveloper Environment Component Toolbar System Navigator Code Window Structure Window Log Window Copyright © 2004, Vlamis Software Solutions, Inc.
Slide 19: New Version Coming! • BI Beans 10g just around the corner! • Increased capabilities, most significantly in • • • • Thin Client Thin Client can now do what Thick Client can New Wizards – wizard driven creation of JSP! New Thin Client Toolbars Formatted export to Excel Copyright © 2004, Vlamis Software Solutions, Inc.
Slide 20: What Can We Really Do? • VSS Business Analyzer is an example of what can be done • Developed in less than 4 months! • Comprehensive Application that provides Ad-Hoc Query capabilities in both Thick and thin clients • Utilizes a central report catalog available to all client types • Provides an extensible framework for more complex applications See www.vlamis.com for more info… Copyright © 2004, Vlamis Software Solutions, Inc.
Slide 21: Demonstrations Copyright © 2004, Vlamis Software Solutions, Inc.
Slide 22: BI Beans Designer Settings • Container for Business Intelligence Objects • References information needed to connect: q to Oracle 9i OLAP q and the BI Beans Catalog. • Design Settings - Lets you view and edit settings in your BI Designer object • Run Settings - Lets you view and edit settings in your BI Configuration file Copyright © 2004, Vlamis Software Solutions, Inc.
Slide 23: Connection Wizard Walks you through creating an Catalog Connection • Define Connection Name and Type • Login and Password Copyright © 2004, Vlamis Software Solutions, Inc.
Slide 24: Connection Wizard • Specify data source. • Select and Test OLAP Connection Copyright © 2004, Vlamis Software Solutions, Inc.
Slide 25: Presentation Beans • • • Provides common user interface across Oracle BI products Translate UI gestures into OLAP events Graph q Over 50 graph types supported q Customizers for modifying appearance • • • Crosstab/Table q Cell level formatting View toolbar enables simple access to formatting capabilities Customers: Discoverer, Reports, Portal, CRM, Enterprise Planning and Budgeting, Balanced Scorecard ... Copyright © 2004, Vlamis Software Solutions, Inc.
Slide 26: Business Intelligence Wizards • Specialized Wizards Built into JDeveloper 9i q Connection Wizard q Calculation Wizard q Query Wizard q Presentation Wizard q Java Client Application Wizard q Servlet (JSP) Application Wizard Copyright © 2004, Vlamis Software Solutions, Inc.
Slide 27: JDeveloper BI Wizards Copyright © 2004, Vlamis Software Solutions, Inc.
Slide 28: Query Builder • “Brains” behind the presentation beans q Data provider q Data navigation q Data selection • QueryBuilder customizer q Enables end user to specify advanced queries using business terms - not SQL q Save favorite selections • CalcBuilder q Wizard enables creation of new calculations, including: variances, ratios, time comparisons, and more Copyright © 2004, Vlamis Software Solutions, Inc.
Slide 29: Customizer • Alter the look of your presentation. • Add titles and footnotes. Copyright © 2004, Vlamis Software Solutions, Inc.
Slide 30: Customizer • Add data-driven formatting. Copyright © 2004, Vlamis Software Solutions, Inc.
Slide 31: Persistence Services – BI Catalog • Enables end users to save personal analyses or share analyses with other users. • Organizes information in folders • Persisted objects include: q Crosstab, table and graph formatting q Entire queries or individual selections q Calculations • Objects persisted in XML format • Searchable Copyright © 2004, Vlamis Software Solutions, Inc.
Slide 32: Summary • Analysis ready relational database q Analytical functions q Scaleable, manageable • Internet application deployment q Java OLAP API q Business Intelligence Beans and JDeveloper • Open q Java and CWM-compliant meta data q OLAP API and SQL access Copyright © 2004, Vlamis Software Solutions, Inc.
Slide 33: Thick or Thin Client? • Difference Between Thick and Thin Client • Thick Client full featured Gui application (windows-like) • Thin Client HTML based (still full featured) • No Drag & Drop in Thin Client Copyright © 2004, Vlamis Software Solutions, Inc.
Slide 34: Wizards Get You Started • Wizards provided by JDev and BI Beans provide a good start • Choice of JSP or UIX Applications • Build a fully functioning application • Samples provide additional Features that can be added • Simple to change look and feel • Can integrate with existing JSPs Copyright © 2004, Vlamis Software Solutions, Inc.
Slide 35: What Can We Really Do? • VSS Business Analyzer is an example of what can be done • Developed in less than 4 months! • Comprehensive Application that provides Ad-Hoc Query capabilities in both Thick and thin clients • Utilizes a central report catalog available to all client types • Provides an extensible framework for more complex applications Copyright © 2004, Vlamis Software Solutions, Inc.
Slide 36: Building A Thin Client Application Copyright © 2004, Vlamis Software Solutions, Inc.
Slide 37: What Did We Learn? • • • • • JDeveloper Wizards are a great start Samples also helped a lot Neither provided total solution -- Just a start Need to be able to understand Java Doc Not all JDev functions are available to developed app without custom coding. heavy development! • Need to have a Java Guru on staff if you are doing • BI Beans is not a 100% solution – they are still evolving • Don’t be afraid to rollup your sleeves and learn something new! Copyright © 2004, Vlamis Software Solutions, Inc.
Slide 38: How Get Started? / More Information • Java programming q Start with JDeveloper 9i (download from OTN) • BI Beans q Tutorials (In JDeveloper) q Samples (on OTN) q Training (Web and Instructor Led) • Oracle Technology Network q http://otn.oracle.com/products/bib/content.html • Discussion Forums q http://www.oracle.com/forums/forum.jsp?id=828024 • VSS Business Analyzer q www.vlamis.com Copyright © 2004, Vlamis Software Solutions, Inc.
Slide 39: Copyright © 2004, Vlamis Software Solutions, Inc.
Slide 40: Developing Advanced Thin Client Applications with BI Beans IOUG 2004 Paper 408 Chris Claterbos claterbos@vlamis.com (816) 729-1034 Vlamis Software Solutions, Inc. (816) 781-2880 http://www.vlamis.com Copyright © 2004, Vlamis Software Solutions, Inc.

   
Time on Slide Time on Plick
Slides per Visit Slide Views Views by Location