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 enterprise class platform architecture of cognos 8?

579


What are the types of hierarchies?

558


Cognos Online Training will be provided. prior training with all real time aspects. Comprehensive training will be given in Datawarehousing concepts , cognos 8.4 and cognos 10 versions. Contact kris.cognos25@gmail.com

1619


hi this is bhaskar iam working in Tcs u want any real time faqs send me your qs i will ans that qs ok this is my id bhaskarparitala.rao@gmail.com

1594


Can you explain cognos planning?

660






i have taken quantity on ANx-axis & months on y-axis(months r not in oreder )when i run the reoprt i need months in proper order .how can i do this ?

1552


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

1868


how the values be passed to prompts in report studio? when a data item is dragged n dropped in to report, after the default query generated first which sql will the query query hit for processing means (native or cognos)? plz answers to these questions?

7974


What are the roles defined by cognos platform?

566


What are the different types of reports present in cognos?

568


Helow, i have a problem with runing-total function when i use it for a calculate row (for example : i need to diplay a running-total of total units ?)

1874


I have two queries in first query i have to show all values,in second query i have to show 3 values and want to hide 3 values what prompt ur going to use, why that prompt

1824


What project,model,parameter maps,namespace and database definitions....... what these are all contains? what are differences b/w them?

1663


7. What is performance tuning?

1568


WHAT ARE THE DISTNICT VARIABLES?

1745