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
- 14757 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 you burst the reports? If you are bursted reports is not reached to destination how you identify?when you import data into catalog you have complex columns names.how do you change the name of those columns?
How to create a cube in Transformer? What is the process? Please mention process thank u
Can anyone tell me which automation tool is used in cognos,is it a testing tool or performance enhancing tool Thanks in advance
I have a value prompt in my prompt page.Now if I set the filter to required then I have to select a value from the list and I will get the respective data in the report page.But If I select nothing then I will get the complete data in the report page. I want that if I select nothing from the prompt list then nothing is displayed in my report page. How should I do this?
What is Metrics designer?
what are the features in cognos8ui
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?
New coloums are added in database, then how you know in report level
I have the below IBM COGNOS 8 Certification latest Dumps: COG-112: IBM Cognos 8 BI Author COG-122: IBM Cognos 8 BI Administrator COG-125: IBM Cognos 8 BI Data Warehouse Developer COG-132: IBM Cognos 8 BI Metadata Model Developer COG-135: IBM Cognos 8 BI OLAP Developer COG-145: IBM Cognos 8 BI Multidimensional Author COG-180: IBM Cognos 8 BI Professional Recently new questions also have been updated in this Dump. If interested,mail me on kris.bi121@gmail.com with Exam Code and Exam name
how many types of keys are there i.e primary key and foreign key etc..?
what was the actual purpose of portfolio in cognos ?
Source table has 5 rows. Rank in rank transformation is set to 10. How many rows the rank transformation will output?
Teradata 
