how do u implement dense rank in a report?
Answer / kevin
By default when we implement the ranking on an entity using menu option Analysis->Filter->Ranking or by creating a variable using Rank function, Business Objects applies dense ranking by default.
| Is This Answer Correct ? | 0 Yes | 0 No |
Pls Explain about the different between 6.5 & Xi R2
Can you please send me the migration related issues .
How to make hilight the whole row by using ALERTS asof revenue is more than xxxxx?
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
can anybody explain me in detail what is the difference between desktop intelligence and web intelligence in detail?
what do u mean by merged dimensions in Business Objects
2 Answers Business Intelligence Analytics, TCS,
What are @FUNCTION?
how to restrict up to three levels in hierarchy when u do drill mode?
What is the difference between Thin client & thick client?
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:)
What is the definition of derived table ?
If there is no common dimension? Is it possible to combine two different dataproviders?