I am trying to close my installation on ORDM. I have already installed everything, but the OLAP option is not working properly. OBIEE with all the reports work perfectly now
with some minor bugs...the OLAP dashboards no!
I have database 18.104.22.168 + OLAP B Patch, AWM is the one that comes with the Oracle Client zip file 22.214.171.124 (is this the correct final version already??). I was trying to find a patch number 6368282 from My Oracle Support (according to the installation guide) but it doesn't exist to Linux.
AWM cannot import from template the PSLSINV.M10.XML.... giving what it looks like a parsing error. Looks like version problems..
Looking at my DB:
select * from dba_registry
where comp_name like '%OLAP%'
COMP_ID COMP_NAME VERSION STATUS
APS OLAP Analytic Workspace 126.96.36.199.0 VALID
XOQ Oracle OLAP API 188.8.131.52.0 VALID
AMD OLAP Catalog 184.108.40.206.0 VALID
Can u provide some advice on this since the guide is not clear about it?
I have a Linux 32x64 for my testings.
I'm assuming that you're installing the sample schema of ORDM.
From your mails, it seems that you have progressed to the stage that the relational reports are showing data but the OLAP Dashboard is not working.
Some points to note/check at your end regarding the installation:
a) AWM 220.127.116.11 (patch 6368282) is only available for Windows env. It is possible to administer the olap schema/aw on linux OS using AWM from a client machine/laptop. However this is not essential for the purpose of installing the product. It can help in debugging/checking the install for specific objects in the aw etc.
b) Is this a 64 bit linux machine? If you're installing the sample schema, then relational and mining schema are installed by default (the installer does it). The olap schema needs to be created by calling a specific script. Sample data installed by script "ordm_olap_11g_install_scr.sql". Can you confirm that the script was invoked post install and that it did not report any errors.
c) Please copy paste any parse errors and/or script debugging output to help diagnose this further.
You can email me at shankar (dot) somayajula (at) oracle (dot) com to see how we can resolve the install issue faster.
Some more info required regarding install/config choices -
a) What are the choices given during calendar set up (in the ORDM Installation UI)?
b) What were the inputs given while calling the install scripts (Historical Star/End dates input parameters)?
I dont know if you tried running the scripts and installing the olap AW once again after upgrading from 18.104.22.168 to 22.214.171.124. I'm not sure that the old AW would work in 126.96.36.199 as is (with just the database upgraded). Its recommended to make a fresh start in 188.8.131.52 since the AW XML template defining the AW is different between the two versions.