Interested to Buy Any Domain ? << Click Here >> for more details...
How to select multiple values from Type-in prompt?
Example - I want to enter into type-in prompt in 'Product
name--- Liza' display report data in 'product name is Leza'
only OR I want to enter into type-in prompt in 'All', that
time display report data in all are report data. How is
possible this Scenario using in type-in prompt.
- 5 Answers
- 14947 Views
- HSBC, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / cognos
By using the following condition as the filter for the
textbox prompt we can get the data for the specified
product as well as All products when we type ALL in textbox
prompt
Product name = ?P_ProductName? or 'ALL' in (?P_ProductName?)
| Is This Answer Correct ? | 5 Yes | 1 No |
Answer / lokendra
here we can enter one value,here it can't shows lovs.
in catalog colomns we can select the value for which we can
insert the pick list.
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / s.srinivas
BY USING STRING VARIABLE WE CAN SELECT(OR)ENTER MULTIPLE
VALUES
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / nasa
use soundex function
ex:
select product_line from product where
soundex(product_line)=soundex('Liza')
it will show all name related to liza or...
liiiza
leza
llliza
lezaaa.
what every it may be if pronunciation is okay it will show
all data..
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / asha
Can you be more specific abut this. What i understand from
the question, you have a prompt page with a text box prompt
and the user types the value. When the user types the
product name 'ex: laptop' and clicks 'finish' the report
page has to display all the records relevent to laptop.
When the user types 'All' in the text box prompt and
clicks 'Finish' the report has to display all the products.
Has someone tried this? Can someone help?
| Is This Answer Correct ? | 0 Yes | 1 No |
How can we migrate from Businees Objects reports to Cognos 8.x??
Can u please describe the different types of traps with eg. Thanks
Hi, I have Cognos 7.0 Impromptu reports and these reports have been created with the Mainframe datasource. Now the business needs these reports should be upgraded but with Oracle datasource. So what's the idea, first we should migrate these reports into ReportNet? then in that case what we will do with the Impromptu Catalog? Second, suppose we need to migrate these reports into Cognos 8 (may be 8.4) then how we will do that? do we need to create a FM Model for these reports. Please advice!
What is Cognos Powerhouse and what is it used for?
drillthrough vs master detaild report,which one is the best by performance?
What actually a project contains?
what is hints in cognos and where we use it.
Name the types of gateway?
What is the function of cognos dispatcher?
What is Performance Tunning Test?
What is set to be cardinality?
hi How Can we create rank in our report?i feel difficulty pls expain me with ex,pls pls........
Teradata 
