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
Name the types of gateway?
What are shortcuts? Where it can be used? What are the advantages?
What is the difference between static and dynamic conditions?
After applying date prompt and when we run the report we
fet from date and todate prompts..so when we enter
todate What is called materialized view? What do you understand by ‘ibm predictive maintenance and quality’? What are the components of report net? What you mean by drill across and what is the difference between drill through, drill across? Can you define cognos decision stream? what is log in cognos? How is possible this scenario using in type-in prompt.? What is defined as catalog and types of catalogs in Cognos? What is a Datastore in Cognos? what are the dimensions that you have in your current
project?list them? What is the difference between the content store and content manager?