Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

error D4O-1015 while connecting with Discoverer Plus OLAP

sandudanaMar 7 2006 — edited Mar 7 2006

Hello everybody,

I am very new to discoverer and OLAP.
On a laptop WindowsXP, 1G RAM, 3GHZ I have installed:
- oracle database 9.2.0.1.0 upgraded to 9.2.07 ; all 9.2.0.7 OLAP patches are applied
- business intelligence 10g 10.1.2.0 (and the BI Tools)
- business intelligence 10g samples version 10.1.2.0.0_c

When I try to connect to Discoverer OLAP to the sample data (user scott, host aspire3000, poer 1521, db homedb) I receive: D4O-1015 error: unable to connect to Oracle OLAP.
Here it is the result of the diagnose:

<?xml version="1.0" encoding="UTF-8" ?>
<D4OCheckConfig version="1.0.0.0">
<Check key="JDK version" value="1.5.0_06"/>
<Check key="BI Beans internal version" value="3.2.1.0.13"/>
<Check key="Discoverer Plus OLAP version" value="10.1.2.07.59"/>
<Check key="Discoverer version" value="10.1.2.45.46c"/>
<Check key="host" value="aspire3000"/>
<Check key="port" value="1521"/>
<Check key="sid" value="homedb"/>
<Check key="user" value="SCOTT"/>
<Check key="Connect to database" value="Successful"/>
<Check key="JDBC driver version" value="10.1.0.3.0"/>
<Check key="JDBC JAR file location" value="\localhost:7777\disco\plus_files\d4o_double.jarjar"/>
<Check key="Database version" value="9.2.0.7.0"/>
<Check key="OLAP API Server version" value="9.2.0.7.0"/>
<Check key="OLAP AW Engine version" value="9.2.0.7.0"/>
<Check key="OLAP Catalog version" value="9.2.0.7.0"/>
<Check key="BI Beans Catalog version" value="CHKCNFG.BID4OCATERRnull"/>
<Check key="Discoverer Catalog version" value="CHKCNFG.BID4OCATERRnull"/>
<Check key="Authorized for Discoverer Plus OLAP catalog" value="No!"/>
<Check key="OLAP API JAR file version" value="9.2"/>
<Check key="OLAP API JAR file location" value="\localhost:7777\disco\plus_files\d4o_double.jarjar"/>
<Check key="Load OLAP API metadata" value="Successful"/>
<Check key="Number of metadata folders" value="2"/>
<Check key="Number of metadata measures" value="48"/>
<Check key="Number of metadata dimensions" value="11"/>
<Check key="OLAP API Metadata">
<![CDATA[==============================================================================
Type Name (S=Schema, C=Cube, M=Measure, D=Dimension) Status
========= ======================================================= ============
Folder... ROOT
Folder... Electronics - Trend Calculations
Measure.. Revenue Successful
S=CS_OLAP, C=SHAWSALES, M=AMOUNT_SOLD
Measure.. Revenue 12 Mo MV Avg Successful
S=CS_OLAP, C=SHAWSALES, M=AMOUNT_SOLD_12MMA
Measure.. Revenue 6 Mo MV Avg Successful
S=CS_OLAP, C=SHAWSALES, M=AMOUNT_SOLD_6MMA
Measure.. Revenue Fcst Best Fit Successful
S=CS_OLAP, C=SHAWSALES, M=AMOUNT_SOLD_FCAST_BF
Measure.. Revenue Fcst Exponential Successful
S=CS_OLAP, C=SHAWSALES, M=AMOUNT_SOLD_FCAST_EXPO
Measure.. Revenue Fcst Linear Successful
S=CS_OLAP, C=SHAWSALES, M=AMOUNT_SOLD_FCAST_LINEAR
Measure.. Revenue Fcst Non-Linear Successful
S=CS_OLAP, C=SHAWSALES, M=AMOUNT_SOLD_FCAST_NLINEAR
Measure.. Revenue Fcst Seasonal Successful
S=CS_OLAP, C=SHAWSALES, M=AMOUNT_SOLD_FCAST_SEASONAL
Measure.. Revenue Fcst Trend Successful
S=CS_OLAP, C=SHAWSALES, M=AMOUNT_SOLD_FCAST_TREND
Measure.. Revenue % Growth Prior Period Successful
S=CS_OLAP, C=SHAWSALES, M=AMOUNT_SOLD_PCT_CHANGE_PP
Measure.. Revenue % Growth Successful
S=CS_OLAP, C=SHAWSALES, M=AMOUNT_SOLD_PCT_CHANGE_YRAGO
Measure.. Cost Successful
S=CS_OLAP, C=SHAWSALES, M=COSTS
Measure.. Cost 12 Mo MV Avg Successful
S=CS_OLAP, C=SHAWSALES, M=COSTS_12MMA
Measure.. Cost 6 Mo MV Avg Successful
S=CS_OLAP, C=SHAWSALES, M=COSTS_6MMA
Measure.. Cost Fcst Best Fit Successful
S=CS_OLAP, C=SHAWSALES, M=COSTS_FCAST_BF
Measure.. Cost % Growth Prior Period Successful
S=CS_OLAP, C=SHAWSALES, M=COSTS_PCT_CHANGE_PP
Measure.. Cost % Growth Successful
S=CS_OLAP, C=SHAWSALES, M=COSTS_PCT_CHANGE_YRAGO
Measure.. Margin 12 Mo MV Avg Successful
S=CS_OLAP, C=SHAWSALES, M=MARGIN_12MMA
Measure.. Margin 6 Mo MV Avg Successful
S=CS_OLAP, C=SHAWSALES, M=MARGIN_6MMA
Measure.. Margin Fcst Best Fit Successful
S=CS_OLAP, C=SHAWSALES, M=MARGIN_FCAST_BF
Measure.. Margin % Growth Prior Period Successful
S=CS_OLAP, C=SHAWSALES, M=MARGIN_PCT_CHANGE_PP
Measure.. Margin % Growth Successful
S=CS_OLAP, C=SHAWSALES, M=MARGIN_PCT_CHANGE_YRAGO
Measure.. Margin % Successful
S=CS_OLAP, C=SHAWSALES, M=MARGIN_PERCENT
Measure.. Quantity Successful
S=CS_OLAP, C=SHAWSALES, M=QUANTITY_SOLD
Measure.. Revenue Successful
S=CS_OLAP, C=SHAWSALES, M=AMOUNT_SOLD
Measure.. Revenue 12 Mo MV Avg Successful
S=CS_OLAP, C=SHAWSALES, M=AMOUNT_SOLD_12MMA
Measure.. Revenue 6 Mo MV Avg Successful
S=CS_OLAP, C=SHAWSALES, M=AMOUNT_SOLD_6MMA
Measure.. Revenue Fcst Best Fit Successful
S=CS_OLAP, C=SHAWSALES, M=AMOUNT_SOLD_FCAST_BF
Measure.. Revenue Fcst Exponential Successful
S=CS_OLAP, C=SHAWSALES, M=AMOUNT_SOLD_FCAST_EXPO
Measure.. Revenue Fcst Linear Successful
S=CS_OLAP, C=SHAWSALES, M=AMOUNT_SOLD_FCAST_LINEAR
Measure.. Revenue Fcst Non-Linear Successful
S=CS_OLAP, C=SHAWSALES, M=AMOUNT_SOLD_FCAST_NLINEAR
Measure.. Revenue Fcst Seasonal Successful
S=CS_OLAP, C=SHAWSALES, M=AMOUNT_SOLD_FCAST_SEASONAL
Measure.. Revenue Fcst Trend Successful
S=CS_OLAP, C=SHAWSALES, M=AMOUNT_SOLD_FCAST_TREND
Measure.. Revenue % Growth Prior Period Successful
S=CS_OLAP, C=SHAWSALES, M=AMOUNT_SOLD_PCT_CHANGE_PP
Measure.. Revenue % Growth Successful
S=CS_OLAP, C=SHAWSALES, M=AMOUNT_SOLD_PCT_CHANGE_YRAGO
Measure.. Cost Successful
S=CS_OLAP, C=SHAWSALES, M=COSTS
Measure.. Cost 12 Mo MV Avg Successful
S=CS_OLAP, C=SHAWSALES, M=COSTS_12MMA
Measure.. Cost 6 Mo MV Avg Successful
S=CS_OLAP, C=SHAWSALES, M=COSTS_6MMA
Measure.. Cost Fcst Best Fit Successful
S=CS_OLAP, C=SHAWSALES, M=COSTS_FCAST_BF
Measure.. Cost % Growth Prior Period Successful
S=CS_OLAP, C=SHAWSALES, M=COSTS_PCT_CHANGE_PP
Measure.. Cost % Growth Successful
S=CS_OLAP, C=SHAWSALES, M=COSTS_PCT_CHANGE_YRAGO
Measure.. Margin 12 Mo MV Avg Successful
S=CS_OLAP, C=SHAWSALES, M=MARGIN_12MMA
Measure.. Margin 6 Mo MV Avg Successful
S=CS_OLAP, C=SHAWSALES, M=MARGIN_6MMA
Measure.. Margin Fcst Best Fit Successful
S=CS_OLAP, C=SHAWSALES, M=MARGIN_FCAST_BF
Measure.. Margin % Growth Prior Period Successful
S=CS_OLAP, C=SHAWSALES, M=MARGIN_PCT_CHANGE_PP
Measure.. Margin % Growth Successful
S=CS_OLAP, C=SHAWSALES, M=MARGIN_PCT_CHANGE_YRAGO
Measure.. Margin % Successful
S=CS_OLAP, C=SHAWSALES, M=MARGIN_PERCENT
Measure.. Quantity Successful
S=CS_OLAP, C=SHAWSALES, M=QUANTITY_SOLD
Dimension Channel Successful
S=CS_OLAP, D=SHAWCHANNELS
Dimension Geography Successful
S=CS_OLAP, D=SHAWGEOGRAPHIES
Dimension Product Successful
S=CS_OLAP, D=SHAWPRODUCTS
Dimension Promotion Successful
S=CS_OLAP, D=SHAWPROMOTIONS
Dimension Time Successful
S=CS_OLAP, D=SHAWT_TIME
Dimension Channel Successful
S=CS_OLAP, D=SHAWCHANNELS
Dimension Geography Successful
S=CS_OLAP, D=SHAWGEOGRAPHIES
Dimension Product Successful
S=CS_OLAP, D=SHAWPRODUCTS
Dimension Promotion Successful
S=CS_OLAP, D=SHAWPROMOTIONS
Dimension Time Successful
S=CS_OLAP, D=SHAWT_TIME
Folder... Electronics - KPIs
Measure.. Revenue Successful
S=CS_OLAP, C=SHAWSALES, M=AMOUNT_SOLD
Measure.. Cost Successful
S=CS_OLAP, C=SHAWSALES, M=COSTS
Measure.. Quantity Successful
S=CS_OLAP, C=SHAWSALES, M=QUANTITY_SOLD
Measure.. Revenue Successful
S=CS_OLAP, C=SHAWSALES, M=AMOUNT_SOLD
Measure.. Cost Successful
S=CS_OLAP, C=SHAWSALES, M=COSTS
Measure.. Quantity Successful
S=CS_OLAP, C=SHAWSALES, M=QUANTITY_SOLD
Dimension Channel Successful
S=CS_OLAP, D=SHAWCHANNELS
Dimension Geography Successful
S=CS_OLAP, D=SHAWGEOGRAPHIES
Dimension Product Successful
S=CS_OLAP, D=SHAWPRODUCTS
Dimension Promotion Successful
S=CS_OLAP, D=SHAWPROMOTIONS
Dimension Time Successful
S=CS_OLAP, D=SHAWT_TIME
Dimension Channel Successful
S=CS_OLAP, D=SHAWCHANNELS
Dimension Geography Successful
S=CS_OLAP, D=SHAWGEOGRAPHIES
Dimension Product Successful
S=CS_OLAP, D=SHAWPRODUCTS
Dimension Promotion Successful
S=CS_OLAP, D=SHAWPROMOTIONS
Dimension Time Successful
S=CS_OLAP, D=SHAWT_TIME
]]>
</Check>
</D4OCheckConfig>

What is wrong? Why it's not functioning?
Do I have to install something else, such as AWM? If yes, what version of AWM should I use with my 9.2.0.7 database?

Any help will be apreciated!
Thank you.
daniela

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 4 2006

Added on Mar 7 2006

#business-intelligence-applications, #business-intelligence-foundation, #discoverer

2 comments

283 views