New version of OBI released : 11.1.1.7.0

New version of OBI is released : 11.1.1.7.0 

It can be downloaded from oracle site here.

Oracle has given a below list of Workarounds/Fixes/Issues for release 11.1.1.7.0

1. Specifying Folder Names for Data-Loading the Catalog
2. SSL Not Available when Using Full-Text Search with Oracle Endeca Server
3. Issue with Email Notifications on Data Loads for Searching
4. Stopping a Data Load for Full-Text Searching with Oracle Endeca Server
5. Out of Memory Error When Crawling the Catalog
6. Multibyte Characters Are Displayed as NCR When Using Attribute Categories
7. Unicode Not Supported with DataDirect Hadoop Hive Driver
8. Analysis State is not Maintained for Breadcrumbs
9. Financial Reporting Print Server Not Enabled
10. Issues Exporting Large Data Sets to Microsoft Excel
11. Managed Server for Oracle BI Encounters Issues After Upgrade from Release 11.1.1.3
12. Configuration Assistant for Update BI Domain Steps Incorrectly Reports an OCM Configuration Error at 91% Complete when Moving from Earlier 11g Releases
13. SSL Configured in Oracle BI EE 11.1.1.5.x or 11.1.1.6.x Fails After Upgrading to 11.1.1.7.0
14. Characters in Trellis Title Display Incorrectly in Certain Languages
15. Export to Excel 2007+ and Export to PDF Do Not Support Custom CSS Styles
16. Items Not Supported When Using Custom Print Layouts
17. Column Data in Section Edge Is Not Obtained
18. Empty Prompts Section Appears in BI Mobile Dashboards with Prompts
19. Logical Display Folders Are Deleted During MUD Publish
20. Ensure that Your Installation Uses a JDK Installed into a Folder that Does Not Contain Spaces
21. Essbase SQL Interface Using Oracle Call Interface (OCI) to Connect to Oracle Requires Oracle Instant Client
22. Options to Set Accessibility Preferences When Using Workspace Are Not Available
23. Merant 6.1 ODBC Drivers Are Not Configured on Linux
24. Misinformation About Oracle Endeca Server and Full-Text Search
25. Breadcrumbs Disabled for Embedded Objects in ADF
26. Note on Fixed Headers with Scrolling Content Is Incorrect
27. Misinformation About Adding HTML Code in Prompt Labels
28. Enable on Totals for Action Links Not Described
29. Issue Copying a Jar File when Registering with EPM Workspace Release 11.2.3.00
30. Parameter Descriptions Missing or Inaccurate in NQSConfig.INI File 
31. Removal of Invalid LDAP Configuration Properties when Setting Up SSL
32. Error in Code Example for Configuring the WebLogic Server Environment
33. Excel Analyzer and Online Analyzer Deprecated in Release 11.1.1.7

Auto-Configure ports in Oracle BI

Auto-Configure ports in Oracle BI

Static ports is located at installation directory

Path:  \bishiphome\Disk1\stage\Response\statisports.ini

This is how your staticports.ini file looks like. We can configure the ports as per our convenience.
If by mistake, we gave 2 port as same, Oracle BI will automatically find out the conflict and throw error.


---------------------------------------staticports.ini-----------------------

[WEBLOGIC]

#The Domain port no. This is the listen port of Weblogic Adminserver for the domain.
#Domain Port No = 7001

#The "content" port for the BIEE apps. This is the Weblogic Managed Server port on which BIEE applications are deployed.
#Oracle WLS BIEE Managed Server Port No = 9704

#The SSL port for the Weblogic Managed Server
#Oracle WLS BIEE Managed Server SSL Port No = 9804

[OPMN]

#Process Manager Local port no
#Oracle Process Manager Local Port No = 6700

#Process Manager Remote port no
#Oracle Process Manager Remote Port No = 6701

#Process Manager Request port no
#Oracle Process Manager Request Port No = 6702

[BIFOUNDATION]

#The listen port for OracleBIServer component 
#Oracle BI Server Port No = 9703

#The monitor port for OracleBIServer component 
#Oracle BI Server Monitor Port No = 9701

#The listen port for OracleBIPresentationServices component 
#Oracle BI Presentation Services Port No = 9710

#The listen port for OracleBIScheduler component 
#Oracle BI Scheduler Port No = 9705

#The monitor port for OracleBIScheduler component 
#Oracle BI Scheduler Monitor Port No = 9708

