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
what are the migration tools available in the market with respect to cognos such as impromptu reports are migrated to cognos reportnet?
3. The vice president of sales has requested a graphical display of the same information provided in our last crosstab report (whatever I mentioned in above question) for an up coming presentation. We need to provide a chart report that shows which regions generate the most revenue and sales volume.
How to Reset Pagenumbers in one report.
How do you Parametermap variables in Quiries?
What is the size of database for you project?
What are slice and dice?
2. What functional area you worked on.
What are initial page components of Cognos connection?
Can you define set to be cardinality?
What is a Datastore in Cognos?
What is the use of powerhouse?
What is defined as Cognos Impromptu?
Can you define cognos decision stream?
Can you define pivot?
What do you understand by ‘ibm predictive maintenance and quality’?