explain about Prompt with example?
- 4 Answers
- 10532 Views
- CSC, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sri
Hi everybody,
prompts are the user interactive objects
which will allow the user to enter the value based on the
value the query will be executed and the results will be
displayed in the report based on the prompt value,
for eg:@prompt('enter the value for the
year','Á','class/object',mono,free)
By using this the BO will ask the user to enter the year
based on the value of year the query will be executed.
If he selects the 2001 then the year will be equal to 2001
| Is This Answer Correct ? | 17 Yes | 0 No |
Answer / shashank pathak
Prompt is a function in BO, that is used to get report
containing specific data. Specific to what prompt values
have the user entered. A prompt could be given in the query
panel while editing the data provider for the report.
for ex, if a prompt has been added in a column
say "balance" ,and the prompt asks for which date the user
wants to see the balance, then the user can either on its
own put a value or he can also select value/values from the
list of values.
| Is This Answer Correct ? | 9 Yes | 0 No |
Hi Everybody,
Prompt is user interact object as said above.
It is limiting the result set data. Data will fetch from DB
based on what user has entered the value in prompt.
Its improve the query performance too rather
than fetching all the data from db.
we can create prompt from dimension object as
run time while creating the report for first time or create
predefined prompt while design the universe using @prompt.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / raj
prompts can be used to restrict the data or to make large value objects easier to use.you use the @prompt function in the WHERE clause for an object.it forces a user to enter a value for a restriction when that object is used in a query.
| Is This Answer Correct ? | 0 Yes | 0 No |
Hi, How to navigate one report to another report in webi? Thanks in Advance
What is the Drill filter and it's usage?
1)I have createcd a dashboard on Bex query. How to refresh the Dashboard without hitting the bex query? 2)What is Event based scheduling in BO? 3) How to display the BO webi report title using a function? 4) For eg in my webi report iam having a person name like Jhon Peter Adam. But i need to get only the middle name of the person like Peter. What function is used in Webi to get this?
what is Scope of Analysis
what is aggregate navigation?
3 Answers Countrywide, CTS, HCL,
can BO generate reports with out CUBICAL data to repository?
Types of universes in business objects?
what are the complex reports you have created. Tell me with example?
CAN WE CREATE VIEW IN BO (NOT DERIVED TABLES)?
what is the necessity of oracle for business objects,why the interview panel is concentrating on oracle very much? Just we need the commands using select,joins? why they r asking about cursors,triggers etc..can any body answer me ..........Thanks in advance prakash
why less number of records in loop? why more number of records in traps?
bo 6.5 is a 3 tier architecture. Tell me the names of the tiers?
Teradata 
