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
What is model?
What are the components of report net?
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.
Why are meta service important then other services?
What is a Query Subject?
What are the components used in web tier?
hi my name is siraj i want to know cognos queriy language
what is a prompt value in report studio and variables ?
Which lifecycle we will use for reporting?
What is catalog and types of catalogs in cagonos and which is better?
1. Explain your project.
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?
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?
---------------Tell me about DWH Concepts?
How to create model and how to test model?