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
Define the cognos reporting tool?
How to do Performence Tunning in Cognos Reports?
what are the dimensions that you have in your current project?list them?
What is the difference between drill through, drill across?
After applying date prompt and when we run the report we
fet from date and todate prompts..so when we enter
todate explain how to create powerplay reports? How create measures and dimensions? How to apply securities for reports in cognos connection? What is Bitmap Index? What is the use of report studio? what is the difference between querystudio in reportnet and
cognos8 What is defined as Query studio? what are the features in cognos8ui I have 7500 rows. I need all rows in single reports. Which
type of prompt we have used retrieving all rows and show in
a report?
We have dynamical queries q1, q2, q3, q4, q5. If customer
selects the particular, query that only show in execution
report. In case it may more then one, how do you execute the
particular query item in report page?
What are the difference bt OLDP and OLAP?
Actually we have 500 users when they run the report display
the flage image related country user? How its possible?