What is value prompt limitations while creating report?
What is select and search prompt?
- 1 Answers
- 10372 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
How do you test the performance of a report?
What is namespace and what it holds?
write a query to display the departments with no employee?
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
what is difference btw summary filter and detail filter, plz explain with example
10 Answers IBM, TCS,
My problem is as follows I made two pages of the portal; in the first page i have two reports and from one of these i would like to communicate in some way (i.e drill- through?) with the second page that contains four reports (prompt value [product] and three chart [sales revenue, sales quantity and budget]). Particularly I would like to communicate with the report that contains the prompt, passing the Product. How can i drill from the first page of the portal to the second page ? More generally, is it possible to move from one page, containing 2 report, to another page with 4 report, through a drill-through or any other mechanism? Thank in advance.
What is content store?
While running the reports how can we hide totals if the users doesnot requie it?
which difficult you faced in your project?
how to perform single sign in cognos by using url?
Can we provide Package level security to two different groups i.e for finace and HR depts should access only their data??
In which types of reports does the page breaks applicable in Cognos...?
Teradata 
