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

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to join multiple db in catalog?

577


How is cognos model organization works?

600


can anyone provide link to download cognos 7.2 version for download along wiht installation and configuration steps tx in advance

1876


how many numbers of cubes can we create on a single model? How can we navigate between those cubes?

596


What is defined as data mining?

605






What do you understand by the term 'aggregate advisor?'

539


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?

1664


What is the function of model design accelerator?

539


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

671


What do you mean by drill across?

582


It is possible to test 2 query subjects at a time in CRN1.1 & C8 FWM?

1957


Can you define fan trap?

758


When we save a report in report studio with what extn it save?

659


I have ten columns that needs to be totalled... but some columns are empty...how do i get sum all the columns even if sum are empty? Can i get a total of the rows instead of columns? if yes, what is the function to be used?

1537


What is the use of Cognos scenario?

735