what is prompt types of prompt example briefly each types of
product (eg:values, date,search,prompt etc.)



what is prompt types of prompt example briefly each types of product (eg:values, date,search,prompt..

Answer / m m naidu

VALUE PROMPT: Value Prompt Retrieves data based on values
that you select from a list.
Use this control to show the list of possible values from
which users
can choose.
Note: The maximum number of items that can appear in a list
is
5000.

SELECT AND SEARCH PROMPT:Select & Search Prompt Retrieves
values based on search criteria that users specify. Data is
then retrieved based on values users select from the search
results.
Use this control instead of a value prompt if the list of
values is very
long, which can slow down performance.
Tip: Users have the option of performing a case sensitive
or case
insensitive search. A case sensitive search is faster,
while a case
insensitive search usually returns more values.
You cannot use this control if you are working with SAP BW
data
sources.

DATE PROMPT:Date Prompt Retrieves data based on a date that
you select.
Use this control when you are filtering a date column. With
this
control, users can retrieve data for a specific day, a set
of days, or a
range of days.

TIME PROMPT:Time Prompt Retrieves data based on a time that
you select.
Use this control to restrict a report to a particular time
or time
range. For example, you can use this control to see how many
orders are received after business hours. You can then use
this
information to determine the number of staff needed to work
after
hours.

DATE AND TIME PROMPT:Date & Time Prompt Retrieves data
based on a date and time that you select.
Use this control when you are filtering a datetime or
timestamp
column. This control is useful for specifying ranges. For
example,
you can retrieve all orders received from Monday at 12:00
a.m. to
Friday at 5:00 p.m.

INTERVAL PROMPT: Interval Prompt Retrieves data based on a
time interval that you specify.
Use this control to retrieve data that is related to the
passage of
time. For example, you can use this control to retrieve a
list of
products that were returned 30 or more days after they were
purchased.


TREE PROMPT: Tree Prompt Retrieves data based on values you
select from a list. Values are
organized hierarchically.
This control is useful when you are working with
dimensional data
sources. Data is shown from the top of a dimension
hierarchy to
the most detailed member, and users can choose the level of
detail
they want to view in the report.


GENERATED PROMPT: Generated Prompt Selects a prompt control
based on the data type of the data item.
This control acts like a placeholder. When you run the
report, the
control is replaced by the appropriate prompt control. For
example, if you are prompting date values, the control is
replaced
by a date & time prompt.

Is This Answer Correct ?    24 Yes 1 No

Post New Answer

More Cognos Interview Questions

hi cognos Experts what are the enhancements in cognos 10 than cognos 8.4?Pls Ans Me........

1 Answers  


what are the tabs in cognos ?

2 Answers  


i am having a table having name cust_employee.i use this table in my model after i published that to cognos connection .i generate some reports. after that in my data base cust_employee table is changed to cust_emp.how can i get this table into my report.i again import and published means its time consuming,in simple how can get the changed table in to my model pls pls ans me....

2 Answers  


The vice president of sales has requested a report that shows sales performance by representatives in each country for year 1998. He would also like to see the performance for reprasentatives in Asia in order to present an award to the top sellers when he visits next month.

0 Answers  


2. We have asked to create a repots showing sales by region in order to determine which regions are generating the most revenue and highest sales volume. The report needs to include the revenue and quantitiy sold of each subcategory with in category.

0 Answers   HCL,






write the sql query to display 5th and 10th row in a table?

5 Answers   CTS, IBM,


Hi Experts, Can a single package be shared by multiple users?

3 Answers  


how to create cubes in transformer ?

0 Answers   IBM,


Looking for IBM COGNOS Certification C1000-065 , C2020-605 , C2090-621 , C2090-623 Dumps?

0 Answers  


plz anybody help me, how many reports we can create in one project?, and what are the names?in real time project at first what we will do?

2 Answers  


im having a value prompt, in that value prompt im having the values as ABC and CDF, i want to hide the select box in that value prompt? is it possible in cognos?

1 Answers   IBM,


what is the difference between filter and condition?

0 Answers   IBM,


Categories