SQL Server Analysis Services 2005/2008 articles,blogs,scripts,FAQs,tools,books

Consider the following requirement: "We want our measure to be truncated to 4 decimal places without any trailing 0s after the decimal point and a comma as a thousands separator."

First, let's focus on the truncation part. If we want that to happen for a measure, we can do it through the following formula, as I have described previously:

SCOPE([Measures].[Our Measure]);
This = Fix([Measures].[Our Measure]*10^4)/10^4;
END SCOPE;

This takes care of our truncation. So far so good.

Read more...