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
Cognos Online Training will be provided. prior training with all real time aspects. Comprehensive training will be given in Datawarehousing concepts , cognos 8.4 and cognos 10 versions. Contact kris.cognos25@gmail.com
what are the components in the cognos connection page consists (eg: my folder, public folder,directions, schedule management tool etc.....)
Define query items?
What is called cognos reporting tool?
What is model?
What is the difference between group and associare?
What are the components used in web tier?
Which studio is used to create reports?
How Metrics Studio is better than Report Studio?
A product manager is analysing the sales made for each product, he has requested a report containing data for specific products. To do this we will create a report that includes a prompt page that filters on specific products within specific product subcategory and category.
what is power prompt in cognos ep7series?what is the use of this?
What do you mean by drill through report?
Explain the difference between native sql and cognos sql?
What is defined as Query studio?
Define the cognos reporting tool?