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 is the difference between filter and condition?
what is the difference between group span and level span
How can you improve performance in report studio level? What is the difference between Cognos sql and Native sql? How can you create cubes in framework manager?
7 Answers Genpact, iFlex, TCS,
How can I disable the drill-down for the last level of my dimensional hierarchy ????
hi frnds any body have cognos projects plz send me two(or)three projects to my mail adress ramureddy.reddy4@gmail.com.
fiscal year means what???
what is a query subjects item?
1)diff between shortcut-key and alias table? 2)what is unit testing? 3)what is scorecard?
Hi, I Want To Display The Report. From MOnday To Friday By Using Date Prompt.PLs Expain To Me...
----------------------Diff b/w MOLAP and ROLAP?
What do you understand by the term 'aggregate cache'?
What is model filter?