Hi !
The “RULES” keyword is mandatory if you iterate otherwise it is optional. Plain SELECT statements shall not have blank lines.
DEMO:
select*from dual model dimension by(1 x)measures(1 y)rules(y[2]=314);
formats well but …
select*from dual model dimension by(1 x)measures(1 y)(y[2]=314);
Generates an empty line
/* Formatted on 24/06/2013 13:25:45 (QP5 v5.252.13127.32847) */
SELECT *
FROM DUAL
MODEL
DIMENSION BY (1 x)
MEASURES (1 y)
(y [2] = 314);
I have posted the question per email a few weeks ago too, sorry for multiposting. It probably ended up in some spam folder…