Using the Adapter for Essbase


The Adapter for Essbase allows applications to access Essbase data sources. The adapter converts application requests into native Essbase statements and returns optimized answer sets to the requesting application.

The Adapter for Essbase provides access to Hyperion Cubes from a server running on Microsoft Windows or UNIX. Essbase can only be accessed using an API supplied by the vendor. It is not possible to gain access using Direct SQL (Direct Passthru in server terminology) or the Adapter for ODBC.

Note: The level of User and Group Permissions for Applications/Databases required by Essbase 11.1.2 in order to be able to read the Database Outline was changed to the Access Database/Database Manager Level. All Reporting Server requests against Essbase read the Database Outline and, therefore, require this level of permissions.