Hi,
As Oracle Essbase is the underlying database of the Hyperion Application, I would create a Multidimensional data source to connect the Hyperion application using the Oracle Essbase API from the Denodo Platform.
You could refer to the sections [Multidimensional Data Sources to Oracle Essbase](https://community.denodo.com/docs/html/browse/8.0/en/vdp/administration/creating_data_sources_and_base_views/multidimensional_database_sources/multidimensional_database_sources#multidimensional-data-sources-to-oracle-essbase) of the Virtual DataPort Administration Guide and [Installing the Connector for Oracle Essbase](https://community.denodo.com/docs/html/browse/8.0/en/platform/installation/postinstallation_tasks/postinstallation_tasks_in_virtual_dataport/installing_the_connector_for_oracle_essbase#installing-the-connector-for-oracle-essbase) of the Denodo Platform Installation guide which explains how to retrieve data from the Oracle Essbase using Essbase API.
You could also refer to the similar community Q&A [Connect Essbase to denodo connection](https://community.denodo.com/answers/question/details?questionId=9060g0000000AKOAA2&title=Connect+Essbase+to+denodo+connection) for more information.
Hope this helps!