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


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Business Objects Interview Questions

Are you in Developing or Support in BUSINESS OBJECTS. What is the difference? what are the responsibilites in both?

2 Answers   CSC,


1. What is the difference between in creating filters in designer and business objects? 2.How did u give a developed universe to your client? 3.If i want to grant access to a report to a group of users,how do i do?

2 Answers  


What is Universe?

1 Answers  


what are they different types of report in BO?

6 Answers  


Hi All, I have found out this site very interesting and knowledge sharing site.I was wondering if you can tell me where I can get study materials for the BO XI 3.1 or suggest me the one that you have taken recently. Regards, Ace

1 Answers  






What is the use of Surrogate key in BO?

8 Answers   IBM,


1.what is input level context and output level context in webI? 2.what is a cascading prompt? Where will you give this and how? 3. What is External Strategy?

1 Answers   IBM,


what are the roles and responsibilities of BO Administrator ?

1 Answers   OCS Infotech, TCS, Wipro,


What is Array bind size in universe? Plz

2 Answers   TCS,


how to solve #multivalue, #syntax, #error. iwant complete solution process in practical wise?

1 Answers   Accenture, TCS,


WHAT ARE THE VARIOUS PRODUCTS IN BO?

2 Answers   Polaris,


What are the Different Data Providers support in Web Intelligence and DeskTop Intelligence?

3 Answers   Perot Systems,


Categories