3. Differences between Cognos Sql & Native Sql? What are
their Advantages and Disadvantages?
Answers were Sorted based on User's Feedback
Answer / vishal
Cognos Sql: This Sql is genreated by cognos on the behaf of
your query. It is good for your own calculation and for the
performance tunning also.
Native Sql: This is Sql based query which has typical
database format and funcatons. All the caculation done at
database only.
Is This Answer Correct ? | 11 Yes | 0 No |
Answer / krishna
cognos sql:It Can be Excuted on any of the database.it can
understand anyDB.
Native Sql:Sql Depends on Ds(oracle,sqlserver)
performancewise cognos sql is best.it means cognos sql
brings only the required columns.
Is This Answer Correct ? | 10 Yes | 2 No |
what type of charts we create mostly in realtime? plz help
what is physical layer and presentation layer?
can we create master detail report where master and detailed container is separate?
Can you define set to be cardinality?
A product manager is analysing the sales made for each product, he has requested a report containing data for specific products. To do this we will create a report that includes a prompt page that filters on specific products within specific product subcategory and category.
After applying date prompt and when we run the report we fet from date and todate prompts..so when we enter todate<fromdate its an error. How can we generate the user defined error message for this type of error
how to create relationship between emp and salgrade tables in frameworkmanager?
what is cardinality that you can give to employee and department query subjects in framework manager?
what is an associated query?
-----------What is member Description?
What is a Pivot?
Where do you edit cognos sql in report studio?