Help with MDX query

Hi, I have this MDX query

SELECT { [Measures].[CANTIDAD_TRANSACCIONES] } ON COLUMNS, { ([FECHA_TRANSACCION].[FECHA TRANSACCION].[FECHA TRANSACCION].ALLMEMBERS * [NOMBRE_BENEFICIARIO].[NOMBRE_BENEFICIARIO].[NOMBRE_BENEFICIARIO].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM [ADESS_CUBE] CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS

This query brings the following

FECHA_TRANSACCION NOMBRE_BENEFICIARIO CANTIDAD_TRANSACCIONES

2007-01-01 00:00:00 ANDRY SUAREZ (null)

2007-01-01 00:00:00 FERNANDO ALVAREZ 4

2007-01-01 00:00:00 PEDRO PEREZ (null)

2007-02-01 00:00:00 PEDRO PABLO 7

The problem is that I just want to select the (null) ones without displaying the colum cantidad_transacciones.

Could anyone please help?

Thanks.

If only the rows with (null) [CANTIDAD_TRANSACCIONES] above should be returned, you could try the HAVING clause, like:

Code Snippet

SELECT {} ON COLUMNS,

{ ([FECHA_TRANSACCION].[FECHA TRANSACCION].[FECHA TRANSACCION].ALLMEMBERS * [NOMBRE_BENEFICIARIO].[NOMBRE_BENEFICIARIO].[NOMBRE_BENEFICIARIO].ALLMEMBERS ) }

Having IsEmpty([Measures].[CANTIDAD_TRANSACCIONES]) ON ROWS

FROM [ADESS_CUBE]