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?

1 Answers  

---

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?

1 Answers  

---

Define pipeline. Did you use it in your projects?

1 Answers  

---

Can you use physical join in BMM layer?

1 Answers  

---

How will you create report from two subject areas

0 Answers  

---

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?

1 Answers  

---

How online/offline mode impact development and delpoyment?

0 Answers  

---

If there are 100 users accessing data, and you want to know the logging details of all the users, where can you find that?

1 Answers  

---

What are the different types of security you have worked in obiee?

0 Answers  

---

How do you identify what are the dimension tables and how do you decide them during the Business/Data modeling?

1 Answers  

---

What is object level security?

1 Answers  

---

What is connection pool and how many connection pools did you have in your last project?

1 Answers  

---