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 main difference mapplets and mapping?

822


Diff b/w Crossproduct and Outerjoin?

2051


What is zero-foot print?

812


What are the advantages of cognos?

760


What are slice and dice?

724


What are the ways to import data into catalog?

858


Which lifecycle we will use for reporting?

766


Define query studio?

800


write a query to display the departments with no employee?

1782


which type of project we r going to snowflake schema

1781


How to join multiple db in catalog?

777


What do you understand by the term 'aggregate advisor?'

755


What is difference between page break and section report? What is main advantage datawarehousing over oracle?

819


Can you define framework manager?

814


what is the role of cognos comsultant?what actually it means?pls reply

2096