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
Last updated on FEBRUARY 01, 2018
Applies to:Business Intelligence Server Enterprise Edition - Version: 126.96.36.199.0  to 188.8.131.52.0  - Release: 11g to 11g
Business Intelligence Suite Enterprise Edition - Version: 184.108.40.206.0  to 220.127.116.11.0  [Release: 11g to 11g]
Information in this document applies to any platform.
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.
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