CROSSJOIN behavior

Hi all,

I'm using this calculation:

{[Dim Tarjetas].[SK Tarjeta].members}
*
{([Measures].[Num Tx])}

I would expect to find all the SK Tarjeta items that have a Num Tx associated with. Instead, I get the SK Tarjetas that have a Num Tx associated with the, PLUS the default SK Tarjeta (0) with a (null) value on NumTx.

What am i doing wrong?

Thanks

Felipe

Since you specifie dimension.members, I believe you are selecting all members even if there is no data. Have you tried NON EMPTY {}?

Another suggestion, can you change code to something like this:

SELECT {[Measures].[Num Tx]} on 0,
[Dim Tarjetas].[SK Tarjeta].members on 1
FROM [cube]

Thanks Marco, I'll try this.