How can we improve performance in framework manager level?
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
What do you understand by the term 'aggregate advisor?'
Can you explain cognos planning?
what is materialised view? why we use it in data warehousing?
How to add 2 different colors for alternative rows? i.e in a report all rows colors in alternative colors(2 colors)
What is the difference between macros and prompt?
which type of project we r going to snowflake schema
what are all the versions of cognos and cognos8 as well as mention all the advantages nd disadvantages in cognos8 versions. any one plz answer this question.
---------- Purpose of Factless Facttable?
What are initial page components of Cognos connection?
how to access the database directly from cognos reportnet
What is the diff between the following Report output-- HTML O/P, PDF O/P, EXCEL 2000 and EXCEL 2003 of report outputs? Listout main differences?
What is the usage propertys in Framework Manager?n Ie we set EMP ID as a Fact and what will happen?Actullay EMPID is a Identifier....