Sunday, August 2, 2015

External Metadata Strings in 11.1.1.9

In OBIEE version 11.1.1.9 when a tranlastion(or name/description) of  a Presentation Layer column, table, or subject area is changed, it is picked up right away. There is no need to restart as it was before.


https://docs.oracle.com/middleware/11119/biee/BIEMG/whatsnew.htm#CJACHIJC
 

Wednesday, November 20, 2013

RPD Error 15019 or 15011

This error is associate with the keys in the LTS.

There should be only one key in the logical table with the lowest granularity.



Reference:
http://mtalavera.wordpress.com/2012/07/17/obiee-rpd-consistency-error-nqserror-15019-table-is-functionally-dependent-upon-level/

Friday, July 27, 2012

BI Administration Tool - import metadata select metadata objects shows nothing.

The administration tool is missing ddl as seen in the log file - Administrator_NQSAdminTool.log:


[2012-07-27T10:18:20.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 76c]  [nQSError: 93001] Can not load library, oracore11.dll, due to, The specified module could not be found. [[
.
The specified module could not be found.


I have found the solution here.
http://www.rittmanmead.com/2012/05/obiee-administration-tool-import-metadata-shows-no-schemas/

Custom install Oracle DB Client and make sure to install Oracle Call Interface (OCI).

Start Weblogic Without Entering Username and Password

Go to:
cd $MW_HOME/user_projects/domains/bifoundation_domain/servers/AdminServer/security/

and create file boot.properties this inside


username=Admin_Username
password=Admin_Password


Reference:
Enterprise Deployment Guide for Oracle Business Intelligence
E15722-01
5.2 Creating boot.properties for the Administration Server on APPHOST1
http://docs.oracle.com/cd/E14571_01/doc.1111/e15722.pdf

Uninstall Exalytics software

OBIEE
Oracle_BI1/oui/bin/setup.sh -deinstall
oracle_common/oui/bin/runInstaller -deinstall -jreLoc $JAVA_HOME

Weblogic
fmw/wlserver_10.3/uninstall/uninstall.sh

TimesTen
TimesTen//tt1122/bin/setup.sh -uninstall

Go to /etc/TimesTen
rm -rf /etc/TimesTen/*
touch /etc/TimesTen/instance_info

UnInstall TimesTen:
http://docs.oracle.com/cd/E11882_01/timesten.112/e21632/install.htm#autoId39


Remove Weblogic Server

$MW_HOME/wlserver_10.3/uninstall/uninstall.sh

Thursday, July 26, 2012

Exalytics silent installer


It needs to be run in that way:
./setup.sh /home/oracle/EXALYTICS_
INSTALLERS/bi/bishiphome/Disk1/bimachine/scripts/bim-setup.properties

Go to Disk1/bimachine/
from there run setup.sh and the full path to bim-setup.properties
Otherwise an error message an error message saying:



./setup.sh scripts/bim-setup.properties



BUILD FAILED
/home/oracle/EXALYTICS_INSTALLERS/bi/bishiphome/Disk1/bimachine/scripts/bim-setup.xml:26: The following error occurred while executing this line:
/home/oracle/EXALYTICS_INSTALLERS/bi/bishiphome/Disk1/bimachine/scripts/bim-setup.xml:37: The following error occurred while executing this line:
/home/oracle/EXALYTICS_INSTALLERS/bi/bishiphome/Disk1/bimachine/scripts/bim-wls.xml:20: bim.temp.dir ${bim.temp.dir} does not exist!

Total time: 0 seconds

will appear.