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 'dynamic cube'?
What are the considerations regarding performance kept in mind while setting up cognos?
is cognos 7 is better than cognos 8
All ready we have alias tables for modifications why we are using views if anybody this answer plz reply me
What is Online View?
what is the role of cognos comsultant?what actually it means?pls reply
How can we Maintain the Cube Security by Category level and Dimension level ?
I have created a database "TestingDB" in MS SQL Server 2005. I have set the port properties and the Cognos Service is up. But I don't see anything in the Cognos. In the administration i have set the ODBC connection and it tested successfully.If i copy the samples to the appropriate directory then i can see the samples.But I don't know how to do the same thing with my own database "TestingDB". As i have configure the cognos in my company which is having a database (very near to production database).I am a novice in cognos. Please help me out.
what do u mean by bridge group? where we r using this one?
Define metrics studio?
what are slowly changing dimensions? Why we are used scd?
What you mean by drill across and what is the difference between drill through, drill across?
Write various indexes used in cognos?
what is the difference between filter and condition?
----------------Diff b/w Dimensional modeling and Relational modeling?
