Hi guys,
has anybody used the RANK function in Analysis Services? I have been trying to make it work with no success.
According to Books Online the syntax is:
Rank(«Tuple», «Set»[, «Calc Expression»]), but no matter what I put into the «Calc Expression»] part it seems to ignore it.
If somebody could post some working example (eg on Foodmart 2000 database) I would much appreaciate it.
Thanks