This is part-2 of OBIEE Installation.
Part 1: http://123obi.com/2013/04/obiee-11-1-1-7-0-installation-on-windows-7-part-1/
Permanent link to this article: http://123obi.com/2013/04/obiee-11-1-1-7-0-installation-on-windows-7-part-2/
Apr 05
OBIEE 11.1.1.7.0 Installation on Windows 7 – Part 1
My System Configuration:
Operating System : Windows 7 Ulitimate 64bit
Memory: 8GB
Installation steps from scratch:
1. Host Name(eg. kalyan.123obi.com)
2. Microsoft Loopback adapter
http://www.windowsreference.com/windows-7/how-to-install-a-loopback-adapter-in-windows-7/
Permanent link to this article: http://123obi.com/2013/04/obiee-11-1-1-7-0-installation-on-windows-7-part-1/
Apr 04
OBIEE 11g (11.1.1.7.0) Available for Download
OBIEE 11g (11.1.1.7.0) is available for Download at OTN.
Download link:
http://www.oracle.com/technetwork/middleware/bi-enterprise-edition/downloads/bi-downloads-1923016.html
Permanent link to this article: http://123obi.com/2013/04/obiee-11g-11-1-1-7-0-available-for-download/
Feb 07
Unable to open Catalog manager – OBIEE 11g
I have installed OBIEE 11.1.1.6.2 client in local PC (Windows). When I tried to open Catalog Manger nothing happens i.e. Catalog Manger does not show up. It is a known bug. Let see how to fix this…
In the local installation of OBIEE Client tools, there is file called runcat.cmd, path to this file is (it may vary in your installation)
Open runcat.cmd in an editor and modify the set PATH paramount. Only thing that needs to be modified is to add Double Quotes (“) to path as show in the following screenshot.
Before Modification:
After Modification:
Just save the file and open your Catalog Manager. It should work.
Till Next Time 
Permanent link to this article: http://123obi.com/2013/02/unable-to-open-catalog-manager-obiee-11g/
Permanent link to this article: http://123obi.com/2012/07/oracle-database-search-for-a-string-in-entire-database-tables/
Jul 05
Purge Cache in OBIEE 11g
Permanent link to this article: http://123obi.com/2012/07/purge-cache-in-obiee-11g/
Jul 02
OBIEE 11.1.1.5 Error: [nQSError: 37005] Transaction update failed
When trying to save online the repository, sometimes we get the error “[nQSError: 37005] Transaction update failed”.
This error occurs when the repository is not consistent (The error was due to having in the rpd one table with twice exactly the same key with same name). This error disappears once OBIEE services (OPMN Components) are restarted from Enterprise Manger. However this bug has been fixed in the following versions:
OBIEE 11.1.1.6.0.
OBIEE 11.1.1.5.0 BP2 (download and install patch 13611078).
Till Next Time
Permanent link to this article: http://123obi.com/2012/07/obiee-11-1-1-5-error-nqserror-37005-transaction-update-failed/
Permanent link to this article: http://123obi.com/2012/06/obiee-11-1-1-6-2-bp1-patchset-is-released/
Permanent link to this article: http://123obi.com/2012/06/oracle-reset-forgotten-system-sys-password/
Jun 06
OBIEE: Converting seconds to Minutes/Hours/Days
Converting seconds to Minutes/Hours/Days
Days HH:MM:SS
CAST(FLOOR(“TimeInSeconds_Column” / 86400 ) AS VARCHAR(4)) || ‘Days ‘ || CAST(FLOOR(MOD(“TimeInSeconds_Column” , 86400 ) / 3600) AS VARCHAR(4)) ||’:'|| CAST(FLOOR(MOD(“TimeInSeconds_Column” , 3600 ) / 60) AS VARCHAR(4)) ||’:'|| CAST(MOD(“TimeInSeconds_Column” , 60) AS VARCHAR(4))
HH:MM:SS
CAST(FLOOR(MOD(“TimeInSeconds_Column” , 86400 ) / 3600) AS VARCHAR(4)) ||’:'|| CAST(FLOOR(MOD(“TimeInSeconds_Column” , 3600 ) / 60) AS VARCHAR(4)) ||’:'|| CAST(MOD(“TimeInSeconds_Column” , 60) AS VARCHAR(4))
Till Next Time
Permanent link to this article: http://123obi.com/2012/06/obiee-converting-seconds-to-minuteshoursdays/
Visitors
