ApplySimpe statment je funkcija koja se koristi u OLAP alatu MicroStretegy. Ja sam sa neta skinuo jedan iskaz koji mi je potreban za generisanje novog atributa, medjutim, ne znam kako da ga prevedem u iskaz koji je validan u MSSQL 2008. Student sam, ucim alat pa mi treba pomoc.
Razumem CASE WHEN (( )) BETWEEN 0 and 10 then '0-10' .....
from dat_rodj ..... ,
Hvala u napred.
Code (sql):
ApplySimple("CASE when ((months_between(sysdate, #0)) / 12) between 0 and 10 then '0 - 10'
when ((months_between(sysdate, #0)) / 12) between 10 and 19 then '10 - 19'
when ((months_between(sysdate, #0)) / 12) between 20 and 29 then '20 - 29'
when ((months_between(sysdate, #0)) / 12) between 30 and 39 then '30 - 39'
when ((months_between(sysdate, #0)) / 12) between 40 and 49 then '40 - 49'
when ((months_between(sysdate, #0)) / 12) between 50 and 59 then '50 - 59'
else '60+'
end",dat_rodj)
when ((months_between(sysdate, #0)) / 12) between 10 and 19 then '10 - 19'
when ((months_between(sysdate, #0)) / 12) between 20 and 29 then '20 - 29'
when ((months_between(sysdate, #0)) / 12) between 30 and 39 then '30 - 39'
when ((months_between(sysdate, #0)) / 12) between 40 and 49 then '40 - 49'
when ((months_between(sysdate, #0)) / 12) between 50 and 59 then '50 - 59'
else '60+'
end",dat_rodj)
Razumem CASE WHEN (( )) BETWEEN 0 and 10 then '0-10' .....
from dat_rodj ..... ,
Hvala u napred.