Post reply

Defaults in Analysis Services

  • June 27, 2005 at 12:31 pm

    #111142

    I have something I would like to do, but I am not sure if you can, or how to if you can.

     

    In the picture, there are blank spaces for certain values in the cube, is there any way I can force a default (0.00) onto it? Also, can I force formatting ($#.00)?

     

    I know you can with MDX and/or calculated members, but what about measures?

     

    Thanks,

    Michael

     

  • June 28, 2005 at 12:34 am

    #568820

    Hi Michael,

    Yes you can click on the measure .Goto advance tab in properties and change

    the display format.

    Hope this helps.

    Regards ,

    Hemanth

  • June 28, 2005 at 3:01 am

    #568853

    The blank values are nulls, if you want these to be assumed to be 0 then you need to get rid of the nulls in the sql used to generate them, by using coalesce(x,0) or case statements etc. Obviously this could give incorrect answers where a null exists because the number isnt known so you'll need to think about when to assume 0...


    Phil Nicholas

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

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