#The script RPC port for OracleBIScheduler component 
#Oracle BI Scheduler Script RPC Port No = 9707

#The listen port for OracleBIClusterController component 
#Oracle BI ClusterController Port No = 9706

#The monitor port for OracleBIClusterController component 
#Oracle BI ClusterController Monitor Port No = 9700

#The listen port for OracleBIJavaHost component
#Oracle BI JavaHost Port No = 9810

[ESSBASE]

#The listen port for Essbase Agent
#Essbase Agent Port No = 1423

#The listen port for Essbase Studio
#Essbase Studio Port No = 5300

Isolation level in Connection Pool

What are Isolation level in Connection Pool Setting ??


They are applicable for ODBC and DB2 gateways only. 

The Level options:

Committed Read:    Locks are held while the data is read to avoid dirty reads. Data can be changed before the transaction ends with that connection.

Dirty Read:   0 Locking. Can read uncommitted or dirty data, change values in data during read process in a transaction. Least restrictive of all types.

Repeatable Read:  Places locks on all data used in a query so that nobody can update the data. However new rows can be inserted by other users but will be available in later reads in the current transaction.

Serialization:   Places a range lock on data set preventing other users to insert or update the rows in data set until the transaction is complete. Most restrictive of all.

Trellis Chart

Trellis View

 There is a new view provided by Oracle in their latest release of OBIEE 11g, Trellis View.

 This cool view embeds Chart view inside a table.  

This view can be used in the Summary report to show both table information & the charts

BEA -141281 ERROR

BEA -141281 ERROR

 This error occurs due to the lock file AdminServer.lok.  This file is present in the below location:

<OBI_INSTALALTION_DIRECTORY>\user_projects\domains\bifoundation_domain\servers\AdminServer\tmp

Delete this file and Restart the services. This would clear the BEA-141281 issue.

Pre-requisites for Installing OBIEE 11g

Pre installation Steps in Windows 7

1) Java:

Ensure java jdk( V 1.6 and above ) is installed.

Point to Note

Jdk should be installed in a folder without space, say like "C:/Java/"

DONT install java in "C:/Program Files/Java"; the reason is that the Space(" ") between the  word "Program files" will cause error while installing OBIEEv11g

IF YOU HAVE INSTALLED JAVA under "PROGRAM FILES" Uninstall it and Reinstall the same

After Installation:

Add JAVA_HOME in your environment variables.

In Windows7, Right Click "My Computer"-> Properties->Advanced tab ->Environment Variables

Click the New button and add VARIABLE NAME as "JAVA_HOME" and variable path as

"C:/JAVA/JDK;"

If you have installed java in "C:/" use "C:/JAVA/JDK;" path variable

2) In Windows, Install Loopback adapter, Follow the below link to install the loopback adapter in windows 7.

http://www.windowsreference.com/windows-7/how-to-install-a-loopback-adapter-in-windows-7/

After Installation:

You will see a network icon in systray. Click on that and go to "Open Network Connection" Click

on the installed Loopback Adapter Properties and Under General Tab,

Click on the Internet Protocal Ip4 and Click on the properties.

IN the PopUp under General tab give 10.10.10.10 for IP Address and for subnet mask provide

"255.255.255.0"

You can give any IP address here. But Oracle follows 10.10.10.10. Lets religiously follow what Oracle does 

Adding This Static IP to your windows Host

Start->search for Notepad-> RIght click and open as Administrator

Once you are in Open the following file "C:/Windows/system32/drivers/etc/hosts" Add the following at the end of file :

10.10.10.10 localhost localhost.local.com

Save & Close the file.

This Step is important because after obiee11g installation we would access the url by "10.10.10.10:<port>/analytics"

We are installing loopback adapter to create a static IP rather than to Create a dynamic IP which would keep changing whenever you connect to your ISP.

3) Install Oracle Database

You can either go for oracle 10g or 11g. Any database is fine, But its recommended to use oracle

11g DB to realise the full potential features of Database and OBIEE.

Note: While Installing Please provide the AL32UTF8 Unicode Character set. Else while installing

RCU below error will be shown :

"The database you are connecting is with non-AL32UTF8 Character set. oracle strongly

recommends using of AL32UTF8 as database character set."

4) Download & Install Repository Creation Utility - RCU

5) After all these steps; OBIEE 11g should be installed