Answer / karthis4u

Doing performnce tuning in DB side.In obiee side,updating etting in connection pool or creating seperate connection pool for authorisation and heavy tables/aggregate tables.

Can you use outer join in BMM layer?

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  

---

You worked on standalone or integrated system?

1 Answers  

---

How will you go about adding additional column to the repository in the presentation layer?

0 Answers  

---

How analytics process your request when you create your requests?

0 Answers  

---

Can you have multiple data sources in OBIEE?

1 Answers  

---

What is the difference between Data Level Security and Object Level Security?

1 Answers  

---

How to enable drills in a given column data?

0 Answers  

---

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

1 Answers  

---

How will you port changes for dashboards,reports,rpd from development to production?

0 Answers  

---

can you change the location of the obiee repository?

0 Answers  

---

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  

---