Answer Posted / 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 |
Post New Answer View All Answers
What do you understand by the term 'aggregate cache'?
what is the diff. between a link n a union? what is a custom view? what is the use of unlocking a report ? plz answer to these
What is metric store database?
Diff b/w Crossproduct and Outerjoin?
What is the difference between a cascading report and drill through the report?
What is Bitmap Index?
What DB View and Bus View?
What is the difference between a data mart and a data warehouse?
what are the special features in cognos reportnet?
What do you mean by Drill down and Drill Up?
What is the advantage of using shortcuts?
All ready we have alias tables for modifications why we are using views if anybody this answer plz reply me
Is it possible to join multiple Databases in a Catalog?
What is defined as catalog and types of catalogs in Cognos?
Define datastores in cognos?