how do u implement dense rank in bo reports?
- 2 Answers
- 23805 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 can you first report in Business Objects by using broadcast agent?
0 Answers Ness Technologies, Wipro,
In a Webi Report, Once u r entering a month name,it displays the that month details and after and before month details.How it is
How we can add a comment in universe...?
suppose case1:a person buy a car case2: rent a car which is context & which is alias? why?
how to creat 2 way drilling mode.can any one know this
Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
What is drill across ? can anybody explain me in detail?
How to delete the duplicate colums in a sql table ?
What are the traps ? What are the disadvantages of traps?
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?
in report level u find from which context u use,why it appears,what is the reason,how u resolve in report level
What are templates? Explain what you have created?
Teradata 
