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 |
what is logs in cognos
Why need staging area database for dwh?
can anybody send me interview questions with answers on IBM cognos-FM and Report studio. My mail ID is: cskcognos@gmail.com
what was the actual purpose of portfolio in cognos ?
How can we Maintain the Cube Security by Category level and Dimension level ?
how to hide a particular pages at time if you get blank pages
how many facts and dimensions in ur project and query items,how u deliver ur report to end users..i am going with fake exp...pls ans me generally what to ans..
what is report burn and where it occurs
How do you use SUM function in Reportnet?
what is alias what is shortcut what ia alias shortcut and diff among them if u know explain clearly
can anybody tell me when do use 'running total'...give an example for the usage of running total
Hi,Can anyone tell me training centre for cognos in Mumbai?