Sunday, February 13, 2011

OBIEE Error 39008

OBIEE Error 39008: Logical dimension table X has a source that does not join to any fact source.

I am using Oracle Business Intelligence 11.1.1.3.0 version to create a new repository. My usual procedure is to create a repository in iterative manner, developing a simple repository using some of the tables and finish a simple model and repository without adding too much of details. I keep adding more details with each subsequent iteration.  

I just finished my first iteration of repository development and it looks like this




















The consistency checker gives no error or warnings.










In my second iteration I created a dimension/hierarchy.























I now did a consistency check of my repository and got 12 warnings.






















OBIEE Error 39008: Logical dimension table X has a source that does not join to any fact source.

Now there are three things to check to check for 39008 Error/Warning:
1.     Make sure that there is a physical/foreign key join between the LTSs.
2.     Make sure that there is a complex join between the logical tables.
3.     Make sure that the granularity between the dimension and the fact is same. (Check content tab in LTS)

Everything seems to be in place in my repository. Here is the trick that solved my problem and remove all consistency warnings.

Go to BMM layer and expand your fact table and it’s LTS.



















Now, double click on the LTS to view properties and go to content tab.


Now, here is the trick. In the drop down box for 'Aggregation content, group by' select 'Column' instead of 'Logical Level'































Click OK.

Now do a consistency check. In case you don’t know the shortcut, you can press Ctrl+k to do a consistency check.

Tadaa….










All the 39008 warnings are gone.

Now go back to LTS of your fact table in BMM layer and check that the 'Aggregation content, group by' setting has reverted back to 'Logical Level'.

This is a documented procedure by Oracle. More information on OBIEE 39008 Warning:

Cheers!
Deepak

Tuesday, February 8, 2011

OBIEE 11g Installation

OBIEE 11g Installation

This article is in continuation from my previous post, and a reference for the installation and configuration of OBIEE 11g R1. 

OBIEE 11g R1 Installation Files

The installation files were downloaded from Oracle Technology Network.
http://www.oracle.com/technetwork/middleware/bi-enterprise-edition/downloads/bus-intelligence-11g-165436.html

To reiterate, my Machine has the following configuration:
Intel Core Duo 2.2 GHz / 3GB / Windows 2003 R2 EE

System Requirements and Specifications are available here.


This article is a run-book that provides guidelines for installing and configuring OBIEE 11g on a single computer using the Simple Installation option.
We can install the following components:
·         Oracle Business Intelligence Enterprise Edition (Answers, Dashboards, Delivers, Repository Administration Tool, Office, and Oracle Business Intelligence Publisher)
·         Oracle Business Intelligence Publisher
·         Oracle Real-Time Decisions

Starting OBIEE 11g Installation


1.     Extract the downloaded .zip files in a directory called OBIEE_INSTALL_FILES.
2.     Go to \OBIEE_INSTALL_FILES\Disk1 and run setup.exe

3.     Welcome Screen comes up


















4.     Click Next. This will check if the pre requisites are met.


Rectify errors if any before continuing. Click Next.

5.     Select Installation Type


Select Simple Install type and click Next.

6.     Specify Installation Location


OBIEE 11g Installer designates this directory as the Middleware home. OBIEE 11g Installer also creates the Oracle home, Instance home, WebLogic home, and Domain home within this location.
Specify the directory, click Next.

7.     Administrator Details


Specify the user name and password for the system administrator. Click Next. I selected weblogic as username and weblogic as password.
  
8.     Configure Components


Check the required components and click Next. I selected all components.
  
9.     Oracle Database Details


Enter the required database details. Connect string is defined as hostname:port:servicename
Use the prefix as defined during installation of bi schemas using RCU.

10.  Specify Security Updates


This step is optional. Click Next. If you do not provide the information you will be presented with the following window.


Click Yes and continue.

11.  Installation Summary


This screen describe your settings as selected for the installation.
Click Install to start the installation.
  
12.  Installation Progress Screen 


This screen shows the progress of installation
Click Next when the installation is complete.

13.  Configuration Progress Screen


Click Next when configuration finishes.

14.  Installation Completed Screen


You can save the summary details by clicking Save File. Once done Click Finish completes the installation process. This opens a web browser to display your Oracle Business Intelligence instance.

Once the installation completes check the following URLs.
Oracle Business Intelligence-> http://localhost:9704/analytics
Enterprise Manager-> http://localhost:7001/em

After installing OBIEE I used the guidelines provided here to deploy SampleApp.

References:
http://download.oracle.com/docs/cd/E14571_01/bi.1111/e10539/toc.htm

Cheers!
Deepak

OBIEE 11g Installation- RCU

OBIEE 11g Installation- RCU (Repository Creation Utility)- Schema Installation

Finally after installing OBIEE 11g successfully a number of times I got a chance to document and create a run-book that I can share. In this article I am covering creation of certain schemas in the database which are required to install and configure OBIEE 11g R1. A utility provide by Oracle called Repository Creation Utility (RCU) is used to create these schemas required by OBIEE 11g.

My Machine has the following configuration:
Intel Core Duo 2.2 GHz / 3GB / Windows 2003 R2 EE

RCU Installation Files are available here.


System Requirements and Specifications are available here.


One Important step is to install Microsoft Loopback adapter with static IP as described here.

Once Microsoft Loopback adapter is installed go to My Network Places and choose Properties. This displays the Network Connections Control Panel.

Right-click on the network connection that was just created and to properties. In General tab select Internet Protocol (TCP/IP and click on Properties. Click use the following IP address in the IP Address field enter a non-routable IP for the loopback adapter (I used 10.10.10.10).

In Subnet mask: enter 255.255.255.0 Leave other field at their default values. Click OK. It is a good point to restart your PC.

To Start the Repository Creation Utility


1.     Extract the downloaded .zip file and access the bin directory in the RCU_HOME.
2.     Run rcu.bat file.
3.     Welcome Screen

















4.     Click Next.

5.     Create Repository Screen


6.     Select Create.

7.     Click Next.

8.     Database Connection Details Screen



Select Oracle Database as Database Type and provide the following information:
·         Host Name: Specify the name of the computer on which your database resides in the format host.domain.com
·         Port: Specify the database listener port number. The default port number for Oracle databases is 1521.
·         Database Name: Specify the service name for the database.
·         Username: Specify the name of a user with DBA or SYSDBA privileges.
·         Password: Specify the password for the user with DBA or SYSDBA privileges.
·         Role: Select the database user's role from the drop-down list.

9.     Select Components Screen


Click on radio button for Create a new Prefix. Type in the new Prefix, we selected Dev in this case.
Click the Business Intelligence check box. This automatically selects the Metadata Services (MDS) and Business Intelligence Platform schemas, which are required by Oracle Business Intelligence.
Click Next.


Click OK to close the Checking Prerequisite screen. Fix errors if they appear before continuing.

10.  Schema Passwords Screen


Create a password for all the schemas. I selected oraclebi1.

11.  Map Tablespaces Screen


Click Next.

The Creating Tablespaces screen opens.


If there are errors, fix them and click on Next again else click OK to close the window.

12.  Summary Screen


Click Create.

The Create screen opens. If there are errors, fix them to continue else click OK to dismiss the screen.

13.  Completion Summary Screen


Click Close.

This completes installation of required schemas for OBIEE 11g.

References:

Cheers!
Deepak