Any way to control the number of decimal places when viewing an SSAS cube?

Question

When I look at the cube and collapse Sales by Month (for example), I get something like 12345.678901.

Is there a way to make it so that when viewed by the user they get values ​​rounded to the nearest two decimal places, i.e.: 12345.68 instead?

Thank,

-plush

Answer 1

, OLAP , . 1 - "#, 0.0; (#, 0.0)". Excel , Reporting Services .

, , , Currency. Analysis Services Double, Money. , . . : . - .

Answer 2

, 2 , - .

MDX:

WITH MEMBER [Measures].[NewMeasure] AS '[Measures].[OldMeasure]', FORMAT_STRING='##0.00'

Answer 3

. :

• -

  'Format String'   

• -

  Go to the calculations and update the 'Format String'