OBIEE - Logical Table

Bi Server Architecture With Client


A logical table source is a table where all its logical table sources have the same dimension combinations (domain) by logical level.


The check box “This source should be combined with other sources at this level” is a way to define that the fragment contains or not the whole domain. If you check it without fragmentation content because you know that your table doesn't contain the whole domain, you will get this warning.

Obiee Logical Table Source No Fragmentation Content Warning

Then if you have a target definition table that may not contain all dimension combinations for a specific level, you have to create an apart logical table for this table.

Discover More
Obiee Fragmentation Content One Column
OBIEE - Aggregate (Navigation|Table|Content)

The aggregate navigation capability of the Oracle BI Server allows queries to use the information stored in aggregate tables automatically. When users request information at a high “grain” of aggregation,...
Bi Server Architecture With Client
OBIEE - Fragment

A fragment is just an other name for a logical table source in the context of fragmentation. For instance, you splits a table in two child tables (History and current). In OBIEE, the original table...
Obiee11g Lts
OBIEE - Logical Table Source (LTS) (Physical and Logical Column Mappings)

Logical table sources definethe mappings from a single logical table to one or more physical tables. A logical table contains one or more logical table source. The mapping between physical columns and...
Obiee 10g Logical Level Key
OBIEE - Logical level

The Logical level or level are the key level of the hierarchy and defines the grain of each table (logical table) (Fact as Dim) when set in the content tab. The level key: defines the unique...
Obiee Nqs15019
OBIEE - nQSError:15019 - Table @1%ls is functionally dependent upon level @2%ls

When performing a consistency check, you can get this error: Cause: The named table level dependencies are inconsistent. Response. Correct the level dependencies and retry your actions. If the...

Share this page:
Follow us:
Task Runner