What is query repository tool?
Answer / madhu
It is utility of OBIEE Admin tool
It allows you to examine the repository metadata
Examine relationship between metadata objects like which column in the presentation layer maps to which table in physical layer
| Is This Answer Correct ? | 2 Yes | 1 No |
How will you create interactive dashboards ?
If you have 3 facts and 4 dimension and you need to join would you recommend joining fact with fact? If no than what is the option? Why you won’t join fact to fact?
If you have 2 fact and you want to do report on one with quarter level and the other with month level how do you do that with just one time dimension?
What is the difference between Data Level Security and Object Level Security?
How to hide certain columns from a user?
You worked on standalone or integrated system?
What are the different types of variables in obiee 11g? Explain
How do i disable cache for only 2 particular tables?
Suppose I have report which is running for about 3 minutes typically. What is the first step you take to improve the performance of the query?
Can you use outer join in BMM layer?
If you want to limit the users by the certain region to access only certain data, what would you do?
What are the different layers of obiee repository?