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

what are the filters in framework manager and report studio?

0 Answers   IBM,

---

What is snapshot thumbnail

3 Answers  

---

How to write the necessary TSQL to create data sets, pull the data sets in Cognos Report Studio WITHOUT using framework manager.

2 Answers   Satyam,

---

11. Which is a collection of data defined in Analysis Studio that can be saved and reused in the same analysis? a. Custom set b. Predefined set c. Level based set d. Measure set 12. In a list report in Report Studio there are 3 columns A,B,C and they are grouped by Col A. To show the values of Col A for every value of Col B , which of following steps should be taken? a. Ungroup b. Set Group span to Col A c. Set Group span to Col B 13. Which of following cant be set as a Governer in FM? a. no of tables to b selected in a query b. Left outer joins c. No of Columns to be selected in a query d. Cross Product joins 14. Purpose of analysis studio? a. To provide interactive reporting capability b. All the options c. To generate complex reports d. To help in more trend analysis 15.How to suppress Nulls in Analysis Studio reports? a. Choose the suppression as TOTAL > 0 b. Choose the suppression as TOTAL is NULL c. Choose the suppression as TOTAL is ZERO d. Choose the suppression as TOTAL is not NULL 16.Frame work Manager cant import Metadata from which of folowing? a. Decision Stream b. XML datasource c. Impromptu Catalogs d. Excel Sheets 17. In a report, to perform aggregation using aggregator expression, what should we use? a.Aggregation LIst b.Aggregation type c.Aggregation mode d. None 18. What is the role for gateways? Thanks in Advance

1 Answers  

---

Are you aware of any limitations in Cognos?

1 Answers   HCL,

---

Explain difference between powerplay transformer and power play reports?

0 Answers  

---

Write a SQL query which should fetch the 5th maximum salary of an employee from the table?

14 Answers   HCL,

---

Which service handles requests for cognos connection,query studio and event studio.

2 Answers   TCS,

---

how many types of keys are there i.e primary key and foreign key etc..?

3 Answers   IBM,

---

what is exact catalog size?

4 Answers   IBM,

---

wat is bus schema?

2 Answers  

---

What is use of Field Set present in toolbox?

1 Answers  

---