1. Categories >> Software >> Data Warehouse >> Cognos
  2. Suggest New Category

If there are two values at value prompt level and when selecting first value it
have to go to date prompt and when selecting second value we have to get
output without any prompting. How to solve this issue. if any plz mail me on this
vasuattada@yahoo.co.in

Question Posted / vasudev

Answers were Sorted based on User's Feedback



If there are two values at value prompt level and when selecting first value it have to go to date..

Answer / krishna

Use conditional block

Is This Answer Correct ?    2 Yes 2 No

If there are two values at value prompt level and when selecting first value it have to go to date..

Answer / pradeep

create a dataitem ib the query like...

case
when ?first? = 'Product Line' then [Product]
else
?Product?
end

use this dataitem in the filter condition for product

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Cognos Interview Questions

Explain what is the difference between native sql and cognos sql?

0 Answers  

what is alias what is shortcut what ia alias shortcut and diff among them if u know explain clearly

2 Answers   TCS,

How can we improve performance in framework manager level?

3 Answers   Wipro,

if ur report having report filter save the report.open u r report in cc the report filter doesnt work means it does n't any values what we do for this situation?where we rectify this?please please ans me......

0 Answers  

hi Here ive question on Reportnet when we save a report in reportstudio with what ext it save

6 Answers   iGate,




What is drill down and slicing and dicing whats the difference between them?

0 Answers  

what is materialised view? why we use it in data warehousing?

5 Answers   HCL,

How can I test reports in cagonos?

0 Answers  

What is a dashboard in Cognos Report Studio and how do we creae it

2 Answers  

Can you please tell me the limitation of Excel file when exporting from report to Excel? I can export to HTML and PDF but I can't export to Excel. The report is more than 13000 rows. When exporting to Excel, system can view it. After that, I save the report to an Excel file. The size of Excel file is more than 11 MB. But I can't view this file by Excel. Please help me to solve this problem. Thanks!

1 Answers  

how to create average on totals of different departments employees salary...? consider we have 3 dept and in each dept 10-15 workers i need to get the totals separately for each dept and average of there totals..help me pls

2 Answers   Patni,

which table we load first in DW. dimension or fact? why?

4 Answers   IBM, JPMorgan Chase,

For more Cognos Interview Questions Click Here
Categories