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
- 5777 Views
- I also Faced
- E-Mail Answers
Answer Posted / gs2kumar@gmail.com
Max(Payment_due_date) use this in report level create a variable or in cell.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
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.
Explain is it the job of a business analyst or systems analyst to draw the class diagram?
What is the difference between the public object&schema object?
What is the profile and package?
Can we configure two instances of CMS pointing to two different CMS system databases?
What are all the points to keep in consideration, while we are migrating the Universes,Reports from BO5.1.6 to BO 6.5? Is is compatible to migrate like this? Does it effect the filters in Reports and Join in the Universe?
Explain when we use aggregate awareness function in designer?
Is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes
Explain what three things do you consider to be the most important factors for a manager?
(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.
Explain what is the difference between slice and dice and cross tab report?
What are the general problems that are faced while importing the .biar files and what is the solution to overcome it in business objects?
is it possible to export the webi reports to crystal reports?with out using businessview?
Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?
