BO4 - Adding tables to data foundation layer and all tabels now in sql

[former_member272336]

Hi,

Using BO4 SP5 IDT tool have added some new tables to teh data foundation layer and joined the tables to the related tables.

Have included these joins in the necessary contexts and excluded form ones where not required.

When create query unrealetd to these tables in buisness layer all tables being included in the from clause which shouldn't.

Thoughts?

tHANKS

[former_member182521 · Accepted solution]

One or more objects included in your query has been associated with these tables. try validate the SQL of each object to identify which one is creating issue

[former_member272336 · Accepted solution]

Thanks for advice.

[Former Member]

The Tables may not be used directly but the joins might be used in pulling information from other tables, you can specify a context(navigation path) for that so that this join is not included.

Thanks,
Avinash

[former_member272336]

Thanks for advice.