differences in cross join sintax in MDX

[boligoma]

Hi,

Does anyone nows what is the difference between these two rows?

NON EMPTY CrossJoin ({[GpoParametro]}, {[NivelCuentas].[Nivel2].members}) on rows

{NonEmptyCrossjoin({[GpoParametro]}, {[NivelCuentas].[Cve Nivel2].members})} On Rows

In the first one, it shows me rows with ceros in the measures. In the second one, it doesn't show the rows with ceros.

Any idea?

Thanks

 

[MDXer]

NON EMPTY CrossJoin ({[GpoParametro]}, {[NivelCuentas].[Nivel2].members}) on rows

The above will filter out and not display any rows that are empty, but the tuples are still queried.

{NonEmptyCrossjoin({[GpoParametro]}, {[NivelCuentas].[Cve Nivel2].members})} On Rows

This will not Crossjoin where data does not exist. Depending on the desired result this piece will actually perform faster.

For a better understand of MDX and it's functions I suggest MDX Solutions By George Spofford (WIley Computer Publishing) ISBN 0-471-40046-7



"Shoot Me! Shoot Me NOW!!!"
- Daffy Duck