Bridge Specifications
| Vendor | Oracle |
| Tool Name | Oracle Hyperion Essbase |
| Tool Version | 9.3 |
| Tool Web Site | http://www.oracle.com/technetwork/middleware/essbase/overview/index.html |
| Supported Methodology | [Business Intelligence] Data Store (OLAP Dimensional Model) via Java API |
SPECIFICATIONS
Tool: Oracle / Oracle Hyperion Essbase version 9.3 via Java API
See http://www.oracle.com/technetwork/middleware/essbase/overview/index.html
Metadata: [Business Intelligence] Data Store (OLAP Dimensional Model)
Component: HyperionEssbase version 11.2.0
OVERVIEW
This import bridge imports the Essbase Database Outline metadata from a remote Hyperion Essbase server. The import bridge relies on the Analytic Provider Services (APS) Java api to import the metadata. Therefore, the Analytic Provider Services (APS) must be properly installed and configured on the Hyperion Essbase server machine, or another server on the network.
REQUIREMENTS
n/a
FREQUENTLY ASKED QUESTIONS
Q: What Essbase version does this import bridge support?
A: Version 9.3 is supported. Version 11.x is not yet supported.
LIMITATIONS
Refer to the current general known limitations at https://metaintegration.com/Products/MIMB/Help/#!Documents/mimbknownlimitations.html
SUPPORT
Provide a troubleshooting package with:
- the debug log (can be set in the UI or in conf/conf.properties with MIR_LOG_LEVEL=6)
- the metadata backup if available (can be set in the Miscellaneous parameter with -backup option, although this common option is not implemented on all bridges for technical reasons).
Q: How do I provide metadata to the support team to reproduce an issue?
A: Provide the following files:
The database outline is located on the Essbase server in a .OTL file, deployed in a directory representing the database's application, e.g.
in version 9.x, it may be C:\Hyperion\AnalyticServices\app\Demo\Basic\Basic.otl
Bridge Parameters
| Parameter Name | Description | Type | Values | Default | Scope |
| Provider | Specify here the URL of the Essbase Analytic Provider Services (APS), e.g. 'Embedded' Connect directly to an Essbase OLAP server. 'http://localhost:13080/aps/JAPI' Connect via the Provider Services middle tier. |
STRING | http://localhost:13080/aps/JAPI | Mandatory | |
| Server | Specify the Essbase OLAP server name, e.g. 'localhost' 'http://localhost:13080/aps/Essbase?ClusterName=CLUSTER1&SecureMode=yes' Connect via an Active/Passive Essbase Cluster. |
STRING | localhost | Mandatory | |
| Username | Specify here the user name to connect to the OLAP server. | STRING | admin | Mandatory | |
| Password | Specify here the user password to connect to the OLAP server. | PASSWORD | |||
| Application | Specify here the Essbase Application name to import. | REPOSITORY_MODEL | Demo | Mandatory | |
| Database | Specify here the Essbase database name to import. | REPOSITORY_MODEL | Basic | Mandatory | |
| Essbase API Path | Directory on the file system where the Essbase Analytic Provider Services (APS) libraries are located. For example: In version 11.x, it may be in C:\oracle\Middleware\EPMSystem11R1\common\EssbaseJavaAPI\11.1.2.0\lib In version 9.x, it may be in C:\Hyperion\products\Essbase\aps\lib |
DIRECTORY | Mandatory |
Bridge Mapping
| Meta Integration Repository (MIR) Metamodel (based on the OMG CWM standard) |
"Oracle Hyperion Essbase - Unsupported Beta Bridge" Metamodel HyperionEssbase |
Mapping Comments |
| BaseType | Datatype | |
| DataType | See datatype conversion array | |
| Name | Derived from the datatype | |
| PhysicalName | Derived from the datatype | |
| Cube | Database | Represents the Database Cube Outline |
| Description | Description | |
| Name | Name | |
| CubeDimensionAssociation | Dimension | Connects the cube to its dimensions |
| Name | Name | |
| DerivedType | Datatype | Datatype for Dimension Members |
| DataType | See datatype conversion array | |
| Name | Derived from the datatype | |
| PhysicalName | Derived from the datatype | |
| UserDefined | set to FALSE | |
| Dimension | Dimension | |
| Name | Name | |
| Type | Type | set to TIME for the Time Dimension |
| UserDefined | set to True | |
| DimensionAttribute | Dimension | Represents the dimension root member |
| Description | Description | |
| Name | Name | |
| Position | LevelNumber | |
| Measure | Dimension Member | Represents the members of the Account dimension |
| Name | Name | |
| OlapSchema | Database | |
| Name | Name | |
| StoreModel | Database | The model is built using the Essbase Database metadata |
| Description | Description | |
| Name | Name |