3. Differences between Cognos Sql & Native Sql? What are
their Advantages and Disadvantages?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you improve the performance of the Cognos Analytics report

532


What do you understand by the cognos?

540


Define datastores in cognos?

554


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 anyone give me the url for cognos forum which is similar to forumtopics.com/busobj for business objects?

1622






What is the difference between drill through, drill across?

573


difference between impromptu and cognos8

1963


How Metrics Studio is better than Report Studio?

2030


What is called Cognos powerplay?

614


2. What functional area you worked on.

1911


-------------How you design DWH?

1890


What is the size of the cube?

533


How can we Maintain the Cube Security by Category level and Dimension level ?

1951


Can we test the report other than manual testing?

1657


What is called a slice?

571