How to express SQL3/OLAP analysis functions by ORACLE9iR2 DML ?

From: firegoddess <dr_zhhl_at_sina.com>
Date: Fri, 9 May 2003 17:24:24 +0800
Message-ID: <b9fs8o$5ud$1@mail.cn99.com>

hi, all:

SQL3/OLAP have introduced many powerful analysis functions for OLAP, such as Ranking, windowing aggregate, LAG/LEAD and etc. Now, they are supported by ORACLE9iR2 data warehouses. Meanwhile ORACLE developed another multidimensional query language DML for ORACLE9iR2 multidimensional analysis engine 'analysis workspace'. I am not familiar with DML. My questions is that whether the functionality provided by SQL3/OLAP is supported by DML in the way of multdimensional paradigm or not? Especially 'windowing aggregate'. and How ?

thank you in advance!

jack dull Received on Fri May 09 2003 - 04:24:24 CDT