ORACLE BUSINESS INTELLIGENCE WORLD

Oracle Business Intelligence and Data Warehousing Practice Notes and Knowledge Repository

  • About Me

    Hello Friends,

    This is Santosh Kumar Gidadmani, a Business Intelligence and Data Warehouse Enthusiast passionate about blogging articles in the BI, Data warehousing, space. This is my attempt to share my experience and knowledge on Oracle BI & Data Warehousing Subjects.

  • OBIEE 11g Certified Implementation Specialist

  • Oracle Partner Network Certified Specialist

  • Visit My Profiles





  • Enter your email address to subscribe to this blog and receive notifications of new posts by email.

    Join 73 other followers

  • Blog Hits Since Nov 2010

    • 345,608 Hits
  • Live Traffic

  • Visitors Country

    Since-Mar'12Free counters!

OBIEE Global Consistency Check Warning 39008 – Logical Table Join

Posted by Santosh Kumar Gidadmani on September 14, 2014

If you get the warning: OBIEE Error 39008: Logical dimension table XXX has a source that does not join to any fact sources. Check if there is physical and logical join exits and the granularity between dimension and fact tables are same.

The Content Level of DIM and FACT LTS should be same as the logical join occurs at the same grain.

Another trick to fix the above error, is to change the logical level to column in fact table LTS under content tab aggregation content, group by section.

39008-1

Change the logical level to Column in all the fact tables. Click ok and check the global consistency check.

39008-2

All the 39008 error will be gone. Again revert back the aggregation content, group by to Logical level, save the RPD and once again check the global consistency check, you should not see such warnings.

Thanks,

Santosh

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s

 
%d bloggers like this: