how will optimiz the performance of sql in FM ?

Answer Posted / chaitanya

using the governor setting, enabling the allow usage of
local cache we can increase the performance.

Is This Answer Correct ?    7 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is set to be cardinality?

636


How Metrics Studio is better than Report Studio?

2030


What is metric store database?

565


How can we Maintain the Cube Security by Category level and Dimension level ?

1953


what are the errors faced while bursting the reports and how to solve those errors?

1565






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?

2082


Can you define pivot?

541


What is cognos reporting tool?

611


Define olap designer?

703


-----------With out using DrillThrough how to do Reports?

1601


how to connect datamarts

2372


4. How many dimensions did you use in your reports?

1489


What is the use of cognos decision stream?

660


How to test a cube?

1675


What are the types of studio?

680