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

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.

How will you move reports from Dev to QA in BO

3 Answers   Infosys,

---

can any body tell me how to create Hyperlinks in BO XI R2?

2 Answers  

---

IS THERE ANY MINIMUM RQUIREMENT TO DEFINE CONTEXT?

2 Answers   Clover, Rolta,

---

BO Security (creating the restriction sets in Universe and applying on selected groups or users) or Database security (Creating the tables in database insrting the user details in that tables and giving conditions in self restricting joins in Universe )Which Security will improve the performance of the reports and for best practices ? I am thinking BO Security will give the better performance, could you please share your thoughts on this please... Thanks...

0 Answers  

---

when and where we use @varialble function

1 Answers  

---

How to create an popup in the WEBI report if the report is showing partial result?

2 Answers   Banking, IBM,

---

6.what is conformed dimension? R u used?

8 Answers   TCS,

---

In a column if the value is >10000, it has to show downwards Arrow in green color, If the value is <10000, it has to show upwards arrow in red Color.... How to achieve this?

4 Answers   Cap Gemini,

---

can we use detail in generation of reports? if customer id is a dimension in a report, what will happen if we define it as a detail?

3 Answers  

---

How will solve a loop caused by lookup table without using alias?

1 Answers   L&T,

---

What is metrics?

2 Answers  

---

how to increase the perfomance in ur designer & reporting? how to reduce the refershing time & what precations would u take ?

3 Answers   TCS,

---