OBIEE Interview Questions

1. What is an Alias? An alias is a reference to the existing table off the data warehouse in the physical layer OBIEE
2. What are the uses of Alias? which can be used for user defined names in the physical layer which will help us in removing circular joins another use  is we can maintain user defined names for the actual tables
3. What is the difference between Alias and Presentation Alias? physical  alias will be used in the physical layer which will be used in the physical layer. Presentation alias is a reference to the older name of the previous logical column name or presentation name.
4. How to use Complex Join in Physical Layer?.  Drag arrow from first table to second and use fx button to write join condition using between operator.
5. Is it possible to use Outer Join in Physical Layer? No
6. What is LTS? LTS stands for Logical Table Source. It contains there refetence to physical layer objects.
7. How to give left outer join between two tables in obiee? In the BMM Layer, double click on the join and select the type of the join.
8. What are level bases matrices? Matrices which are calculated at the dimensional hierarchy level. Ex: Yearly Sales
9. What is fact less fact? Fact which doesn't have any measurable fields such dollars, amount etc..it will contain only the foreign keys of the dimensions.
10. What is an implicit fact? ImImplicit fact is used to tell the server to refer default fact when attributes from dimensions are referred.