What is the difference between Single Logical Table Source and Multiple Logical Table Sources?
Answer / madhu
If a logical table in BMM layer has only one Table as the source table then it is Single LTS.
If the logical table in BMM layer has more than one table as the sources to it then it is called Multiple LTS.
Ex: Usually Fact table has Multiple LTSs, for which sources will be coming from different Physical tables.
| Is This Answer Correct ? | 3 Yes | 1 No |
How do you implement security using External Tables and LDAP?
We have 4 dimension tables, in that 2 tables need to have hierarchies then in such a case is it mandatory to create hierarchies for all the dimension tables?
How do you work in a multi user environment? What are the steps?
How do you know which report is hitting which table, either the fact table or the aggregate table?
How do you split a table in the rpd given the condition. ( the condition given was Broker and customer in the same table) Split Broker and customer.
How online/offline mode impact development and delpoyment?
What is logging level? Where can you set logging levels?
What is the end to end life cycle of OBIEE?
How do you identify what are the dimension tables and how do you decide them during the Business/Data modeling?
What are the different types of variables in obiee? Explain
What is data level security?
What is aggregate navigation? How do you configure the Aggregate tables in OBIEE?