What is value prompt limitations while creating report?

What is select and search prompt?

Answer Posted / harisudhakar velagacherla

Value Prompt Limitation:
If you do prompting for a range of values(specified range)
using IN_RANGE operator,under FROM and TO tabs a range of
available values will be displayed.In that you need to
select the values.Incase if the available values are in a
range of decimals ,it is difficult to select .
EX:0-5000$(values to be prompted).You can not enter this
specified range.under FROM tab, you need to search for 0&
value and under TO tab ,you need to select 5000& from the
available values.Values displayed under FROM ,TO tab will
be in random.imagine if the values are in decimals
(ex:5000.009) ,then Is it easy to select the value
(5000.009)under TO tab ,if the values displayed in random?

To overcome this...we need to go for Text PROMPT for
prompting Specified range.what ever range you specified ,it
willbe get prompted.
when you need to cascade,use either value or select&search
Prompt.


Select & search Prompt:


when you need prompt the values that contains or starts
with specific characters then,enter them under SELECT tab
and then click SEARCH tab.Then maching values will be
displayed in search box.select the values and click right
arrow to move this values to diplay box and click finish
(click next if another prompt presents).
in short it is used to display one 0r multiselect values
(=,IN operators).IN_Range operator cannot be available.

Is This Answer Correct ?    1 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

-----------With out using DrillThrough how to do Reports?

1772


Can you explain cognos planning?

855


what is the diff. between a link n a union? what is a custom view? what is the use of unlocking a report ? plz answer to these

1770


dumps needed ASAP for - C2020-180 Cognos IBM Certification

2006


What is the enterprise class platform architecture of cognos 8?

785


Source table has 5 rows. Rank in rank transformation is set to 10. How many rows the rank transformation will output?

824


Can you define transformer?

699


What is a Folder?

883


hi, i am searching job in cognos and datastage, does any can provide me the real time experieced scenerios and questions related to cognos and datastage projects, so if anyone provide me the documents related this can very helpful to me, my mail id is tchiru01@yahoo.com

1957


What are the types of folder present in cognos?

840


How do you call a store procedure within a transformation?

762


hi this is bhaskar iam working in Tcs u want any real time faqs send me your qs i will ans that qs ok this is my id bhaskarparitala.rao@gmail.com

1789


What is difference between page break and section report?

929


What is cognos powerhouse?

774


HI, If anybody is having C2020-625 - IBM Cognos 10 BI Data Warehouse Developer, kindly send the same to shiju.rajs@gmail.com. Thanks

1684