Oracle
1Z0-591 · Question #72
Which language is used by OBIEE to query Essbase?
The correct answer is C. MDX. The Essbase cube looks just like any other relational star schema in my Presentation Layer, however when it is queried Oracle BI Server will issue MDX queries against a multi-dimensional data source, rather than an SQL query against a relational star schema.
Extending the Oracle BI Server
Question
Which language is used by OBIEE to query Essbase?
Options
- ASQL
- BLINQ
- CMDX
- DDMX
How the community answered
(24 responses)- A13% (3)
- B4% (1)
- C79% (19)
- D4% (1)
Explanation
The Essbase cube looks just like any other relational star schema in my Presentation Layer, however when it is queried Oracle BI Server will issue MDX queries against a multi-dimensional data source, rather than an SQL query against a relational star schema.
Topics
#Essbase#MDX#multidimensional query#OLAP connectivity
Community Discussion
No community discussion yet for this question.