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
How to join multiple db in catalog?
How is cognos model organization works?
can anyone provide link to download cognos 7.2 version for download along wiht installation and configuration steps tx in advance
how many numbers of cubes can we create on a single model? How can we navigate between those cubes?
What is defined as data mining?
What do you understand by the term 'aggregate advisor?'
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?
What is the function of model design accelerator?
What is looping and how to avoid it in framework manager?
What do you mean by drill across?
It is possible to test 2 query subjects at a time in CRN1.1 & C8 FWM?
Can you define fan trap?
When we save a report in report studio with what extn it save?
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?
What is the use of Cognos scenario?