Skip to Content
0
Former Member
Feb 25, 2009 at 02:47 AM

How to use '<' in where condition of MDX query

282 Views

Hi All ,

Need help in using 'less than ' function in the where clause of MDX query

Below is the query

[0MATL_GRP_2].[20MATL_GRP_2],
[0MATL_GRP_3].[20MATL_GRP_3] ON ROWS
FROM RCHL_M01/STQ_CHLD_Q001
WHERE (
[0SOLD_TO__0ACCNT_GRP].[ZSHB] ,
[0MATERIAL__0MATL_TYPE].[ZSTK] ,
[GCCREADAT].[20081010] )

Instead of of date 20091010 ,I need to use < 20081010.

Thanks in ADV

Vinay

Edited by: vinay kolla on Feb 25, 2009 3:47 AM