Installing OBIEE 10g on Windows 7

When I tried to install OBIEE 10g on windows 7, I got the following error.

Thanks to Nico, after gone through his blog, I got the solution.

Solution :
1. Right click on the Start.exe file, select Properties.

2. Go to Compatibility tab, check the box "Run this program n compatibility mode for:" and select the windows version "Windows Server 2003(Service Pack 1)". Then click OK.

3. Now double click on the Setup.exe file and install the application.

ODBC

ODBC (Open Database Connectivity) is a standard C programming language interface for accessing database management systems (DBMS). The designers of ODBC aimed to make it independent of database systems and operating systems. An application can use ODBC to query data from a DBMS, regardless of the operating system or DBMS it uses.


ODBC accomplishes DBMS independence by using an ODBC driver as a translation layer between the application and the DBMS. The application uses ODBC functions through an ODBC driver manager with which it is linked, and the driver passes the query to the DBMS.

 If changes are made to the DBMS specification, only the driver needs updating. An ODBC driver can be thought of as analogous to a printer or other driver, providing a standard set of functions for the application to use, and implementing DBMS-specific functionality. An application that can use ODBC is referred to as "ODBC-compliant". Any ODBC-compliant application can access any DBMS for which a driver is installed. Drivers exist for all major DBMSs and even for text or CSV files.

ODBC drivers exist for most DBMSs, including Oracle, PostgreSQL, MySQL, Microsoft SQL Server (but not for the Compact aka CE edition), Sybase ASE, and DB2.


The Driver Manager (DM) is the software that loads a particular driver based on the connection information.^[7] An application is actually linked to the DM. When the application calls the ODBC function to connect to the DBMS, the DM parses the connection string and loads the appropriate driver.

Change Port Number For OBIEE Presentation Services

On a default installation OBIEE runs on web port 9704.
Eg : http://nws1018:9704/analytics/saw.dll?Answers

If you want to run the webservice on different portnumber or even better from the default port 80, then follow with the below steps.

Step 1 : Navigate to your OC4J config directory.

                 ..:\OracleBI\oc4j_bi\j2ee\home\config 

Step 2 :Open the file named default-web-site.xml

Note : Before doing any changes to this file, better take a backup of this file.

Step 3 : Locate port in <web-site> tag and change it to 80(port="80").

 

Step 4: Save and close the file.

Step : Stop and Start the your OC4J.

Now you can run Presentation Services on port number 80.

Eg : http://nws1018:80/analytics/saw.dll?Answers 

Tip#1 for Importing a Physical Schema

The following is a list of tips to help you when importing a physical schema:

1. Importing the physical schema saves you time and effort by importing the structure for the physical layer. If you do not import the schema, you must create each table, primary key, foreign key, and any other objects against which you want to generate queries.

 2.  When you import schema for most databases, the default is to import tables, primary keys, and foreign  keys.

NOTE:  It is recommended that you not import foreign keys from a database because the process is lengthy when importing a large number of tables.

 3.When you import physical tables, be careful to limit the import to only those tables that contain data that are likely to be used in the business models you create. You can use a filter (table mask) to limit the number of tables that appear in the import list. This makes it easier to locate and select the tables that you want to import.

 4 .You can also import database views, aliases, synonyms, and system tables. But import these objects only if you want the Oracle BI Server to generate queries against them. 

5. Importing large numbers of extraneous tables and other objects adds unnecessary complexity and increases the size of the repository.

Creating and Administering the Physical Layer in an Oracle BI Repository

 Before you create the physical layer of a repository, you need to plan, design, and then create a repository file.

The Physical layer of the Administration Tool defines the data sources to which the Oracle BI Server submits queries and the relationships between physical databases and other data sources that are used to process multiple data source queries.