Cognos 10.2.2 Tips for Development Challenges
Below are some of tips on how Cognos 10.2.2 behaves to resolve issues quickly:- In Native SQL used in RS, it doesn't accept ";" as select terminator. When you copy main report and drill through report together and paste in same folder, drill through link starts using new links drill through report During deployment, if report is imported in different location and copied to target location, it can break report view links. This is changed behavior in Cognos 10 so best practice will be to keep source and target location same during export and import of deployment package. When we use Native SQL in RS, and in source query we apply aggregation functions, report can fail after migration. To circumvent this issue, use native sql based query as source query (without applying any aggregation). Other way is to push query to FM so it becomes virtual source query for further aggregations. When pulling a field in FM, if it is put as Fact, it can't be used for Chart x axis d