Use Oracle’s Rownum in Framework Manager

For some special report feature I want to use ROWNUM in a Query subject. On testing the Query Subject I got the next error:

fmrownum1

This is caused by the fact that Cognos SQL is used and ROWNUM is a Oracle hidden column in the database.

Follow the next steps to solve this issue:

1. Go to the Query Information tab for the Query Subject

fmrownum2

 

2. Select Options

fmrownum3

 

3. Choose on the SQL Settings tab for Native instead of Cognos

fmrownum4

 

4. Click OK and after that hit the Test tab to see it work

UDA-SQL-0227

On adding some field in the report and ruuning it I got the following error: UDA-SQL-0227 Equivalence types are incompatible.

This error is caused by a difference in datatypes in Framework Manager in a join between to objects.

In my case I created a relation on an ID between a fact and dimension. In the fact the ID is of type “Character Length 16”.

In the dimension the ID is of type “Float64”

This is caused by the difference in datatypes in the database.

So I solved this by putting a TO_NUMBER on both ID’s