Rank Method if DB Ranking Not Used

The Rank Method property determines which method to use for ranking calculations. There are three methods for ranking data, and in some cases, this property is ignored. The logic is as follows:

1. If the metric that is being ranked has to be calculated in the Analytical Engine, then the ranking is calculated in the Analytical Engine as well.
2. If the database supports the Rank function, then the ranking is done in the database.
3. If neither of the above criteria is met, then the Rank Method property setting is used.

The most common form of ranking is referred to as Open Database Connectivity (ODBC) ranking. This was the standard method used by MicroStrategy 6.x and earlier. This method makes multiple queries against the warehouse to determine the ranking. ODBC ranking is the default ranking technique, when the database does not support native ranking, because it is more efficient for large datasets.

Analytical Engine ranking generates the result of the ranking operation in the MicroStrategy Analytical Engine and then moves the result set back to the warehouse to perform any further operations and compile the final result set.

Levels at Which You Can Set This

Database instance, report, and template