SSAS MDX Round = Banker's Rounding
A couple of weeks ago I was working on a project where I had to implement some Ranking calculations within an Analysis Service (SSAS) cube. I went ahead and added in the calculations and then the client came back to me and stated that there was some additional business logic that we needed to implement. At different levels of reporting they utilize some rounding into the calculation that is used to determine the Ranking. When viewing the report at a store level then we need to round the calculation to two decimal places and at all other levels the value will be rounded to four decimal places to be used in the Ranking function. I thought to myself 'no problem' and I went ahead and added in this additional logic and put the Round function into place to handle this logic. Done.
Read more...Tags: mdx