What is the use of Generated Prompt? Where is it used in
realtime project?
Answers were Sorted based on User's Feedback
Answer / arun pandiyarajhen
Well, it is an interesting prompt in Cognos. The generated
prompt is used whenever we are not sure which prompt to use
in the report. When we use generated prompt, it will change
itself into a suitable prompt based on the column type
which is associated with it.
If we want to select single value in text datatype in the
prompt, it will change into a value prompt.
If we want to select multiple values in the prompt, it will
change into a list box.
If we want to select single value in number datatype in the
prompt, it will change into a text box prompt.
If we want to select the range between to values in number
datatype, it will change into intervals (2 text box
prompts) asking for the range.
If we want to give the range between to values in text, it
will change into two value prompts.
We can predefine which prompt should be displayed for the
chosen column properties in the Framework Manager.
The above specified prompts are defaults.
regards,
Arun
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / navneet singh
Generated Prompt is a prompt which is made on data type of
Query Item. For Example Go Sales and Retails Package take
Product Line and then click on Build Prompt Page, then by
default Value Prompt would be displayed.
When you don't know which prompt would be suitable to
desired Query Item.
| Is This Answer Correct ? | 7 Yes | 6 No |
Answer / chiru
Generated prompt is different from other prompts..
Suppose we do know exact data(Query item) in Query Subjects(Columns in report), then we should select the Generated prompt.
When we run the report, the generated look the data in that column and generate the required prompt.
Like suppose if there is Date in that Column, it generates a Date Prompt, suppose it there is names in Column, then it generates Value prompt.
| Is This Answer Correct ? | 0 Yes | 0 No |
is there any difference between operational database and data base?if yes what r they?
can anyone let me know some tips or interview questions on framework manager metadata modeling, creating joins, and all other aspects related to Cognos 8 framework mgr
Can you explain dynamic query mode?
Name the types of gateway?
what happens when date function has taken as attribute
we have a column of int/varchar datatype,but when we run the report we should get the date format i.e., suppose date key is a query item consists of data as 20040105,20030503,20060410....... output should be 5 jan 2004,3 may2003,10 apr 2006..........respectively.Can i knnow the answer
how the values be passed to prompts in report studio? when a data item is dragged n dropped in to report, after the default query generated first which sql will the query query hit for processing means (native or cognos)? plz answers to these questions?
3 Answers TCS, Thomson Reuters,
8. Can you use calculations in report headers and footers? How?
1.How can we driil through from a page report having query1 to list report having Query2 in master detail relationship n Drill through? 2.In database i have 50 records but when it is displayed on the report i'm getting 100 record with duplictes.How can we solve this to eliminate duplicates? 3.Exact Diff B/W Filter n Condition? 4.Render Variable? 5.I have leftouter join when right table does not have any matched records with left table what will be the output of the report whether it will be dispalying Null or blank in that particular row? 6.How to test the reports i.e Unit Testing? 7.How canwe drill through when there is no common column between the parent n child report? 8.How can we do performance tuning? I kindly request all the experts to give reply with correct answers and if possible send me some examples regarding that at srini.madhala@gmail.com
How you drill from powerPLay to Impromptu?Explain all Steps?
How to deploy from one server to another server?
I need your kind support. I have more than 6yrs of exp in s/w industry. I have worked on some DW technologies which are out dated. For almost 1 year I was on bench.During this bench period I learnt cognos on my own using online docs. Hence I am alligned to a project few months ago to work on cognos. Unfortunately after joining this project I did not get opportunity to work on cognos. I am working on different things apart from cognos. I should get job in another company. Otherwise I am gone. I am confident enough to get job on Cognos in another company. Please let me know is it possible to work on Cognos at lead position (as my current position is at lead level) without having real time experience. Your response is highly appreciated and I will be grateful to you. Thanks in advance Ganesh