This is a text description of allqueri.gif.

Communications between OLAP applications and the RDBMS are through JDBC or OCI. There are four basic types of application:

OLAP API applications use the OLAP SQL Generator, which translates Java data requests into SQL SELECT statements. Access to workspace data is through relational views. Table functions and object types create an interface between the OLAP engine and the relational views. 

Generic SQL applications use standard SQL SELECT statements. Access to workspace data is through relational views. Table functions and object types create an interface between the OLAP engine and the relational views.

OLAP-aware SQL applications use SQL SELECT statements with embedded table functions to access multidimensional workspace objects.

Direct SQL applications use the DBMS_AW package in PL/SQL and the FETCH command in the OLAP DML to communicate directly with the OLAP engine and manipulate multidimensional workspace objects.