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:

http://download.oracle.com/docs/cd/E14847_01/bia.796/e14222/chapter.htm#BABJEAIH

Cheers!

Deepak