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
- 6941 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
How to create Index to the table in the universe designer and how it improves the Query performence
how to prepare the documentation in business objects and where to get the requirement?
When we use aggregate awareness function in designer?
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 would you format some text using css to be verdana and bold?
How to sort the dynamic objects alphabetically on the Universe based on and SQL Server
Regarding Hyperlinking in Business Objects. We have a few reports in QA environment where a number of hyperlinks are employed using OpenDoc function.In some of the reports,hyperlink is used to move to another tab within the same report.The formula used include "DocID" and ReportName="tab name".This works fine but now,for the PROD move,this will not work as the Doc Ids are subject to change. Is there a way to overcome this?Without DocID,how will move to a particular tab? Thanks in advance
1)I have createcd a dashboard on Bex query. How to refresh the Dashboard without hitting the bex query? 2)What is Event based scheduling in BO? 3) How to display the BO webi report title using a function? 4) For eg in my webi report iam having a person name like Jhon Peter Adam. But i need to get only the middle name of the person like Peter. What function is used in Webi to get this?
If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?
How can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?
Can Bo generates the Report from the cubical data Explain?
What are the data types present in bo? What happens if we implement view in the designer and report?
Explain difference between zabo and webi?
Explain the difference between union and group?
Explain the data types present in bo and what happens if we implement view in the designer and report?
