How do you test the performance of a report?
Answers were Sorted based on User's Feedback
Answer / cognosvij
generally we test the performance by following way.....
in cognos report studio we get the cognos generated Query
copy that query and run it in your Database
and run the same in report studio and compare the time ....
thanks,
vij:)
| Is This Answer Correct ? | 6 Yes | 2 No |
Answer / sambamalla
write the query in wt u have data base,
that result compare the report.
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / naga sudha
First
Run the report with Excel as Run option and take that data
in the first page of the Excelsheet.
Second.
Generate the sql of the report for the same parameters to
be filtered in the report and execute that sql against the
database environment....Point to be noted both should be
Dev or Test or Prod...Then take that data into the second
sheet of the excel,
Then Apply Condition Format of the Two excelsheets like
SHeet1 1*1=Sheet2 2*1 Then Green Else some Red.
Then u can able to Find the presentation of the data with
respect to the report and against the database in the
excel sheet.
Regards,
Sudha
| Is This Answer Correct ? | 0 Yes | 5 No |
Hi Guro's How to give give one space for every 5 rows in a crosstab report in cognos
what is prompt variable
what is mean by cognos powerhouse?
What r the names of the reports that you prepared?
What is difference between content store and content manager?
how can you set the image in the report
What is Crossproduct?
how you burst the reports? If you are bursted reports is not reached to destination how you identify?when you import data into catalog you have complex columns names.how do you change the name of those columns?
what is the use of macros&folders&herarchies in frameworkmanger?
What is model filter?
How do we implement Check Box Prompt in COgnos Report Studio?
A product manager is analysing the sales made for each product, he has requested a report containing data for specific products. To do this we will create a report that includes a prompt page that filters on specific products within specific product subcategory and category.