How can we improve performance in framework manager level?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is the difference between list report and crosstab report?

712


How to generate cubes in cognos?

567


Hi all... how can we publish packages using bmp scripts to Path:Public Folder Packages Folder

2310


how can you get the errors in job? when loops are araised we get error?

1654


how can we Upgrad the reports from version Impromptu 6.0 to 7.0 and Power Play from version 6.6 to 7.0 ?

1871






What are the components used in web tier?

539


What are the different types of important services used in cognos?

585


What is Metrics designer?

594


1.WHAT IS XML SPECIFICATION WHAT IS PURPOSE,WHERE YOU ARE GOING TO USE.2 DIFFERENCE BETWEEN RENDER VARIABLE AND CONDITIONAL BLOCK.3.WHAT IS LINK AND SEGMENT.4.WHAT IS CONDITIONAL LAYOUT.5. DIFFERENCE BETWEEN DETAIL FILTER AND SUMMERY FILTER AND HOW YOU ARE GOING DEFINE IN SQL (DETAIL AND SUMMARY FILTER ).. WELL THESE QUESTION I BEEN FACED IN IBM COULD SOMEBODY GET SOLUTIONS PLZ..THANKS IN ADVANCE

1693


Give me any example of semi and non additive measures?

555


What are shortcuts? Where it can be used? What are the advantages?

551


What are the different uses of a repository manager?

603


how u will determine the performence tune will occur either in report or system

1688


How to publish a package by running Java Script?

1602


What is the use of Cognos scenario?

729