M
mwalton@microstrategy.com
Guest
Informix 12 adds supports for OLAP functions: http://www.oninit.com/presentations/v12.pdf Please add support for these functions in the Informix Wire Protocol driver. The native Informix ODBC driver already supports the functions. Currently when running SQL with the rank function we get the following message: SQLExecDirect. [HY000:-9272: on SQLHANDLE] [MicroStrategy][ODBC Informix Wire Protocol driver][Informix]-9272 Sample SQL: select a12.quarter_id quarter_id, max(a14.quarter_desc) quarter_desc, a13.region_id region_id, max(a15.region_name) region_name, sum(a11.TOT_DOLLAR_SALES) WJXBFS1, rank() over ( partition by a12.quarter_id order by sum(a11.TOT_DOLLAR_SALES) asc, a13.region_id asc ) WJXBFS2 from day_ctr_sls a11, lu_day a12, lu_call_ctr a13, lu_quarter a14, lu_region a15 where a11.day_date = a12.day_date and a11.CALL_CTR_ID = a13.CALL_CTR_ID and a12.quarter_id = a14.quarter_id and a13.region_id = a15.region_id group by a12.quarter_id, a13.region_id
Continue reading...
Continue reading...