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
What are the themes in a data warehouse?
Give the advantages of cognos?
Actually we have 500 users when they run the report display the flage image related country user? How its possible?
How do you call a store procedure within a transformation?
Explain what is the difference between microstrategy and cognos reporting tool?
After applying date prompt and when we run the report we
fet from date and todate prompts..so when we enter
todate what are the special features in cognos reportnet? 2. What functional area you worked on.
What is Additive function? Define report item? What are the different types of reports present in cognos? How to select multiple values from type-in prompt? how many numbers of cubes can we create on a single model? How can we navigate between those cubes? What do you understand by the term 'model durability'? -----------With out using DrillThrough how to do Reports?