What does tool generate in submitting queries that might include data stored in relational tables and OLAP cubes?

Your BI tool (for example, Oracle Business Intelligence Enterprise Edition Plus, Business Objects
and Cognos) will be used to query an Oracle database that includes the Oracle OLAP Option.
What does tool generate in submitting queries that might include data stored in relational tables
and OLAP cubes?

Your BI tool (for example, Oracle Business Intelligence Enterprise Edition Plus, Business Objects
and Cognos) will be used to query an Oracle database that includes the Oracle OLAP Option.
What does tool generate in submitting queries that might include data stored in relational tables
and OLAP cubes?

A.
SQL

B.
PL/SQL

C.
Proprietary API code

D.
SQL for relational and proprietary API code for OLAP

Explanation:
DBMS_CUBE PL/SQL Package. In Database 11gR2, a new feature was added that
allows cubes and dimensions to be entirely defined via PL/SQL calls, thus making it a much
simpler job to automate the creation and refresh of cubes within the context of an application.

Show Hint

Leave a Reply 2

Your email address will not be published. Required fields are marked *

Ali Abu ibn bender bei

Ali Abu ibn bender bei

A. is correct answer. BI tool can use data from different data sources (Ms SQLS,ORACLE,DB2 and etc.) and should use more common approach to extract the data. Just SQL is more suitable in this case, moreover database optimizer automatically aware of cube if it has already been exists.

Reply

Esteban

Esteban

Ali is right!!, the correct answer is A.SQL

Reply