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
- 14882 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 |
What is the difference between set functions and filter function in dimensional data?
What is defined as Cognos Impromptu?
Did you find any differences in bursting feature between reportnet 1.1 & cognos 8? what are the differences?
what is meaning by Master detailed relationship ? please explain one example
How can you create prompts in framework manager?
How can you schedule the report that it displays a day old data. (My answer was to create a view, but the lady wanted some other method).
Which service handles requests for cognos connection,query studio and event studio.
What is meant by grouped star schema
3. Differences between Cognos Sql & Native Sql? What are their Advantages and Disadvantages?
i have a sales project interviewe asked tel me the how many facts&dimensions used in ur project.
What are the components used in web tier?
what is the difference between aggregation and role up aggregation ?
Teradata 
