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.
Answer Posted / 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 |
Post New Answer View All Answers
Explain what is the difference between native sql and cognos sql?
What do you mean by drill across?
What is the difference between set functions and filter function in dimensional data?
What do you understand by the term 'dynamic cube'?
Can we create 2 conditions in report expression of a single data item..Eg: I added 2 new dataitems each one should show revenue for Q1 and Q2..Pls advice
which type of project we r going to snowflake schema
What junk dimension contains?
where you can save the report net documentation in our local system?
What is Additive function?
what is power prompt in cognos ep7series?what is the use of this?
What are the types of catalogs in cognos?
how can you get the errors in job? when loops are araised we get error?
can you tell me what are the dimension tables are used in project
What are the themes in a data warehouse?
What are the services provided in cognos 8?