OBIEE 11g: Error: "[nQSError: 14070] Cannot Find Logical Table Source Coverage for Logical Columns: [Level 1 Desc]" When Using a Skipped / Ragged Hierarchy To Select Members (Doc ID 1294704.1)

Last updated on APRIL 12, 2011

Applies to:

Business Intelligence Server Enterprise Edition - Version: 11.1.1.3.0 [1905] to 11.1.1.3.0 [1905] - Release: 11g to 11g
Business Intelligence Suite Enterprise Edition - Version: 11.1.1.3.0 [1905] to 11.1.1.3.0 [1905]   [Release: 11g to 11g]
Information in this document applies to any platform.

Symptoms

You are getting the following ODBC error while using a skipped / ragged hierarchy to select a particular member in the "Selection Step" while creating reports:

NQSerror:14070 cannot find logical table source coverage for logical columns[ level 1 Desc] please check more detailed level keys are mapped correctly


You created the hierarchy using multiple tables in the Business layer. Hierarchy is built and the repository is compiled.

While creating report,s when you use the new features "Based on Level Relationship" or "Based on Family Relationship" in the "Selection Step", you get the ODBC error.  You observed that when using multiple tables to build the hierarchy and using the new features, you are getting the ODBC error, whereas when you use single table to build the hierarchy then you can see values while choosing the steps.

It occurs only with hierarchy sourced from multiple tables. The analysis works if you don't use columns from more than one source in the hierarchy. The error occurs in the hierarchy when you try to add a column from a second source table.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms