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…

The correct answer is A. SQL. 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…

Advanced Concepts

Question

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?

Options

ASQL
BPIVSQL
CProprietary API code
DSQL for relational and proprietary API code for OLAP

How the community answered

(39 responses)

A
74% (29)
B
3% (1)
C
8% (3)
D
15% (6)

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.

Topics

#Oracle OLAP#SQL generation#BI tools#OLAP cubes

Community Discussion

No community discussion yet for this question.

Full 1Z0-515 Practice