Interested to Buy Any Domain ? << Click Here >> for more details...
I need to select the rows based on the
latest 'Payment_due_date' column value.
Let's say I have a Deski report with 3 columns:
Payment_due_date,
Cust_Name,
Oustanding_Amt.
Report is like this:
=====================================
Payment_due_date,Cust_Name,Oustanding_Amt
02/28/11 , Bob, 115
03/31/11 , Bob, 90
02/28/11 , Mike, 120
02/28/11 , Susan, 220
05/31/11 , Bob, 80,
03/31/11 , Susan, 70
05/31/11 , Mike, 220
05/31/11 , Susan, 120
04/30/11 , Susan, 130
So,we would like to see (based on latest Payment_due_date)
==================
05/31/11 , Bob, 80,
05/31/11 , Mike, 220
05/31/11 , Susan, 120
Oustanding_Amt comes as SUM(Oustanding_Amt) from Universe.
If we use Max(Payment_due_date),we do get one row but then,
the column 'Oustanding_Amt' sums up.
Not allowed to use do SQL Override .Context Operators
aren't working.
Thanks in advance:)
- 3 Answers
- 7199 Views
- I also Faced
- E-Mail Answers
Answer Posted / rahul
You can achieve this by having a condition.
i.e put payment_date in condition panel-->select operator
as "equal to"-->operand "calculation"-->follow the
steps"select object(payement_date)"-->select function
(maximum)-->Globally-->for each value of one or more objects
(cust name)--finish
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Which command using Query Analyzer will give you the version of SQL server and operating system ?
Explain about a tricky situation for which you found a very simple solution?
Difference between zabo and webi?
What is the difference between the public object&schema object?
What is the difference in creating filters in designer and business objects?
What are the general problems that are faced while importing the .biar files and what is the solution to overcome it in business objects?
How many universes can be created in a project?
What is the difference between datawarehousing and businessintelligence?
hi all of u, i want to learn the course in SAP(BI).because of there is no calls for BO. And the another region is it will be converted into SAP module. is it OK for me? is there any feauture in coming days? could any one plz send me the message
Explain how to execute the plsql procedure from the report by clicking with mouse?
Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?
(1) Is it possible to create measures using objects from different context. (2) If cross context measures are not possible then what about @aggregate_aware() function ,here we use objects from different contexts. (3)Two measures from two different context ,can they be summed at report level.
Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com
Explain what sort of existing documents should business analysts refer to when starting on a new project?
Explain which versions are used in the bo dashboard work?
