How do you test the performance of a report?
- 3 Answers
- 8069 Views
- TCS, I also Faced
- E-Mail Answers
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 |
how can you create a project creation
What are the different kinds of panes included in cognos?
Hi Experts, Can a single package be shared by multiple users?
i have a table with 3 columns country,empname,salary and i want the query for get the name of the employees who is getting top 2 nd highest salary for individual country? Thanks in advance
Can we create a report in cognos BI without a Package? i.e. without framework manager? If so how? I have been asked this question twice..i think this feature is available in cognos 10 version..not very sure....Could anybody highlight?
What is defined as Cognos Impromptu?
What is Render Variable? where u can use?
How can i approach to write Congnos Certification? What exactly should i do? Can anyone guide me plz?
at what level u prepared the reports in cognos???? in dataware housing what is the automation tool u r using???
1 Answers Covansys, IBM, Wipro,
what is the difference between native sql and cognos sql?
how can you set the image in the report
Hi,please suggest me how to creat username while creating a report.
Teradata 
