This content has been marked as final. Show 2 replies
When you see unnecessary tables in the queries fired to the DB, it means that the OBIEE Server has no other source in BMM.
Say, you have a logical table which is made up of two physical tables A & B and hence there is only one source with a inner join on A&B. So whenever, you have a report with only columns from A, then still the query gets fired including table B because it is the only source for this table.
So, to take off these kind of cases create separate logical sources for individual physical tables and for both of them combined.
Hope this helps.
Even I thought of the same reason and I tried creating two seperate logical tables in BMM layer(Earlier I have one LTS and in that I have given inner join for fact1 and fact2).Then I created the report with fact 1 and dimension1.But then when I checked the SQL it is still taking fact2 into cosideration even though I am not using that fact2 .