How can we improve performance in report studio level?



How can we improve performance in report studio level?..

Answer / navneet singh sahni

Run the report in by applying the Query property to Limited
Local Processing, applying the appropriate Filter and
Prompt, not to create complex calulation in single Data
Item.

Is This Answer Correct ?    4 Yes 0 No

Post New Answer

More Cognos Interview Questions

Difference between Express authoring mode and Professional authoring mode?

2 Answers   Wipro,


i have one file i saved in csv how can i take these file into framework manager

0 Answers  


It is possible to give 2 query items has measures in cross tab?for ex:row as products,column as year and measure as revenue,sales year....like that.It is possible r not ?If it's possible pls tel me the process....

2 Answers  


How to hide value prompt box and list when run report?

4 Answers   IBM,


In my Report C-id c-name Revenue are the query items I need to display the report has Alternative colors for rows and Revenue >=1000 has display in another color? i.e Both c-id,c-name are applying the alternative color(red,yellow) condition and revenue (blue) u think..How its possible? Iam doing for alternative colors i defined Two dataitems as running-count and Mod... and next in Boolean varaible define as [Query1].[Data Item2] = 1 or 0 and [Query1].[Revenue]>=1000 as like this (it's correct or not) and define in condition explorer yes and no purpose two colors(here how to define 4 revenue color) By selecting the list columns body style its applying only the Body and run report it working only for alternative colors Next i defined by using same Boolean condition for revenue like this. For selecting only the Revenue Body and define as yes 4 one color and no for another color? But here it the revenue column also applying only the alternative color condition and it's taking the >=1000 condition... So,i need to display 2 columns have alternative colors and 3rd column >=1000 cell have another color any body pls give me the replay/answer in step wise..... Thank u Basha

0 Answers   TCS,






What is the report studio?

0 Answers  


why we r using report studio in webbased only and fm windows based only

1 Answers  


can we insert all types of charts in a list report? what r the realtime prompts?

0 Answers  


I have created a database "TestingDB" in MS SQL Server 2005. I have set the port properties and the Cognos Service is up. But I don't see anything in the Cognos. In the administration i have set the ODBC connection and it tested successfully.If i copy the samples to the appropriate directory then i can see the samples.But I don't know how to do the same thing with my own database "TestingDB". As i have configure the cognos in my company which is having a database (very near to production database).I am a novice in cognos. Please help me out.

0 Answers  


what is the difference between list report and crosstab report?

0 Answers   IBM,


explain project, package ,model , modelers.........and differences b/w them?

4 Answers   HCL,


what are determinants?

4 Answers   College School Exams Tests, IBM,


Categories