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
Can you define a query subject?
-----------Diff b/w OLAP and RDBMS?
What is difference between content store and content manager?
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?
can you tell me what are the dimension tables are used in project
How the Bursting happens in same report and how to Print the bursting Report?
-----------With out using DrillThrough how to do Reports?
What is a Framework manager?
What are the types of studio?
What are all the advantages of Cognos?
how to connect datamarts
What condition do we use in Cognos when multiple path exits to reach the fact table.(i.e in BOXI we use CONTEXT when multiple path exit)
How to a create header dynamically in a crosstab report in cognos 8.1?
Can you explain dynamic query mode?
Can you define snapshot?