:: Home Page            
 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                      
Categories >> Software >> Data Warehouse >> Cognos


 Teradata interview questions  Teradata Interview Questions (183)
 Business Objects interview questions  Business Objects Interview Questions (756)
 Cognos interview questions  Cognos Interview Questions (848)
 Informatica interview questions  Informatica Interview Questions (1623)
 Crystal Enterprise Suite interview questions  Crystal Enterprise Suite Interview Questions (29)
 Actuate interview questions  Actuate Interview Questions (35)
 Ab Initio interview questions  Ab Initio Interview Questions (172)
 Data Stage interview questions  Data Stage Interview Questions (564)
 SAS interview questions  SAS Interview Questions (556)
 Micro Strategy interview questions  Micro Strategy Interview Questions (36)
 ETL interview questions  ETL Interview Questions (195)
 Data Warehouse General interview questions  Data Warehouse General Interview Questions (216)
What is Conditional block? How do you use in a report?
 Question Submitted By :: Cognos
I also faced this Question!!     Answer Posted By  
# 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........
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’

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’

Now when the report is run, the user will be prompted for
their display of choice.
Is This Answer Correct ?    19 Yes 0 No

Other Cognos Interview Questions
  Question Asked @ Answers
difference between imprompt and reportnwt1.1 HSBC 2
2.How do you drill through report from Report Studio to Analysis studio? IBM 2
Can we create reports using OLTP database?How?   3
What is Lookup ,bridgeing tables where they will use in the Dataware house IBM 2
What is Cognos Powerhouse and what is it used for? M-Care 2
What is meant by report studio short cut?   2
If anyone has COG-185 IBM Cognos 8 Migration Professional Certification Dump, please mail me at: EDS 1
Can any one tell me cognos training class in chennai? thanks in advance...   4
What is meant by Tabular SQL in Cognos Report net Infosys 3
What is Conditional block? How do you use in a report? IBM 1
write a query to display the third record from the employee table? HCL 4
Why we take so long time to display date prompt before displaying a report? How can we reduce the time?   2
For more Cognos Interview Questions Click Here 

Copyright Policy  |  Terms of Service  |  Articles  |  Site Map  |  RSS Site Map  |  Contact Us
Copyright © 2013  All Rights Reserved.   ::