Can we create a report in cognos BI without a Package? i.e.
without framework manager? If so how? I have been asked this
question twice..i think this feature is available in cognos
10 version..not very sure....Could anybody highlight?
Answer Posted / rahul
Yes, we can create report without using FM Package.
Use SQL override -Go to Query Explorer -On left Topside -SQL override-Drag it and go to properties (Bottom Left) -select the source and set Native SQL/Passthrough SQL (Dont use IBM Cognos Sql).
SQL Override is not prefered method( we are missing minimised SQL concept).
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
what is a prompt value in report studio and variables ?
Define catalog in cognos and write its various types?
what is requery in cognos?
What are the main services provided by application tier?
how many notations are posible(cordinolity)are there in between two tables(one is fact and another is dimension)pls give me a example pls.
How to a create header dynamically in a crosstab report in cognos 8.1?
please please give me some banking calculations in framework manager.
What is the advantage of using shortcuts?
Can you define materialized view?
how to test reports in cognos?
1. We have been asked to add summary information to sales reprasentatives performance report. The report needs to be grouped by country and city to compare performance between areas Also we need to include revenue totals for each city and each country.
what is the difference between querystudio in reportnet and cognos8
What are the services provided in cognos 8?
what is the difference between list report and crosstab report?
how many numbers of cubes can we create on a single model? How can we navigate between those cubes?