ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip   SiteMap shows list of All Categories in this site.
Google
 
Categories  >>  Software  >>  Data Warehouse  >>  Cognos
 
 


 

 
 Teradata interview questions  Teradata Interview Questions
 Business Objects interview questions  Business Objects Interview Questions
 Cognos interview questions  Cognos Interview Questions
 Informatica interview questions  Informatica Interview Questions
 Crystal Enterprise Suite interview questions  Crystal Enterprise Suite Interview Questions
 Actuate interview questions  Actuate Interview Questions
 Ab Initio interview questions  Ab Initio Interview Questions
 Data Stage interview questions  Data Stage Interview Questions
 SAS interview questions  SAS Interview Questions
 Micro Strategy interview questions  Micro Strategy Interview Questions
 ETL interview questions  ETL Interview Questions
 Data Warehouse General interview questions  Data Warehouse General Interview Questions
Question
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
 Question Submitted By :: Srinivas
I also faced this Question!!     Rank Answer Posted By  
 
  Re: 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
Answer
# 1
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 ?    2 Yes 0 No
Soujivadlani
 

 
 
 
Other Cognos Interview Questions
 
  Question Asked @ Answers
 
what is prompt types of prompt example briefly each types of product (eg:values, date,search,prompt etc.) Syntel1
what are the limitations of cognos reportnet? Nestle9
what is the automation tool used for data warehouse testing??? Covansys2
1.how do nyou configure link between fwm and database (source).if you created fwm where it will be? and if you create reports where it is stored? 2.what is spic shot in fwm? CTS1
write a query to display to 10 max record from the employee table? HCL3
16. How can we create top 10 and bottom 10 records in the same list? TCS2
what is cube size?  2
Difference betwween cognos report net architecture and cognos8 architecture  3
How much time it will take to develop a report in real time? It depends upon the complexity of the report, so tell me the approximate time period for a simple list, cascading, master-detail, drill-through,..…etc?  2
What are the procedures (or) methods using in Migration process in cognos? I.e. the created report is in development server that moves into production server (client server). Shall we drag or copy the file moving from development to production? It is possible or could you tell me that how will we do it?  1
write a query to display the third record from the employee table? HCL2
What's the differance between each studio in cognos 8? TCS1
how can create a report like if the salary>50,000 display balance,if salary<50,000 display green? HCL2
I have four region(Us, Uk, Canada, Europe) in my value prompt. Along with this I want new prompt called All. Once I click on All it should display all regions data. How can I achieve this ?  2
can any body clesrly explain about types of query subjects.that is data source query subject,model query subject,stored procedure query subjects?  1
how data modeling is usefull to cognos?  1
How you create IQD In ReportNet FrameWork?  3
What is the use of Generated Prompt? Where is it used in realtime project?  1
What is meant by Tabular SQL in Cognos Report net Infosys2
what is the use of layout calculation?  3
 
For more Cognos Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com