Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 1984 Views
- Flextronics, I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
Can more than 1 metric be applied on an analytic in business objects?
What are the security level used in BO?
How to particiapte the columns availabe in the Derived tables in the Reporting window? How it's done?
Can anybody tell me the difference b/w canned and adhoc reporting?.
limitaions of cross tab ?
What are the Errors in BO Pls Explain with Examples
2 Answers iFlex, Tech Mahindra,
tell me about aggregate awareness in detail?
Difference between Decode and Case?
8 Answers Polaris, TCS, Wipro,
How to check for a particular value from one column with the list of values present in another column in Webi reports?
How to Analyise 'Join' problem and which method is the best to resolve that ?
What is a Set?
1.How to convert deski document to webi in infoview? 2.what is connection type for free hand sql?
Teradata 
