[Mondrian] CASE/WHEN Statement in Where clause
Kleyson Rios
kleyson.rios at saude.go.gov.br
Fri Jan 25 13:12:11 EST 2013
Hi,
Is it possible use CASE/WHEN in Where clause ?
For example:
select NON EMPTY {[Measures].[ConstStr]} ON COLUMNS,
NON EMPTY Order({[Convenio].[Todos convenios].Children}, [Measures].[Porcentagem], DESC) ON ROWS
from [Fatur]
where
CASE WHEN 'All' = 'All' then {[Tempo].[2011]}
ELSE Crossjoin({[Tempo].[2011]}, {[Tipo Despesa].[Honorario]})
END
Thanks in advance.
Kleyson Rios.
More information about the Mondrian
mailing list