rank and dimension limits

[#1]

which one is the best in terms of performance to use either rank() function or dimensional limits to get the top 10 values?

[robert_mika]

I would suggest the Dimension Limit as is already build it functionality already optimized for this task.

[#3]

Dimension Limits

[pratap6699]

assume that sum(sales) is our expression and employee is dimension ...u need to display to 10 employee sales dynamically right? we use aggr funtion with rank() we done this requirement....

at conditional dimension-->=Aggr(If(rank(Sum(sales))>=20,employee),employee) exp-->sum(sales)

[pratap6699]

=Aggr(If(rank(Sum(sales))>=10,employee),employee)

[#6]

I would recommend Dimension Limit as it is built-in Function and made for limiting Dimension values and will have better performance.

[awhitfield]

Another vote for DIMENSION LIMITS

Andy

[#8]

Unless you are looking to use a pivot table (or another object with similar constraints), dimensional limits is the way to go

[#9]

Thank you all for your replies..

but may i know the difference between those two rank() and dimensional limits?

[pratap6699]

rank() returns the quantity wise sales by dynamically through expression....but dimension limits also return the same thing without using expression...but sometime in conditional damension we use aggr & rank() as per requirement