:: 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 (184)
 Business Objects interview questions  Business Objects Interview Questions (756)
 Cognos interview questions  Cognos Interview Questions (853)
 Informatica interview questions  Informatica Interview Questions (1626)
 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 (565)
 SAS interview questions  SAS Interview Questions (560)
 Micro Strategy interview questions  Micro Strategy Interview Questions (37)
 ETL interview questions  ETL Interview Questions (196)
 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
I have prompt date prompt (from and to), country and city, how to get data from jan1/2012 to jan31-2012. IBM 2
Cognos TM1 1. What are the different windows in Turbo Integrator? 2. What is the use of advanced window in Turbo Integrator? 3. What is TM1 Workflow. How do you create a process in that? 4. Where is Portlet used. What are differnt windows in portlet. How can you access TM1 web from portlet? Cognos 8. 1. What is Drill-on? 2.How do you implement row level security in Framework Manager? 3. How do you create tree prompt? HSBC 1
how to handle multifact? IBM 2
suppose there are 15 countries like (US, UK, ENGLAND,INDIA,JAPAN.......)i want a value prompt in the report and this value prompt should contain groups like group1(US,UK,ENG), group2(INDIA,US,UK), group3 (ENG,JAPAN,INDIA)and in the value prompt the values should be group1,group2,group3 how can we do this?   4
In framework Manager, what is a stitch query and is it good or bad? Polaris 1
Explain the Difference Between Bursting and Scheduling?   1
How to create a Left Outer Join in FM? Please explain. Cisco 2
where exactly determinants are used in cognos framework manager? Satyam 4
im having null data in one of the cell in my report i have to display as "no data" when u run the report how can i achive this problem? IBM 6
can you apply grouping on crosstab? CTS 1
What is Parametermap?   1
Which one is better among Value and select & search prompts,in terms of performance? L&T 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.   ::