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

Hi.. friends, dis Bhaskar p.if any of u having realtime scenerios.. plz send to me.. my mailid s bhaskarparitala.rao@gmail.com send ASAP.. waiting for reply..

0 Answers   TCS,


how you create security to cubes ?????

4 Answers   iFlex, iGate,


what r the claims? how many type of claims we face from client side?

1 Answers  


what is the difference between cascading prompt and drill-thru

4 Answers  


what is the meaning of aggregation and rollup aggregation? Difference between layout calculation and query calculation? How do you hide the rows that have null values? why we use query studio? what is the use of query studio compared to report studio?

7 Answers   Cap Gemini, iFlex,






advantages of cascade prompt ???

3 Answers   iFlex,


How can I test reports in cagonos?

0 Answers  


What is Clipboard? How to import XML file into Clipboard?

2 Answers   CSC, HCL,


What are the different ways of adding data in Transformer?

3 Answers   Cognos, IBM,


faq's on cognos

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 is Tool Tip? and how to create in report studio?

1 Answers   Wipro,


Categories