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.
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 a dimension?
what is difference btw summary filter and detail filter, plz explain with example
10 Answers IBM, TCS,
What is a Pivot?
What are the best practices while building a Cognos Framework Manager Package ? As in, what calculations would you not like to be handled in FM and rather get it directly from Database.
For example I developed some reports on employee package now I have to develop same reports to another package.How can I change reports to another package?
how to explain a project to the interviewer on sales project and what r the basics to be prepared to attend a interview
Hi Cognos Experts,I am Having DatePrompt In My Report.I want to display The Report Between Twodates Like jan-SEP How can We Achieve This one?PLS Expain Me With Ex:
What is a Transformer?
how to create relationship between emp and salgrade tables in frameworkmanager?
How do you deployment reports from one server (Development) to other server(Production)? How do you configure the cognos7.0 version cube in cognos 8.0? Pls, explain with example? How do you create IQD without IMR or can u explain other way create IQD?
what is the difference between application based and web based in cognos?can you please give a example from out of EP 7 series and 8 series?genrel exampel please?
What do you mean by drill across?