how do u implement dense rank in bo reports?
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 |
WHAT ARE THE DISADVANTAGES IF WE HAVE MORE FACT TABLES IN UNIVERSE?
. User wants to modify a report and wants to add additional data. How will you approach.
what is meant by report busting
Explain is there any other repository domains rather than universe, security, document?
what is mean by lov?
How to solve the following errors coming in report development? 1.Syntax 2.multi value 3. #Error 4.computation and 5.Objects are not compatible
IF VIEW IS FASTER THAN DERIVED TABLE WHY WE ARE USING DERIVED TABLE IN BUSINESS OBJECTS?
IN BOXIR2 creating universe by using Designer and Business View. What is the difference b/t two?
What is a fantrap in business objects?
what is universe null
What is sdlc in bo?
Difference between Decode and Case?