insert into t(id) select level from dual connect by level <6;
select * from T
MODEL
DIMENSION BY( ROW_NUMBER() OVER ( ORDER BY ID)*2 RN )
MEASURES (ID)
RULES
(
ID[ RN BETWEEN 4 AND 8]=ID[cv()] * 2
)
ORDER BY RN;'
I am getting an error ORA-32637: Self cyclic rule in sequential order MODEL since i am using the same dimension column in cell and dimension reference.
I want to double the values of ID which are RN between 4 and 8