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:)

Answer / sambamalla

write the query in wt u have data base,
that result compare the report.

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

Explain about scorecarding?

0 Answers  

---

what are determinants?

4 Answers   Dominion,

---

How do you test the performance of a report?

3 Answers   TCS,

---

What are shortcuts? Where it can be used? What are the advantages?

0 Answers  

---

What are the advantages and disadvantages of using Transformer cube?

1 Answers   TCS,

---

What is Dynamic Grouping? what is diff between grouping n levelspan?

2 Answers   CybAge,

---

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

4 Answers   HCL,

---

Define dimensions?

0 Answers  

---

Explain difference between powerplay transformer and power play reports?

0 Answers  

---

How to limit the cut,copy and paste operations for an user in reportlevel? Can anyone please send me the steps as i am new to cognos?

0 Answers   Accenture,

---

how many facts&dimensions tables in project? it's very urgent.........

2 Answers  

---

write a query to display the third record from the employee table?

4 Answers   HCL,

---