I have an oracle classic analysis. The subject area has one fact table with attribute tables in a classic star pattern. The subject area does not have dimensions. I am trying to get one of the attribute tables to perform a left join so that it will not eliminate rows that don't exist in the attribute table. I have changed it to left outer join in the BMM layer, and I've tried it both with and without a driving table. Neither works.
Here's my subject area BMM model.
Here's the join. I've tried every trick that AI can come up with and nothing works. I hope someone has an answer
