How can you create prompts in framework manager?
Answers were Sorted based on User's Feedback
Answer / sandeep8000861
We dont actually create prompts in FM.
There is a property known as Prompt for each Query Item
(field/column name). You just set this property to the
required prompt type.
After the properties are set, you publish the package.
In Report Studio, you just drag and drop this Query Item and
define a filter with ?Query_Item?. You can set the Data
Format for the Query Item here.
| Is This Answer Correct ? | 23 Yes | 8 No |
Answer / beckham
#(prompt('prompt name',datatype))#..
This is the syntax for prompts, you can use the use value
as well.
use prompt many when u use 'in' operator in the filter.
| Is This Answer Correct ? | 16 Yes | 7 No |
Answer / santosh kumar
If you want to create a prompt in a FWM, goto queryItem and
just slect the field for which you want a prompt and keep
as follows:-
For eg if you want to keep prompt for product location
select that in Qurey Item and keep as
product location=?some text?
and test....
| Is This Answer Correct ? | 6 Yes | 12 No |
There is a property known as Prompt for each Query Item
(field/column name). You just set this property to the
required prompt type.
After the properties are set, you publish the package.
In Report Studio, you just drag and drop this Query Item and
define a filter with ?Query_Item?. You can set the Data
Format for the Query Item here
| Is This Answer Correct ? | 2 Yes | 9 No |
1. What is stiched Query 2. What is loop in Fm 3. Best practices in modeling in FM 4. Three types of SQL 5. Difference between pass-thro and native sql? 6. will usage of pass thro sql will improve the performance? 7. Complex problems fced in your project 8. performance tuning in reports
What is the importance of having monitor service in cognos?
I have ten columns that needs to be totalled... but some columns are empty...how do i get sum all the columns even if sum are empty? Can i get a total of the rows instead of columns? if yes, what is the function to be used?
set scope level in transformer
can any body clesrly explain about types of query subjects.that is data source query subject,model query subject,stored procedure query subjects?
Hi everyone, In my report i have ten pages like page1,page2, upto page10, i have textbox prompt when i enter 1 page1 should display,when i enter 2 page2 should display,can anyone suggest the answer.
Hi All, When user run the cognos report, that report output data must be download/available in EXCEL / CSV file.? (like... list report contain PL,PT,PN,RVEN, that excel/csv default download must be list columns PL,PT,PN,REVN) Thanks in Advance, LN.
What do you understand by the term 'dynamic cube'?
-----------Diff b/w OLAP and RDBMS?
Can you explain a cognos controller?
What are slice and dice?
What is power prompts?Can somebody explain me.