Interested to Buy Any Domain ? << Click Here >> for more details...
how do u implement dense rank in bo reports?
- 2 Answers
- 24491 Views
- CTS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / shikha
The DENSE_RANK function computes the rank of a row in an
ordered group of rows.Rows with equal values for the
ranking criteria receive the same rank.
For eg.
To Show the set of sales people who make the top 3
salaries - that is, find the set of distinct salary
amounts, sort them, take the largest three, and give me
everyone who makes one of those values.
SELECT * FROM (
SELECT deptno, ename, sal,
DENSE_RANK()
OVER (
PARTITION BY deptno ORDER BY sal desc
) TopN FROM emp
)
WHERE TopN <= 3
ORDER BY deptno, sal DESC
/
DEPTNO ENAME SAL TOPN
---------- ---------- ---------- ----------
10 KING 5000 1
CLARK 2450 2
MILLER 1300 3
20 SCOTT 3000 1 <--- ! (in
case of rank
JONES will have
3 and dense
rank will have 2)
FORD 3000 1 <--- !
JONES 2975 2
ADAMS 1100 3
30 BLAKE 2850 1
ALLEN 1600 2
30 TURNER 1500 3
| Is This Answer Correct ? | 11 Yes | 6 No |
Answer / nareshkumar
Dense Rank is used for assigning a precedence or rank to
each row in the result set relative to other rows in the
result set.
| Is This Answer Correct ? | 5 Yes | 9 No |
How many universe dfi you create if you have 2 years of experience in BO
If there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the left join query?
how to test reports in businessobjects?
Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
What is the difference between condition & filter?
Hi, What is the best answer for tell me about yourself for 2 years experience in bo developing.
I have a report with two queries and each query have prompt on some object. Tell me how many times it will ask for the input?
What are the types of errors you faced while creating a report from two different data providers
how to creat 2 way drilling mode.can any one know this
Explain what would you consider as your biggest achievement and why?
what is universe testing(not mention check integrity)
GENARALLY WHAT ARE THE PROBLEMS ARE FACING WHILE CREATING REPORTS?
Teradata 
