Hi

Thanks for your answer..based on ur query,i have written like this.

SELECT NON EMPTY { } ON COLUMNS,

NON EMPTY { ([PH_CUST].[CUST].ALLMEMBERS ) } ON ROWS

FROM Ad_CUBE

where except([PH_CUST].[Cust].Children,{[EMP].[PHWEB].[Activce].&[1]})

is it Correct thing i have done?

i am just tryng basic..please let me out..

Thanks in advance

aa