I have a value prompt in my prompt page.Now if I set the
filter to required then I have to select a value from the
list and I will get the respective data in the report
page.But If I select nothing then I will get the complete
data in the report page.
I want that if I select nothing from the prompt list then
nothing is displayed in my report page.
How should I do this?






I have a value prompt in my prompt page.Now if I set the filter to required then I have to select ..

Answer / naresh

For this , you have to make static prompt values.

while making static prompt values create one empty value this will gives no data when you run the report with no value.

----------------------------------
But generally ,

If you are making filter is required , while running it won't highlight the Finish button if you are not selecting value,so without selecting values you cannot run the report.

If you are making filter is Optional means it will consider no prompt/filter if no value selected from prompt, it will allow to run the report.

So based on above two cases , second case is not preferable to run the report.

Is This Answer Correct ?    11 Yes 2 No

Post New Answer




More Cognos Interview Questions

What is conditional styling? a.format applied based on filter b.format applied based on user c.format applied based on on condition d.all the above 2. For a company X, actual revenue and budgeted revenue are captured in two tables Fact_Ac_Rev and Fact_Bud_rev. Both are at diff levels of granularity (Fact_Act is month and budget @ quarter leve )and there is one common Time dimension, A report is created to show the actual and budgeted revenue 2gther but the data for budgeted is wrong. Which should be doing for rectifing the error? a. create determinants for month and quarter b. join the two table facts into a single fact c. Create 2 time dimensions @ FM d. Need to create 2 separate reports as the required info cant be shown using a single report. 3. Template in a Query Studio? a. sample Data set b. CSS c. A standard that applies for all reports d. None of the listed options 4.you are a report author @ the Company, which sells sporting equipment 5. Sales person in different regions each need a report showing sales target for each country. which of the following is the best way to distribut? a. Email b. Bursting c. storing in public folders d. All the above. 6. I)A query subject behave as a dimensional in one query and fact in other query. ii) Queries with more than one fact results in stitched query. iii) Cognos identifies a query subject as Fact based only on the measure a. ii only b. i only c. both i and ii d. iii only 7. what is meant by pivoting? a. making a stacked set b. swapping rows into columns c. making column as filter d. none of the above 8. A report cant be viewed in which? a. CSV b. XML c. ASCII d. Excel 9.A user wants to retriv all products which are not sold for last X days. Which prompt is used? a. Time b. Value c. Text d. Interval 10. Dispatcher? a.routes request to appropriate services and start services b. routes request to appropriate services c.starts all service d. none of the abv Frenz Please help me out !!! :) Thanks in Advance

1 Answers  


please tell me architecture of the cognos8?

4 Answers   TCS, IBM,


what is a prompt value in report studio and variables ?

0 Answers  


what does my folder and public folder contains? difference between the my folder and public folder?

3 Answers   HCL,


what are determinants?

4 Answers   IBM, College School Exams Tests,






How to upgrade drivers in Cognos 8?

1 Answers  


how can we Upgrad the reports from version Impromptu 6.0 to 7.0 and Power Play from version 6.6 to 7.0 ?

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  


--------------Diff b/w ODS and OLAP?

0 Answers   Bank Of America,


is there any possibility to hide items other than render variable?

2 Answers   IBM,


hi cognos Experts what are the enhancements in cognos 10 than cognos 8.4?Pls Ans Me........

1 Answers  


what is report burn and where it occurs

3 Answers   Target, IBM,






Categories