Tag Archives: OBIEE 11g

Deploy the OBIEE AnalyticsRes Folder on a WebLogic Server

Since Oracle BI 11g was released it has sought as to use the /analyticsRes folder of the default OBIEE 11g implementation to store media and programmatic scripting files as a best practice. Although you could create a different folder named arbitrarily, containing a WEB-INF folder with web.xml file to denote it is a JEE deployable […]

The post Deploy the OBIEE AnalyticsRes Folder on a WebLogic Server appeared first on Art of Business Intelligence Blog.

OBIEE en JDev in the same FWM home

Don't do it, it screws up your OBIEE weblogic instance.........

(especially when you are preparing for the Brighton 2012 BI congress.......)

8-(

Till Next Time

OBIEE install avoid RTD license problems

If you are not going to use RTD (Real Time Decisions) uncheck the box during installation:

image

This avoids extremely difficult discussions with Oracle over the license fee.

Till Next Time

OBIEE 11116 repository on MS-SQL I

We had to do a POC on some MS-SQL data. Instead of bringing an extra Oracle DB we used an existing MS-SQL instance.

1. Create a repository database:

We called ours “Repositories” Winking smile

image

2. Enable case-sensitive collation

ALTER DATABASE Repositories COLLATE Latin1_General_CS_AS

3. Enable Row versioning

ALTER DATABASE Repositories SET READ_COMMITTED_SNAPSHOT ON

 

4. Allow TCP/IP access to the database:

image

(Bounce the service if you changed it!)

4b. If you have a firewall running check if the ms-sql port is open (1433 for a default instance)

5. Create a user (fi: REP_OWN)

image

6. make  the default database repositories:

image

7. Set the public and sysadmin role:

image

Now we can start with the actual repository:

8. Download and unzip de RCU.

9. Start the RCU.bat (..\rcuHome\BIN)

10. On the database connection details page:

image

11. Select the BI components:

image

12. Enter the passwords

image

13. Succes:

image

image

14. You can disable the REP_OWN account, the RCU has create dedicated logins:

image

Till Next Time

OBIEE 11.1.1.6 upgrade guide

Upgrade guide is found here:

http://docs.oracle.com/cd/E23943_01/bi.1111/e16452/bi_plan.htm#BABECJJH

Pretty much a standard weblogic upgrade.

Till Next Time