TIBCO Spotfire installed client is not recognizing the Oracle Essbase connector.
Article ID: KB0081663
Updated On:
| Products | Versions |
|---|---|
| Spotfire Connector for Oracle Essbase | All Versions |
Description
When launching the TIBCO Spotfire installed client, the Oracle Essbase connector as seen in File > Add Data Tables > Add > Connection To: Oracle Essbase is disabled and unavailable (greyed out).
Issue/Introduction
TIBCO Spotfire installed client is not recognizing the Oracle Essbase connector.
Resolution
Oracle ESSBASE - Oracle ESSBASE 9.3, 11.1
Driver - Oracle Enterprise Performance Management System (11.1.2.3.0) Media Pack for Microsoft x64 (64-bit)
The driver must be installed on the machine running the Oracle connector.
AdapterESSBASE.spk and FormsAdapterESSBASE.spk are added in server (Deployment).
Installing the ESSBASE client along with ESSBASE Client C API.
Setting Environmental Variables.
Restart the Spotfire Server, Local System. Launch the TIBCO Spotfire installed client to see ORACLE ESSBASE as a connector.
Go to the Groups and Licenses tab and select the group for which to enable or disable the Oracle ESSBASE license.
Driver - Oracle Enterprise Performance Management System (11.1.2.3.0) Media Pack for Microsoft x64 (64-bit)
The driver must be installed on the machine running the Oracle connector.
Note: The driver has to be downloaded from the Oracle Software Delivery Cloud. This will not work if you download the driver from any other location.
Download instructions:
You will need an Oracle account to be able to download the driver (free of charge).When you reach the Media pack search page, Choose Product Pack: Oracle Enterprise Performance Management System, Platform: Microsoft Windows x64 (64bit). Download EPM System Release 11.1.2.3.0 Client Installers for Microsoft Windows In the Custom Setup screen make sure that both ESSBASE Client and ESSBASE Client C API will be installed.
Set the environment variables: EPMHOME to Oracle Enterprise Management System home, ARBORPATH to the destination folder chosen in the installer, ESSBASEPATH to ARBORPATH, PATH must include %ARBORPATH\bin and %EPMHOME\bin
AdapterESSBASE.spk and FormsAdapterESSBASE.spk are added in server (Deployment).
Installing the ESSBASE client along with ESSBASE Client C API.
Setting Environmental Variables.
Restart the Spotfire Server, Local System. Launch the TIBCO Spotfire installed client to see ORACLE ESSBASE as a connector.
Go to the Groups and Licenses tab and select the group for which to enable or disable the Oracle ESSBASE license.
Additional Information
Use the attached document (Filename:Oracle_ESSBASE_client_installation_checks.doc) as a reference.
Attachments
Feedback
Yes
No
Powered by
