I need a clarification regarding physical layer degin in obiee 11g,I imported Oracle Apps reports ,but could not find any keys there at table level.So should i create keys on the imported table level or at the alias level of the imported tables.
If you import a transaction table you may have keys imported in physical layer but when you going with warehouse table you may not have keys at database level, you define them using join in physical layer.
We have surrogate keys in dwh.
Hope this clear your doubt, if helps pls mark
We cant to any changes on alias type objects in physical layer. You have to do changes in Table objects(original table ) and that will affect on Aliases. During the creation of joins keys are created, tool will prompt for the same.
Hope this helps, if helps pls mark as correct ;)