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

have you executed CWM2_OLAP_METADATA_REFRESH.MR_REFRESH ? this
sometimes solves the problem.

julian ford

jangolan (AT) ifmc (DOT) org (Josh Angolano) wrote in message news:<e6d35f6f.0403040710.51a64b96 (AT) posting (DOT) google.com>...

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

Josh Angolano wrote: