How can we improve performance in framework manager level?

Answers were Sorted based on User's Feedback



How can we improve performance in framework manager level?..

Answer / mahesh.g.s

Make sure that Data is imported from only 1 data source
with out any duplicate data sources created .Duplicate DS
will get created when you import New query subject from the
Database or Refresh the existing Query subject with the
name as 1 appended to the existing DS.

Make sure there are only few CASE statements,DECODE
statements where ever required.These hampers performance.

Make sure there are no loops between query subjects.

Is This Answer Correct ?    7 Yes 1 No

How can we improve performance in framework manager level?..

Answer / arkchowdary

BY Checking the Governer Settings we can improve the
Performance.

We have many Governer Options.

Based on Situation we will use.

Is This Answer Correct ?    4 Yes 0 No

How can we improve performance in framework manager level?..

Answer / suresh

by checking the governor settings i.e by setting table
retrieving limits,by setting number of rows retrievsal
limits etc....As my knowledge i give this answer.if any
further more reply.

Is This Answer Correct ?    2 Yes 2 No

Post New Answer

More Cognos Interview Questions

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

0 Answers   IBM,


what are the enhancements in cognos reportnet ?

9 Answers   IBM, TCS,


can reportnet supports cubes???

4 Answers   IBM, Wipro,


How to configure the Cognos configurations to work in the Windows 2000 Server machine?

1 Answers   IBM, Infosys,


Suppose you run a report with empty data, how will you inform the end user that it has no data while running the report in report studio? Is it possible, if so how?

0 Answers  


What are the different kinds of panes included in cognos?

0 Answers  


1. Explain your project.

0 Answers   IBM,


we have a list of 80,000 records, i would like to display in excel sheet but excel sheet has capacity of 60000 record.. how you going to display?

2 Answers   Accenture,


Can you define materialized view?

0 Answers  


How can we give the same color for alternate(1,3,5.... and 2,4,8...) cells in a column?

5 Answers   CTS,


what are all the versions of cognos and cognos8 as well as mention all the advantages nd disadvantages in cognos8 versions. any one plz answer this question.

0 Answers   Magna Infotech,


which type of project we r going to snowflake schema

0 Answers   IBM,


Categories