1 person found this helpful
You are mixing things a bit.
OBIEE doesn't use logical indexes for joins, it will go back to the joins you defined in the physical layer for the joins between objects.
That's also why when you define a join in the business layer it doesn't ask you about columns or conditions but you can only define the kind of join (inner, outer etc.).
You can change the logical key of a logical table in the business layer at any moment by checking the properties of the logical table and go to the "Keys" tab. You can remove the "automatically" defined one (OBIEE never define anything automatically you didn't told it to do, "auto" logical keys happen when doing drag and drop of physical keys in general, if you add columns by hand no auto key will be done at all) and define your own key.
Double checks the levels you sets for your various LTS and the hierarchy you setup.
Thank you for your patience and advice. Gianni
Yes my 4LTS are snowflake in physical diagram. I didn't know that I could put them in one LTS even though they don't have a parent child table. You are very helpful!