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

Name the types of gateway?

601


What are shortcuts? Where it can be used? What are the advantages?

555


What is the difference between static and dynamic conditions?

601


After applying date prompt and when we run the report we fet from date and todate prompts..so when we enter todate

1602


What is called materialized view?

597






What do you understand by ‘ibm predictive maintenance and quality’?

565


What are the components of report net?

734


What you mean by drill across and what is the difference between drill through, drill across?

551


Can you define cognos decision stream?

603


what is log in cognos?

664


How is possible this scenario using in type-in prompt.?

595


What is defined as catalog and types of catalogs in Cognos?

571


What is a Datastore in Cognos?

801


what are the dimensions that you have in your current project?list them?

1637


What is the difference between the content store and content manager?

572