Post reply

Problems with decimal places of a measure

  • July 6, 2009 at 8:39 am

    #207887

    Hi,

    I've created a cube based on a calculated query (hope, that's right, 'cause I'm working on a German system). One of the columns is a currency value. I'm using this value as one of my measures (it is also definied as currency). Stangely in some rows the decimal places are gone when I look at the cube, in some not. I could not find any pattern why the decimal places are cut off or why not.

    Does anyone have an idea, what's going wrong here?

    Thnx,

    Ralf

  • July 9, 2009 at 5:02 am

    #1022263

    I've found a workaround:

    The original value was numeric(9,2) within my SQL statement I did the following

    cast(round(field, 2) as money)

    Now the decimals are no longer lost in the cube.

  • July 9, 2009 at 5:02 am

    #1022264

    I've found a workaround:

    The original value was numeric(9,2) within my SQL statement I did the following

    cast(round(field, 2) as money)

    Now the decimals are no longer lost in the cube.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply