По просьбе AmKad (ну или кого-то, кто им так представился в почте), пост через lynx, дабы пропихнулось
with s as
(select 1 id from dual union all
select 2 id from dual union all
select 4 id from dual union all
select 5 id from dual union all
select 6 id from dual union all
select 8 id from dual union all
select 10 id from dual union all
select 13 id from dual
)
select id, sm
from s
model
dimension by (row_number() over (order by id) rn)
measures (id, id as sm)
rules
(sm[rn = 1] = id[cv(rn)],
sm[rn > 1] = sm[cv(rn) - 1] * id[cv(rn)]
);