3707: Syntax error... between the 'BETWEEN' keyword and ':'. - in Macro/OLAP

Database
N/A

3707: Syntax error... between the 'BETWEEN' keyword and ':'. - in Macro/OLAP

Hi All,

Is it possible to use Macro parameter in an OLAP function?

REPLACE MACRO m1 (sm_limit INT) AS

(

SEL

    d1

    ,SUM(d2) OVER(ORDER BY d1 ROWS

        BETWEEN :sm_limit PRECEDING AND CURRENT ROW) AS sumi

FROM table1;

)

i got error 3707.

We have Version:

    InfoKey    InfoData

    RELEASE    12.00.00.10

    VERSION    12.00.00.10

    LANGUAGE SUPPORT MODE    Standard

Actually this works :(

REPLACE MACRO m1 (sm_limit INT) AS

(

SEL

    d1

    ,SUM(d2) OVER(ORDER BY d1 ROWS

        BETWEEN 10 PRECEDING AND CURRENT ROW) AS sumi

FROM table1;

)

thx!

Üdv:

banan