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?
Answer Posted / ushasree
report studio performance depends on net work spead,
complex calculations,using not in operator,outterjoin.
Cognos SQL and Native SQL are two different types of SQL
generated by cognos tool. Native SQL is sub set or same as
Cognos SQL.
Native SQL contains only the functionality that got
executed at database end, apart from this Cognos SQL will
have the Locally processed logic as well.
we can create package using cube.Cube is a data source here.
| Is This Answer Correct ? | 15 Yes | 10 No |
Post New Answer View All Answers
how you provide security to reports? How you provide security to packages ?
faq's on cognos
How to generate cubes in cognos?
Explain the difference between native sql and cognos sql?
Can you define cognos impromptu?
What is catalog and types of catalogs in cagonos and which is better?
Define datastores in cognos?
What is a Query Subject?
What is the use of Cognos scenario?
-----------Diff b/w OLAP and RDBMS?
What is difference between page break and section report? What is main advantage datawarehousing over oracle?
--------------Explain Table of contents?
How to join multiple db in catalog?
can anyone let me know some tips or interview questions on framework manager metadata modeling, creating joins, and all other aspects related to Cognos 8 framework mgr
How create measures and dimensions?