Help with MDX query

Hi, I have this MDX query

SELECT { [Measures].[CANTIDAD_TRANSACCIONES] }ONCOLUMNS, { ([FECHA_TRANSACCION].[FECHA TRANSACCION].[FECHA TRANSACCION].ALLMEMBERS * [NOMBRE_BENEFICIARIO].[NOMBRE_BENEFICIARIO].[NOMBRE_BENEFICIARIO].ALLMEMBERS ) }DIMENSIONPROPERTIESMEMBER_CAPTION,MEMBER_UNIQUE_NAMEONROWSFROM [ADESS_CUBE]CELLPROPERTIESVALUE,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.

[2996 byte] By [FernandoAlvarez] at [2008-1-8]

«« RFID BizTalk Process can''t view tag ?
»» Multiple web applications in one setup possible?

# 1

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]

DeepakPuri at 2007-10-2 >

top of Msdn Tech,SQL Server,SQL Server Analysis Services...

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech