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
What is Conditional block? How do you use in a report?
 Question Submitted By :: Vinod
I also faced this Question!!     Rank Answer Posted By  
 
  Re: What is Conditional block? How do you use in a report?
Answer
# 1
Conditional block: Specify a variable based on which 
objects inserted into a 
block can be conditionally rendered.
for example user can have option for List report or chart 
report when he runs the report.
Try this out........
CONDITIONAL BLOCKS
The goal of this report is to prompt users on which display 
they would prefer, a list or a chart.
To start, create a simple list report in Report Studio. 
Using the Cognos sample data, product line, order method 
and revenue are added to the list. From the toolbox, drag 
and place a pie chart below the list. Select the chart and 
in the properties pane, attach this chart to query 1:
 
 
 
 
Now the chart can be populated from the data items tab.
 
 
 
 
The consumers of this report need the ability to choose 
between the displays they want to see. To accomplish this, 
build a blank prompt page allowing them to select from a 
drop down list either list or chart. Drag a value prompt to 
the prompt page with the following settings:
 
 
 
At this point hit ‘Finish”. The dropdown list has to be 
populated manually though the static choices property of 
the value prompt. The two choices added are list and chart.
 
 
 
 
 
*You can leave the display value blank. If you do so, 
Report Studio is smart enough that it will take the use 
value for the display value.
Now that my prompt page is set, return to the Report Page. 
In order to conditionally display an object, use the 
conditional blocks object in the toolbox. Drag this to the 
bottom of the report.
 
 
 
 
The next step is to attach the variable to the conditional 
blocks block variable property. This variable is a Boolean 
variable that either equals a list or doesn’t.
 
 
 
 
 
 
 
 
We need to test if our parameter is equal to the 
value ‘List’. If the user selected List this expression 
will evaluate to true, if the user selected ‘Chart’ from 
the prompt, then this will evaluate to false.
After this step is completed there is a new property on the 
conditional blocks object that tell us which block we are 
currently looking at. First, drag the chart into the ‘No’ 
block.
 
 
 
 
 
Now, select the conditional block again, and switch the 
current block property to ‘Yes’. The conditional blocks 
object appears empty because there is currently nothing in 
the ‘Yes’ block.
 
 
 
The final step is to drag the entire list inside the ‘Yes’ 
block.
 
 
 
Now when the report is run, the user will be prompted for 
their display of choice.
 
Is This Answer Correct ?    0 Yes 0 No
Khushbu
 

 
 
 
Other Cognos Interview Questions
 
  Question Asked @ Answers
 
difference between join and union in reportstudio? IBM1
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 IBM1
How to create users and permissions in cognos?  3
what r the claims? how many type of claims we face from client side?  1
Wt is the Diff between Business Key & member caption?  1
how can create a report like if the salary>50,000 display balance,if salary<50,000 display green? HCL2
Use of Text Source Variable in Report Studio?  2
What are the differences between Cognos ReportNet 1.1, Cognos 8? and enhancements in cognos 8? iFlex1
How can we find out cardinality between two tables? Dominion2
What is TRAP in Framework manager?What's the use of TRAP? Where We are using this? TCS2
using of matric studio we can developed to scorecard ... what is the meaning by scorecords  1
plz anybody help me, how many reports we can create in one project?, and what are the names?in real time project at first what we will do?  1
how can you set the image in the report HSBC1
..Architectural difference between cognos reportnet and cognos8?  2
What are the problems you have faced recently while developing reports in report studio? And how did you solve those problems? This question is asking in many interviews,,,,so pls help me,,,,,  1
What is Normalization?  2
we are in a trail to create a crosstab with rolling months as columns,i mean we have a crosstab with LOB as rows and loan amount as measure,coming to the main problem we have to create dynamically changing column in the columns of the crosstab.The requirement is ...we must have two dynamic columns like feb 08 and feb07.For example if current date is feb 28,we have to get the loan amount from 1st of feb to 27 of feb 2008 as feb08 and loan amount from 1st of feb to 27th of feb 2007 as feb07 columns.Please suggest us the possible way....thanks in advance.... IBM1
How to pass multiple values from picklist prompt to sub report filter? Infosys2
what is dimention?explain dimentable with example? Syntel3
how to Explain a complex report at the time of interview ? please post the answer very urgent? HSBC2
 
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