oracle rownum in cognos FM not working

[sukanya]

Hi,

rownum in where clause is not working in cognos FM. Its throwing error function The column is not found in the model. please suggest an altenate way to use in this cognos datasource query subject.

Regards,

[sukanya]

we decided to move the datasource query to database instead of FM.

Thanks,

[the6campbells]

The SQL standard expression to compute a row number is ROW_NUMBER ().

Cognos BI/Analytics provides built-in functions to compute the row number and ranked value etc which you can use in a predicate (filter) etc.

Those concepts are pushed down to vendors such as ORACLE whose SQL grammar supports them.

ROWNUM is an ORACLE keyword and not a function.