SQL Window Functions

[dougp]

Using Cognos 11.0.13 with a relational model...

Is it possible to use SQL window functions (like LEAD, LAG, etc.) without using SQL objects using Native or Pass-thru SQL syntax?

I see some SQL window functions are possible.  For example:

Code Select Expand

total([Sales (query)].[Sales].[Quantity] for [Sales (query)].[Branch].[Country], [Sales (query)].[Branch].[Province or state], [Sales (query)].[Branch].[City])

...produces...

Code Select Expand

    SUM("SQ0_Query1"."Quantity")
        OVER(
            PARTITION BY
                "SQ0_Query1"."Country",
                "SQ0_Query1"."Province_or_state",
                "SQ0_Query1"."City"
        ) AS "Quantity1"

...but I can't see how to use LEAD and LAG.

Alternatively, is there a way to configure a data item expression (not the whole query) as pass-thru?