Chapter 4 “Using OLAP,” contains documentation errors, which are corrected in the next version of the Sybase IQ Performance and Tuning Guide:
Cube example 1 column headings have been corrected to match the example syntax: avg salary column head now reads AVERAGE.
Cube example 2 column headings have been corrected to match the example syntax: state now reads c_state, sex now reads c_gender, dept_id now reads c_dept, count now reads count(*), and avg salary now reads AVERAGE.
In “Windowing” under “Analytic functions,” the following syntax is repeated in two locations:
OLAP_FUNCTION() OVER (PARTITION BY col1, col2...)
The redundant paragraph and syntax will be removed in the next version.
In “An OLAP window’s three essential parts,” the first line of the syntax contains a repeated word, WINDOW, in the window definition list. The second instance will be removed in the next version.
In “Ascending and descending order for value-based frames” the syntax is incorrect and should be ordered by DESC instead of ASC. The corrected syntax should read as follows:
ORDER BY year DESC range BETWEEN CURRENT ROW and 1 FOLLOWING
In “Windowing aggregate functions,” “Windowing aggregate example 1” contains two errors. Column head Year should be Y, and the dates in the discussion output should match the syntax; 1993 should be 2000 and 1994 should be 2001.
In “Windowing aggregate functions,” “Windowing aggregate example 2” contains incorrect column headings. Employee should say E_name and Salary should say Sal.