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
How to deploy from one server to another server?
What is the difference between a cascading report and drillthru report? Why do we go for drill thru report?
what are all the versions of cognos and cognos8 as well as mention all the advantages nd disadvantages in cognos8 versions. any one plz answer this question.
What is defined as Query studio?
HI, If anybody is having C2020-625 - IBM Cognos 10 BI Data Warehouse Developer, kindly send the same to shiju.rajs@gmail.com. Thanks
What are types of batch available in cognos?
Define catalog in cognos and write its various types?
Hi experts,Recently I faced one questions in MNC,They having 4 tables in FM ..One fact table CALLING X, Remaining 3 tables are there not fact calling y,z etc...We want to join individually from X to Y..please suggest.
Hi all... how can we publish packages using bmp scripts to Path:Public Folder Packages Folder
Define cognos report net?
hi..i'm searching on cognos.i want to know some real time explanation..persons who have real time exp and who r searching in this field..can u send ur mail-id..my mail-id is dhaanuus@gmail.com..hope u will respond as soon as possible..
What are the different types of important services used in cognos?
How the Bursting happens in same report and how to Print the bursting Report?
What are all the types of report?
what is stitch query in reportnet?