Top rank on large amount of data
we are trying to return top 100 row using advance function of Top Rank N.
the issue is that we are reaching the row limit since the calculation is done in the tool level
(as for all advance functions) and not in the DB, and so the data is truncated and show a wrong result set.
this is an big issue a specially when working with Top\ Bottom functions.
Is there any plan to allow this function to run in the DB? or some kind of other solution planned?