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

I have set of reports in BO4.0 and need to use "Hyperlink" functionality. I had to use native hyperlink functionality provided in BO4.0 but looks like it's available only in Rich Client.Currently,we have only Infoview B04.0 Launch Pad.Is OpenDoc the only hyperlink option on BO4.0 Launch Pad? Thank you.

0 Answers  


Tell me the difference between cmc and cms?

4 Answers   Wipro,


Ihave one report.Now i want to display that report as one row as one color and another row as another color.The entire report i need like that

3 Answers   BirlaSoft,


how to find the size of the report

1 Answers  


why we are using derived tables ?how it will help?

2 Answers  






Did you face any problems while creating reports? Name? Solutions?

0 Answers   IBM,


What are the general problems that are faced while importing the .biar files and what is the solution to overcome it in business objects?

0 Answers   IBM,


What is the purpose of @aggregate aware function?please draw, how you use the @aggregate aware function

6 Answers   Cap Gemini, Deloitte,


What is meaning of fullpath client in business objects?

1 Answers   Atiric Software,


what do u mean by merged dimensions in Business Objects

2 Answers   Business Intelligence Analytics, TCS,


What is the difference between master-detail and Breaks?

3 Answers  


what is diff between Decode and case ? Give some Example?

2 Answers  


Categories