Folks,

I will be doing our next Informix Webcast on:

Informix OLAP and Advanced SQL Functions by Lester Knutsen
 - Thursday, March 7, 2019 at 2:00pm EST

Informix includes many Advanced SQL OnLine Analytical Processing (OLAP) functions that are rarely used, and we will demonstrate how to take advantage of them. OLAP is Business Intelligence queries that allow users to perform reporting for sales,
marketing, inventory control, business processes, and many other functions. Typically it would require a multi-dimensional database. SQL OLAP functions allow you to roll-up, roll-down and slice and dice your data.  We will demonstrate examples of Window
Partitioning of data (before and after group by), Ranking, using row numbers, and before and after rows using ANSI SQL-99 standards, known as the “Elementary OLAP” package.

More info and registration at https://advancedatatools.com/Informix/NextWebcast.html

Regards - Lester

--
______________________________________________________________________
Lester Knutsen lester@advancedatatools.com
Advanced DataTools Corporation Voice: 703-256-0267 x102
Visit our Web page: http://www.advancedatatools.com ______________________________________________________________________

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)