how do u implement dense rank in bo reports?

Question Posted / poornima

2 Answers
24766 Views
CTS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

how do u implement dense rank in bo reports?..

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

how do u implement dense rank in bo reports?..

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

Post New Answer

More Business Objects Interview Questions

Its regarding Javascript coding for customization in BI4 reports. We need to have all the options disabled in the report except the option to Export(save the report in computer in Excel/pdf formats). I am able to hide TopBar,TabBar,Left Navigation etc but I need "Export" option to be displayed to the users in Read mode. Can this selective "hiding" be achieved?

0 Answers

Hi, I would like to know how is the integration if we want to use Oracle Essbase as the Cube Engine, and present the Cube by Business Objects Presentation Layer? Can Oracle Essbase be integrated with Business Objects? Thanks,

0 Answers

disadvantages of boxi

2 Answers Accenture,

What is detailed Object

1 Answers IBM,

is there any limit for rows and columns in cross tab

4 Answers

Give some information on report bursting?

0 Answers

Difference between Decode and Case?

8 Answers Polaris, TCS, Wipro,

Hi friends, How many types of dimentions are they ?What are they? Thanks in advance