Post reply

DISPLAY AMOUNT VALUES IN DECIMALS IN CUBE BROWSER

  • December 5, 2008 at 10:20 am

    #198540

    How to

    DISPLAY AMOUNT VALUES IN DECIMALS IN CUBE BROWSER.

    298.50

    298

    300

    300.45

    i need to display like

    298.50

    300.00

    298.00

    300.45

    Help appreciated

  • December 5, 2008 at 10:36 am

    #908502

    In which cube browser?

    Measures in the cube have a format string property that most browsers seem to support.

  • December 5, 2008 at 10:46 am

    #908515

    IN THE SSAS CUBE BROWSER ITSELF NOT IN EXCEL OR ANY OTHER INTERFACE.

    HELP APPRECIATED

  • December 5, 2008 at 10:53 am

    #908519

    Please turn off your caps lock.

    If this is an actual measure rather than a calculated one, you need to go into the properties for the measure in BIDS and set the format string and re-deploy the cube.

    If it is a calculated measure, you need to set the format string for it in the calculations in BIDS and re-deploy your calculations.

    I suggest you look up "format string" in books online.

  • December 5, 2008 at 11:09 am

    #908538

    Thank you for your reply, can you make me clear it is not a calculated measure i am just taking from measures and dropping in details area of cube. I want to display the decimal values also. I saw the properties but i did not get any help from that.

  • December 5, 2008 at 11:19 am

    #908553

    Open the cube in BIDS.

    Select the cube structure tab (it's the default)

    Right-click the measure in the treeview and select properties

    In the properties window, change the FormatString property to: #.00

    Save / deploy the cube

Viewing 6 posts - 1 through 5 (of 5 total)

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