Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Framework Manager => Topic started by: sukanya on 19 Aug 2018 10:05:30 PM

Title: oracle rownum in cognos FM not working
Post by: sukanya on 19 Aug 2018 10:05:30 PM
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,
Title: Re: oracle rownum in cognos FM not working
Post by: sukanya on 21 Aug 2018 09:25:09 AM
we decided to move the datasource query to database instead of FM.

Thanks,
Title: Re: oracle rownum in cognos FM not working
Post by: the6campbells on 03 Sep 2018 10:05:32 AM
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.



Text only | Text with Images