Display dimension decimal in a Cube report


  • I have created a MSAS cube and dimension and am having problems displaying the correct decimal values in the report. However when I browse the dimension data in the view the data is diaplayed correctly. See the following example....

    Dimensional View Values   Values as displayed in the report

    0.00000                            0
    0.00010                            0.0001
    0.00020                            0.0002
    0.00200                            0.0020

    The problem seems to be that the trailing zeroes are being truncated. How do I get to display all of the decimal values. We are running Sql Server 2005

    Monday, August 31, 2009 3:34 PM


All replies