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 is the difference between Cognos EP7 series and Congos8?
In an existiing Framework model, how will you add a new column to the existing table?
3. Differences between Cognos Sql & Native Sql? What are their Advantages and Disadvantages?
what is #prompt and #promptmany, runningtotal in report studio
How to pass parameter value into html design page? (That is YOU Create a html page and use that page in your cognos 8 report header.take <html item> my question is how to use parameter value in the html page .)
Can you please tell me the limitation of Excel file when exporting from report to Excel? I can export to HTML and PDF but I can't export to Excel. The report is more than 13000 rows. When exporting to Excel, system can view it. After that, I save the report to an Excel file. The size of Excel file is more than 11 MB. But I can't view this file by Excel. Please help me to solve this problem. Thanks!
what is repeater table and repeater where to use these? can any one explain with senario greatly helpfull
Can you explain dynamic query mode?
suppose i want to do drill through a column only for the values which is having more than > 50000. how can i do that?
What are the Macros?
What are the types of hierarchies?
Hi, I am Searching on Cognos 8, If any experienced person can send out a project or explain a realtime scenario that would be very helpful for me. Please be kind towards me and help me in this regard. I am really finding difficult to find a person who can guide me in this feild. Your help will be highly appriciated. My email id is balajishriram@gmail.com. Hope you will help....