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


Please Help Members By Posting Answers For Below Questions

Define the cognos reporting tool?

542


How to do Performence Tunning in Cognos Reports?

2066


what are the dimensions that you have in your current project?list them?

1628


What is the difference between drill through, drill across?

570


After applying date prompt and when we run the report we fet from date and todate prompts..so when we enter todate

1592






explain how to create powerplay reports?

604


How create measures and dimensions?

597


How to apply securities for reports in cognos connection?

2108


What is Bitmap Index?

604


What is the use of report studio?

596


what is the difference between querystudio in reportnet and cognos8

1728


What is defined as Query studio?

604


what are the features in cognos8ui

1552


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?

1677


Actually we have 500 users when they run the report display the flage image related country user? How its possible?

1565