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
There is one report running and a user wants to know whether data is from detail table or summary table. what is your approach?
What are the major problems will occur while migrating to the one version to another version?
Can Bo generates the Report from the cubical data Explain?
How can we improve performance?
What is the report extension in webi and deski
Types of universes in business objects?
Hi, What is the best answer for tell me about yourself for 2 years experience in bo developing.
What's the Functional & Architectural Differences between Business Objects & Web Intelligence Reports?
What is the difference between business requirement document and use case document.
What is user docs and how to use this option in bo?
how to link 3 fact tables
What is self join