how to improve performance in report studio level



how to improve performance in report studio level..

Answer / poorna chandra reddy

Set processing property to limited local and local cache to
yes at query level in RS

Is This Answer Correct ?    6 Yes 0 No

Post New Answer

More Cognos Interview Questions

what is the meaning of drill down and drill up in COGNOS 8BI

3 Answers  


11. Which is a collection of data defined in Analysis Studio that can be saved and reused in the same analysis? a. Custom set b. Predefined set c. Level based set d. Measure set 12. In a list report in Report Studio there are 3 columns A,B,C and they are grouped by Col A. To show the values of Col A for every value of Col B , which of following steps should be taken? a. Ungroup b. Set Group span to Col A c. Set Group span to Col B 13. Which of following cant be set as a Governer in FM? a. no of tables to b selected in a query b. Left outer joins c. No of Columns to be selected in a query d. Cross Product joins 14. Purpose of analysis studio? a. To provide interactive reporting capability b. All the options c. To generate complex reports d. To help in more trend analysis 15.How to suppress Nulls in Analysis Studio reports? a. Choose the suppression as TOTAL > 0 b. Choose the suppression as TOTAL is NULL c. Choose the suppression as TOTAL is ZERO d. Choose the suppression as TOTAL is not NULL 16.Frame work Manager cant import Metadata from which of folowing? a. Decision Stream b. XML datasource c. Impromptu Catalogs d. Excel Sheets 17. In a report, to perform aggregation using aggregator expression, what should we use? a.Aggregation LIst b.Aggregation type c.Aggregation mode d. None 18. What is the role for gateways? Thanks in Advance

1 Answers  


what are the tabs in cognos ?

2 Answers  


What are the different type of securities can we apply in framework manager?

1 Answers  


diff b/w dimension and regular dimension

1 Answers  






Suppose you run a report with empty data, how will you inform the end user that it has no data while running the report in report studio? Is it possible, if so how?

0 Answers  


hai frndz....... in a product name QUERY ITEM column we have some products like..soap, mobile, laptop, nd so on..... when i report run for the US client with the product name,, langauge is requird only ENGLISH.... IF client as a chaina .or, japan .or, spanish.. they want to run report using by product name QUERY ITEM as thier region language like chaina/japan/spanish... how to i convert product name column as default as english, to chaina/japan/spanish..........in the framework manager/ cognos connction Could u pls give me problm solution.....thnx in advnce........

1 Answers   TCS,


How can create users and permissions in cognos?

0 Answers  


What are differences between Reporter report and Explorer report?

2 Answers  


What are the different kinds of panes included in cognos?

0 Answers  


if report performance is low how can check 3 areas in framework manager?.what are the 3 areas concentrate?

3 Answers   CTS, TCS,


These are the questions asking in many interviews, so pls help me,,, How did you get requirements from the client? How did you send reports to the client? How did you interact with your client? I mean through e- mail or phone or in any other way?

6 Answers   IBM, Logica CMG,


Categories