How do you test the performance of a report?
- 3 Answers
- 8313 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 |
What is Metrics designer?
In which type of report we can create school time table in cognos? [I want period numbers in rows like period 1, Period 2, period 3, period 4, period 5 and class numbers in columns like 8th class, 9th class, 10th class and subject names in cells] Genelally school time table is prepared in crosstab report, but subject names are not measures and a crosstab cell can not contain non-measures. This is my problem,,,,,
what is stitch query in reportnet?
----------------Describe DWH Architecture?
What are the best practices while building a Cognos Framework Manager Package ? As in, what calculations would you not like to be handled in FM and rather get it directly from Database.
What is the difference btw reportnet - Report studio and cognos 8 - Report studio
How many fact tables and dimension tables in your project?
-----------Types of Fact Tables?
6 Answers Bank Of America, CTS,
What do you mean by query studio?
What do you understand by the term 'aggregate cache'?
what r the reports u faced critical and how it can be solved .. any once can u give a best ans for interviw
How can I convert a list report/Cross tab Report in Cognos EP series into a bar chart or pie chart etc.
Teradata 
