Past Webinars

Common Table Expressions are a SQL coding technique supported by Oracle, Db2, SQL Server and others. 

Common Table Expressions are also referred to as CTEs, the WITH clause or Subquery Query Factoring clauses.

Think subquery, SQL within a SQL statement when thinking of CTEs. A CTE can be a useful SQL coding 

technique for code containing subqueries to make your code more readable and possibly to make your code 

more efficient, two great benefits.

Oracle 21c and 23c offer us some interesting SQL and PL/SQL enhancements. What did we miss in 21c

and what can we look forward to in 23c? There is help in both versions. In this free webinar, 

Oracle Certified Professional DBA and Certified Technical Trainer John Mullins from ProTech Training 

presents a look at some of those new features and what benefits we might expect from them while discussing 

their implementation. This webinar targets all job roles.

See each of my favorite new features of Webi v4.3

This presentation will be a live demo of these awesome features.

These Include:

This live demo will highlight the new additional data providers including:

• Universes
• Excel/Text
• Free Hand SQL
• WebiIntelligence Document
• Google Sheet
• Web Services

With the new version of Webi, we no longer have the Analysis Tab available to us.

This live demo will highlight the major reporting functions under v4.3 SP 2

The functions will include:

This presentation will provide an in depth look at creating formulas and variables in your report.  In v4.3 SP 2 the calculation feature has changed. 
You will learn how to utilize formulas and variables with its new look.  You will learn how to  create string based calculations, numeric based calculations, and date based calculations.

This Webinar is designed for all users of computers, mobile devices, networks, and the Internet, to enable them to use technology more securely and minimize digital risks, regardless of technical ability. Every employee that holds an email address for your organization should take this course. Vendors who are managing your marketing, human capital, or social platforms should take CyberSAFE. Hackers cast a wide net simply waiting for a single wrong click.

A single click can lead to a multimillion dollar breach in seconds, and the employee responsible may not even know they made a mistake. Many end users are not aware of the dangers accompanying today’s most common cybersecurity threats such as phishing, much less how to detect them. CyberSAFE helps ensure that all users can identify the common risks associated with using conventional end-user technology, as well as how to safely protect themselves and their organizations from security risks in the office or when working remotely.

This presentation will provide Tips and tricks in he following topics!
Creating a Banner in your report
Ranking/Sorting on Sub Totals 
Removing/Adding Break header and Footers with Multiple Breaks
Shading Sub Total Rows
Hiding detail blocks in a Sectioned Report
Adding Stop Lights To your Sectioned Report
Using Conditional Formatting in a Sectioned Report         

It will also include a Q and A session as well.
 

BusinessObjects Web Intelligence SP 4.3 SP 2 was officially released in mid-December with a completely new look and feel.  The BI Launchpad has a new Fiori like appearance.  Navigating has changed dramatically.  The Query Panel has some nice improvements to its look and feel.