Mombu the Programming Forum

Go Back   Mombu the Programming Forum > Programming > Oracle OLAP
User Name
Password
REGISTER NOW! Mark Forums Read




Reply
1 27th March 15:05
jangolan
External User
 
Posts: 1
Default Oracle OLAP



I am having problems setting up the Oracle 9.4.0.2.1 Olap version. I
can create an Analytic Workspace in the database. I also am able to
query this database with the Analaytic Workspace Manager.

However I can not connect to the database with the BI Beans. I get the
following error message. Although the database connection succeeded,
the metadata in the OLAP Catalog is not valid and could not be
retrieved. In order to create OLAP queries against the database, you
must ensure that the OLAP Catalog metadata is valid.

I have ran the tool in the Analytic Workspace Manager to enable for BI
Beans.

Also here is a listing from the BI Beans Check Config tool:

BI Beans Diagnostics(v1.0.0.0) 3/3/04
================================================== ===========================
JDEV_ORACLE_HOME ............................. = C:\JDeveloper
JAVA_HOME .................................... = C:\JDeveloper\jdk
JDeveloper version ........................... = 9.0.3.4.1247
BI Beans version ............................. = 9.0.3.6.0A
BI Beans internal version .................... = 2.7.0.13.1
Connect to database .......................... = Successful
JDBC driver version .......................... = 9.2.0.3.0
JDBC JAR file location ....................... =
C:\JDeveloper\jdbc\lib
Database version ............................. = 9.2.0.4.0
OLAP Catalog version ......................... = 9.2.0.4.1
OLAP AW Engine version ....................... = 9.2.0.4.1
OLAP API Server version ...................... = 9.2.0.4.1
BI Beans Catalog version ..................... = 2.7.0.13.1
OLAP API JAR file version .................... = 9.2
OLAP API JAR file location ................... =
C:\JDeveloper\jdev\lib\ext
Load OLAP API metadata ....................... = Unsuccessful

Thanks,
Josh Angolano
Sr. Programmer / Analyst
IFMC
  Reply With Quote


 


2 27th March 15:07
jon mead
External User
 
Posts: 1
Default Oracle OLAP



Josh,

How did you populate the Analytic Workspace - was it from a relational
schema and OLAP metadata, or by either creating or importing AW objects?

Regards,

Jon
  Reply With Quote


 


Reply


Thread Tools
Display Modes




666