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 to get sql from obiee for reports?
what is guided navigation?
What is level based metrics.how will you create it?
What are different types of variables?
What are the challenges you faced while making of reports?
Can you use physical join in BMM layer?
How many bi services node can be clustered together?
If you want to create new logical column where will you create (in repository or dashboard) why?
How do you identify what are the dimension tables and how do you decide them during the Business/Data modeling?
How will you enable or disable caching in the system level and table level?
What is query repository tool?
What is the end to end life cycle of OBIEE?