1.How can we driil through from a page report having query1
to list report having Query2 in master detail relationship
n Drill through?

2.In database i have 50 records but when it is displayed on
the report i'm getting 100 record with duplictes.How can we
solve this to eliminate duplicates?

3.Exact Diff B/W Filter n Condition?

4.Render Variable?

5.I have leftouter join when right table does not have any
matched records with left table what will be the output of
the report whether it will be dispalying Null or blank in
that particular row?

6.How to test the reports i.e Unit Testing?

7.How canwe drill through when there is no common column
between the parent n child report?

8.How can we do performance tuning?

I kindly request all the experts to give reply with correct
answers and if possible send me some examples regarding
that at srini.madhala@gmail.com



1.How can we driil through from a page report having query1 to list report having Query2 in master..

Answer / soujivadlani

Render Variables are generally created to conditionally
render a particular page or chart or list o block. The
purpose of the render variable is to hide a particular item,
we cant say it used to hide particular item.
When we are using render variable only the queries which
satisfies the parameters will be rendered and hence the
other queries will not be processed in back end by cognos.

Is This Answer Correct ?    3 Yes 0 No

Post New Answer

More Cognos Interview Questions

Can you define slice?

0 Answers  


Hi all, IF any one has Cognos Dump Questions please send it to my mail ID : jaya.purna@gmail.com Cheers Jaya

1 Answers  


difference between drill through and master detail report?

2 Answers   HCL, Zensar,


hi this is bhaskar iam working in Tcs u want any real time faqs send me your qs i will ans that qs ok this is my id bhaskarparitala.rao@gmail.com

0 Answers  


How to create a cube in Transformer? What is the process? Please mention process thank u

0 Answers   Genpact,






is there any possibility to hide items other than render variable?

2 Answers   IBM,


What are the components of the report studio?

0 Answers  


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

0 Answers  


what is sdibling function tell me the some functions

3 Answers   IBM,


3.User1 doveloped some report,user2 modify the same report and user 3 also updates in that same report? how to identify that report will be modified or not?

1 Answers   IBM, Thomson Reuters,


How to connect three fact tables?

11 Answers   L&T, TCS,


what is logs in cognos

1 Answers   HCL,


Categories