Rank Function

building reports desktopintelligence
1

Hi All,

Can you help me out how to use the dense rank function in DESKI report level, though i know that there is no function in DESKI report level, But my objective to get the rank.

eg xyx 2000 1
tty 2000 1
avd 1234 3
tyr 1234 3
dfr 600 5

I want the output as

  xyx    2000    1
 tty      2000    1
 avd     1234    2
tyr       1234    2
 dfr      600      3

how do i implement this in report level, i dont have access to universe only have a connection level access.

akhil (BOB member since 2008-07-19)

2

Deski doesn’t have a “dense rank” function, but it does have a Rank() function, which outputs the rank value for a dimension, based on a measure. The syntax is as follows:

Rank(dimension,Measure)

MichaelWelter :vatican_city: (BOB member since 2002-08-08)

3

Hi,

Can you tell me your second column is dimension or measure field ???

If it is dimension use formula as :

=RunningCount() In()

You get result as per your requirement, only you need to apply desc sorting on that dimension column.

I know this is not permanent solution … If it serve your purpose then try …

pravin_gaikwad :india: (BOB member since 2010-03-27)