how do u implement dense rank in bo reports?

Question Posted / poornima

2 Answers
24434 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

what is BIAR file in business objects xi r2

3 Answers TCS,

Is import wizard, report conversion tool, report comparison tool, security viewer ---- where all r migrating tools. whether all the tools available in BOXIR2? ..

2 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

how to connect the hyperlink in webi reports?

7 Answers TCS,

Then how to select the source by using webi or deski reports into crystal reports? i think main source is Businessview. where u import the datasource ?

0 Answers TCS,

Explain is data mart?

0 Answers

what is canned universe and canned reports in bo?

1 Answers

Which versions are used in the bo dashboard work?

0 Answers

HOW TO HIDE Column in WEBI & DESKI?

6 Answers

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

What are the join problems comes appart from loop,chasm & fan Traps

0 Answers IBM,

Hi Can anyone tell me what is Divergence in Business Object Universe Designer. Thanks, Sheik

1 Answers

For more Business Objects Interview Questions Click Here