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

How to use Cascade Macro in Report studio? Anybody know about Cascade Macro & and the procedure to use?

1 Answers   AIG, Niteo,


Is it possible to join multiple Databases in a Catalog?

0 Answers  


how to add a new query item by using 2 query subject? For Ex: i want to create a revenue query item in products query subject(revenue=Quantity*Unitprice). Quantity is in products query subject & unit price in orders query subject it will be possible in report studio(perment/temporerally) otherwise u have create in Freamework Manager... pls any body knows explain /answer me ?

4 Answers  


Hi..I have COG-112(Report Author),COG-122(Admin),COG-132(Meta data modelling). I took test end of Sep '09.I got 100% wcore with these dumps. If any body need then mail me on kris.bi121@gmail.com

2 Answers  


What is main difference mapplets and mapping?

0 Answers  






How to select multiple values from type-in prompt?

0 Answers  


How do you deployment reports from one server (Development) to other server(Production)? How do you configure the cognos7.0 version cube in cognos 8.0? Pls, explain with example? How do you create IQD without IMR or can u explain other way create IQD?

2 Answers   TCS,


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?

0 Answers  


what is Associated grouping? and how it works in cognos impromptu?

1 Answers   IBM,


Why cognos decision stream is used?

0 Answers  


What is difference between content store and content manager?

0 Answers  


how u create cubes in ur project

2 Answers   IBM,


Categories