[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