Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

differences in cross join sintax in MDX

Status
Not open for further replies.

boligoma

IS-IT--Management
Feb 11, 2003
31
MX
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
 
Code:
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.

Code:
{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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top