I have a situation like one manager can have multiple learners under him. each learner will registered for more than one certifications . their statuses for different courses like completed, inprogress, dropped, no certifications. the question is i have check for each user for statuses if he had some completed certifications i have to get latest completed date and omit all other stauses. if he had no complete staus then i have to get latest inprogress record based on date. like this i have to select only one record for user. but i am getting one row for each status. among all completion status one record, for all inprogress one record, for all dropped status one record. how can i show only one record

0 Answers   Flextronics,

---

What is the difference between slice and dice and cross tab report?

0 Answers  

---

What is a bo repository?

0 Answers  

---

5.what is slowly changing dimension ?

2 Answers   IBM,

---

how we improve the performance of report and universe?

4 Answers   Accenture, IBM,

---

what is difference between folders and category ?

4 Answers   Tech Mahindra,

---

If there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the left join query?

0 Answers  

---

it is possible to link two universes of separate functional domain ?

1 Answers   IBM,

---

what are the all possible reasons of getting partial result on a webi report?

3 Answers   L&T,

---

wat is report linking in BO..I know that 2 reports can be linked in BO with the help of writing a HTML code .But how. wat s the code.can u give me the example of code taking e fashion as the simple univers data provider.

2 Answers   Accenture,

---

Explain the difference between union and group?

0 Answers  

---

Can we take report on Excel in Business Objects?

6 Answers   Business Intelligence Analytics, Oracle,

---