lead and lag

[dougp]

Cognos Analytics includes many windowing aggregation functions - minimum (MIN), maximum (MAX), total (SUM), etc.  Have Lead and Lag been included yet?  I'm using 11.2.4 and still not finding these.

[cognostechie]

You can write your own SQL and use Lead ( <column name> ,1,0 ) over ( order by <column name> ) ;)

[dougp]

I know.  But I was hoping to avoid custom, raw SQL.