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 u please describe the different types of traps with eg. Thanks

2 Answers  


What is the difference between Open Connection command ang Open Session Command?

0 Answers  


please tell me architecture of the cognos8?

4 Answers   IBM, TCS,


----------------------Diff b/w MOLAP and ROLAP?

4 Answers   Bank Of America,


how to add a new dimension in the powerplay transformer.i.e already we have devbeloped one cube. in that we want to add one new dimension cn anybody plese tell me the step by step procedure.

4 Answers  






why u need to publish the package?

5 Answers   IBM,


faq's on cognos

0 Answers  


After generating value prompt,when we run the report... then we will get the prompt in the output.. Along with that prompt we will get diff types of symbols highlited......How can we hide those symbols?

1 Answers   IBM,


Define the slice and dice?

0 Answers  


Explain what is the difference between native sql and cognos sql?

0 Answers  


can anyone provide link to download cognos 7.2 version for download along wiht installation and configuration steps tx in advance

0 Answers  


Explain informatica architecture?

0 Answers  


Categories