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

Can we create 2 conditions in report expression of a single data item..Eg: I added 2 new dataitems each one should show revenue for Q1 and Q2..Pls advice

2138


Can you define slice?

623


hi this is bhaskar iam working in Tcs u want any real time faqs send me your qs i will ans that qs ok this is my id bhaskarparitala.rao@gmail.com

1596


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

569


what are slowly changing dimensions? Why we are used scd?

619






what are the difficult problem are you involved in cognos report net and 8 and impromptu if any pls share with us

2548


What is called cognos reporting tool?

598


Cleared COG-112 with 100% score today. What next certification should i go for?

1416


Hi all... how can we publish packages using bmp scripts to Path:Public Folder Packages Folder

2310


how u burst the reports? if u r bursted reports is not reached to destination how u identify???

10745


What are the advantages of cognos?

574


what are the features in cognos8ui

1565


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

551


What is looping and how to avoid it in framework manager?

663


what is the difference between querystudio in reportnet and cognos8

1735