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 |
Hi.. friends, dis Bhaskar p.if any of u having realtime scenerios.. plz send to me.. my mailid s bhaskarparitala.rao@gmail.com send ASAP.. waiting for reply..
how you create security to cubes ?????
what r the claims? how many type of claims we face from client side?
what is the difference between cascading prompt and drill-thru
what is the meaning of aggregation and rollup aggregation? Difference between layout calculation and query calculation? How do you hide the rows that have null values? why we use query studio? what is the use of query studio compared to report studio?
advantages of cascade prompt ???
How can I test reports in cagonos?
What is Clipboard? How to import XML file into Clipboard?
What are the different ways of adding data in Transformer?
faq's on cognos
How can we give the same color for alternate(1,3,5.... and 2,4,8...) cells in a column?
What is Tool Tip? and how to create in report studio?