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
Explain the SQL Queries activated to data base from Data provider in BO ?
Explain what sort of existing documents should business analysts refer to when starting on a new project?
What is difference between webi and infoview?
Its regarding Javascript coding for customization in BI4 reports. We need to have all the options disabled in the report except the option to Export(save the report in computer in Excel/pdf formats). I am able to hide TopBar,TabBar,Left Navigation etc but I need "Export" option to be displayed to the users in Read mode. Can this selective "hiding" be achieved?
What is a category?
WHAT ARE TEMPLATES? EXPLAIN WHAT YOU HAVE CREATED?
What is the slice and dice?
1.what is context? How u create? With example.
Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?
How many ways you can restrict data in business objects?
What is the pivot option ? what is the need of it?
Please anybody tell me Is Data integration And ETL programming is same..? Thanks in advance....