Analytics Software

Hi and many thinks for reading,

I have a problem (which is quite common as I saw, though I could'nt find a solution which resolves my issue yet) with the consistency.

My physical layer looks like this:

Table_A
Table_B
Table_C
Table_D
Table_E

In the Business Model I have just the same tables and the following joins in the Logical Table Diagram:

Table_A -> Table_B
Table_C -> Table_A
Table_D -> Table_A
Table_E -> Table_A

The consistency check is delivering the following two warnings:

Warning
Logical Table Source
Table_A
[39008] Logical dimension table Table_A has a source Table_A that does not join to any fact source.

Warning
Logical Table Source
Table_B
[39008] Logical dimension table Table_B has a source Table_B that does not join to any fact source.

While working in BI answers I manage to retrieve all data from Tables C, D, E. But for tables A and B I can retrieve just the columns which are defined in the join Table_A->Table_B. All other columns deliver the following error:

Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 14026] Unable to navigate requested expression: Table_A.Column_X. Please fix the metadata consistency warnings. (HY000)

If i retrieve one Column from Table_A and one from Table_E, I have the following error:
Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 15018] Incorrectly defined logical table source (for fact table Table_E) does not contain mapping for [Table_B.Column_X]. (HY000)
(yes its Table_B not a)

I would like to fix this errors but am not sure where the problem is hidden.

Any help is kindly appreciated.

Evgeny