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
- 2 Answers
- 4953 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
how to perform back drill through in cognos 8 what is the use of it
Can you define confirmed dimension?
What condition do we use in Cognos when multiple path exits to reach the fact table.(i.e in BOXI we use CONTEXT when multiple path exit)
Can you define transformer?
What are the advantages of using cognos sql?
How do you Parametermap variables in Quiries?
---------------Describe OLAP Reporting and RDBMS Reporting?
What's the limitation of 'Page Footer' in Report Studio? e.g. If I have an activity prompt (list of activities in a Search & Select Prompt) and selected around 2500 activites from the 'Activity' Search & Select Prompt and when I ran the report I got a message "#! Overflow" in page footer. Can somebody please tell me what's max. limit. I tried with around 300 activities and page footer displayed the activities. Your help will be appriciated.
What is the information present in the cognos configuration file?
What are the different types of important services used in cognos?
How to deploy from one server to another server?
how you migrate reports to cognos 8 from previous versions?
----------------Diff b/w Dimensional modeling and Relational modeling?
What are the different types of reports present in cognos?
How can you link a query to a data container manually in Report Studio?
