For some special report feature I want to use ROWNUM in a Query subject. On testing the Query Subject I got the next error:
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
2. Select Options
3. Choose on the SQL Settings tab for Native instead of Cognos
4. Click OK and after that hit the Test tab to see it work
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
How to recover a corrupted or lost Framework Manager model:
Cognos 8 and 10: http://www-01.ibm.com/support/docview.wss?uid=swg21505488
Cognos ReportNet: http://www-01.ibm.com/support/docview.wss?uid=swg21344664
1. Create a xml file with the following content: Continue reading
On the internet there is al lot of discussion and examples of how to setup a Framework Manager Project.
From my experience and also mentioned a lot on forums the best way is a three layer design.
1: Database Layer
2: Business Layer
3: Dimensional Layer Continue reading
When you open Framework Manager (FM) you will see a most 4 projects that you recently opened. When you work on multiple projectfiles you wish to see more.
The number of visible projects is stored in the bmt.ini file in the cognos installation. Continue reading