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


Please Help Members By Posting Answers For Below Questions

What is model?

760


What are the components of report net?

977


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.

1970


Why are meta service important then other services?

765


What is a Query Subject?

880


What are the components used in web tier?

744


hi my name is siraj i want to know cognos queriy language

2031


what is a prompt value in report studio and variables ?

2411


Which lifecycle we will use for reporting?

750


What is catalog and types of catalogs in cagonos and which is better?

724


1. Explain your project.

1798


my report ended at the half of the last page but i don't want that matter in the last page I would like to adjust the matter in the previous page .how can i do this?

1823


I have 7500 rows. I need all rows in single reports. Which type of prompt we have used retrieving all rows and show in a report? We have dynamical queries q1, q2, q3, q4, q5. If customer selects the particular, query that only show in execution report. In case it may more then one, how do you execute the particular query item in report page? What are the difference bt OLDP and OLAP?

1872


---------------Tell me about DWH Concepts?

1854


How to create model and how to test model?

803