Karen Cannell

Karen Cannell

Director

TH Technology, USA

Biography

Karen is president of TH Technology, a consulting firm providing Oracle technology services, and an Oracle ACE. A mechanical engineer by degree (one of them), she has analyzed, designed, developed, converted, upgraded, enhanced, and otherwise implemented legacy and commercial database applications for over 25 years, concentrating on Oracle technologies. She has worked with Application Express since its Web DB beginnings and continues to leverage Oracle tools to build quality web applications for government, medical, and engineering industries. Karen is an ODTUG Director, Editor Emeritus of the ODTUG Technical Journal, a 2015 Oracle Developer Choice finalist, 2012 ODTUG Volunteer of the Year, and co-author of Expert Oracle Application Express, Agile Oracle Application Express, and Beginning Oracle Application Express 4.2. Karen is an active member of ODTUG, IOUG, RMOUG, and NOUG.

Papers

APEX 18 Interactive Grid: Beyond the Basics

Stream:Database / Technology

You're using Interactive Grids, and have the basics down, so what's next? This session goes beyond interactive grid essentials and covers the extras - charting, alternate views, editable grid alternate processing options, JavaScript customisations and practical use of the grid APIs. We will examine features and attributes of APEX interactive grids that you might not (yet) be aware of. Become familiar with the grid JET charts, and make sure end users know how to use them. Learn when and how to use alternate processing options for editable grids. Become comfortable with customizing the grid interface through declarative attributes, and when necessary through JavaScript using the grid APIs. Learn declarative and customization options to maximize the use of your interactive grids. Gain the knowledge needed to adjust interactive grids to tackle more complex business requirements.

Oracle JET Charts in APEX - Data Viz Now!

Stream:Development / FMW

Are you using JET charts yet? Why not? Oracle JET charts are the new APEX charting engine, are in Interactive Grids and as of APEX 18.1 are in Interactive Reports. This session covers the essentials for becoming comfortable with, even fluent in, Oracle JET charts. Charts add pizazz and impact, and APEX JET charts make it easy. We will introduce JET charts, describe key features and chart types, demonstrate how to build and how to upgrade from earlier APEX versions. We will detail query syntax and chart attributes for common chart types and provide tips on when to use which type for the best visualization impact. Data visualization is 'in' - so attend and become comfortable with adopting JET charts now.

Analytic Views for Mortals: Worth a Look? When and Where

Stream:Development / FMW

Oracle Analytic Views are not just for BI or DW experts - mere mortal developers can leverage this new, no-cost feature of the Oracle 12.2 database. Analytic Views enable simpler SQL statements and improved performance for aggregate and calculation queries - a big advantage for any developer building BI-like reports for data warehouse, business intelligence or other data analysis purpose. Even if you never used Oracle OLAP and/or do not have OBIEE, if you create BI-like queries, Analytic Views deserve a look. This introductory session, geared for a non-Data Warehouse audience, covers: - The basic components of Oracle Analytic Views: Dimensions, Hierarchies, Analytic Views, - How to create and implement Analytic Views atop existing relational tables - Use of Analytic Views in an APEX Bi-like Reporting Application - Effort involved and performance differences Are the promised performance gains of Analytic Views worth the investment of learning and implementing this 12.2 new feature? Attend to learn if, when and where Analytic Views make a difference in your projects.

APEX 18 Interactive Grid: Editable Grid Essentials

Stream:Development / FMW

Looking for advice on upgrading your APEX tabular forms to Editable Interactive Grids? This is your stop: Gain practical guidance on when, why, and how to effectively upgrade tabular forms, simple to highly-customized, to Editable Interactive Grids. Many of us have creatively tailored legacy tabular forms with a combination of PL/SQL collection loops and custom JavaScript. Will these customized tabular forms upgrade? How? Should you upgrade and fix, or rebuild? This session examines the functionality, structure and JavaScript APIs of Interactive Grids with a heavy focus on Editable features and essential upgrade tactics. We will compare Editable Interactive Grid features with equivalent (and/or lacking) features in legacy and custom tabular forms. We will review strategies for typical upgrade scenarios. We will demonstrate how to implement common requirements: checklists, cascading select lists, interactions between columns, navigation between fields, dynamic actions - to see what can be achieved declaratively and where customizations via dynamic actions and/or the Interactive Grid APIs are required. We will recommend strategy for and demonstrate how to achieve simple, complex and multi-row validations, client and server-side. We will explain and show JavaScript methods to access/manipulate data and adjust the Grid menus to meet typical tabular form (now Editable Grid) business requirements. This session is essential for those who have existing tabular forms, plain or highly customized (with PL/SQL and/or JavaScript) and need advice on if, when and how to replicate that tabular form functionality in an Editable Interactive Grid.