Your BI tool will be used to query an Oracle database that includes the Oracle BI tool generate in submitting queries…?

Your BI tool (for example, Oracle Business Intelligence Enterprise Edition Cognos) will be used to
query an Oracle database that includes the Oracle BI tool generate in submitting queries that
might include data stored in cubes?

A.
SQL

B.
PIVSQL

C.
Proprietary API code

D.
SQL for relational and proprietary API code for OLAP

Explanation:
Oracle Business Intelligence Enterprise Edition is most commonly used with the
Oracle Database using SQL as the query language. Although the OLAP cube is a
multidimensional data type, it is represented in the Oracle database as a collection

of relational views and is easily queried by SQL.
Note #1: The wording of the question is strange. SQL can be used and is the first choice. So it
seems to be the best answer.
Note #2: Oracle Business Intelligence Enterprise Edition (OBI EE) is a product suite based
on the OBI EE Server. The OBI EE Server can map a logical business model to
many different physical data sources and present the logical model for query to
variety of client applications including Interactive Dashboards, Answers and Oracle
Business Intelligence Plug-in for Microsoft Office.
Reference: Using Oracle Business Intelligence Enterprise Edition with the OLAP Option to Oracle
Database 11g, Oracle Whitepaper