locked
Display Zero in the empty Rows MDX RRS feed

  • Question

  • HI All,

    I was writing one MDX code so I wanna display "0" for empty rows.

    I was calling two rows in some cases it might have empty rows in some cases. some of them seems not empty but displaying as a empty. I was giving one example and member properties. Can anyone guide me please?

    SELECT 
      NON EMPTY 
        {
          [Measures].[TaskCount]
    
        } ON COLUMNS
     ,NON EMPTY 
        {
            [Dim_Task].[AppointmentStart].[All].CHILDREN
             *
            [Dim_Task].[AppointmentFinish].[All].CHILDREN
        }
      DIMENSION PROPERTIES 
        MEMBER_CAPTION
       ,MEMBER_UNIQUE_NAME
       ON ROWS
     
     FROM(
    	SELECT
    		StrToSet(
    		--	@ParameterJobNumber
    		'[Dim_Task].[TaskNumber].&[86789540001]'
    			,CONSTRAINED
    		) 
    	ON COLUMNS
       
    FROM [Cube]
    )
    CELL PROPERTIES 
      VALUE
     ,BACK_COLOR
     ,FORE_COLOR
     ,FORMATTED_VALUE
     ,FORMAT_STRING
     ,FONT_NAME
     ,FONT_SIZE
     ,FONT_FLAGS;

    Thursday, February 28, 2013 9:50 AM

Answers

All replies