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

what is an associated query?

2 Answers  


What is meant by junk dimension?

0 Answers  


Diff b/w surrogate Key and Primary Key?

2 Answers   Cap Gemini,


first of all i want say thanks to Zilanibasha, As u said that now these days Cirtification in cognos8 is only possible. Will u like to tell me in detail How i apply for cirtification As i m very much Interested.

1 Answers  


How many fact tables and dimension tables in your project?

3 Answers   IBM,






What is Render Variable? where u can use?

3 Answers  


Can you define a query subject?

0 Answers  


How to test reports in cagonos ?

10 Answers   CST, CTS,


what are ERP systems?

1 Answers  


Can you define folder?

0 Answers  


What is called materialized view?

0 Answers  


tell me two or three issues from client side and how to solve those issues?

0 Answers   TCS,


Categories