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

APPLYING COLORS TO ALTERNATE ROWS IN A LIST REPORT

5 Answers   Satyam,


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 is the difference between cognos 8.2 and cognos 8.3?

5 Answers  


how you migrate reports to cognos 8 from previous versions?

0 Answers   IBM,


----------0Diff b/w Report Functions and Database functions?

1 Answers   IBM,






Please answer me the below questions, It's really urgent, and ur help would be appreciated. 1. What is looping in FM? How do u control it 2. How do u create IQDs in FM? Explain 3. What are the diff u noticed between Cognos 8.2 and Cognos 8.4 4. Can we use cube as a data source? How 5. How do u connect ur database in FM? do u connect directly 6. What's the structure of your database? Say u use Oracle 7. Did you use tables or views to bring the data from your DB 8. Does the dimensions of analysis studio have hierarchy? 9. Did you create any dashboards? How u created, explain

0 Answers  


data import to models, datastores,stored processed, is there any other way to import data?

1 Answers   TCS,


What do you mean by Drill down and Drill Up?

0 Answers  


We can use a calculated field to dynamically create the burst recipients in Cognos 8. Can we do the same in Cognos ReportNet 1.1?

0 Answers  


what is cardinality that you can give to employee and department query subjects in framework manager?

2 Answers   HCL,


How to Improve the Performance of the Report? i need this urgently .

4 Answers   HSBC,


Write types of folders present in cognos?

0 Answers  


Categories