explain about Prompt with example?

Answers were Sorted based on User's Feedback



explain about Prompt with example?..

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

explain about Prompt with example?..

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

explain about Prompt with example?..

Answer / sathish

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

explain about Prompt with example?..

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

Post New Answer

More Business Objects Interview Questions

how to test the reports if there are multiple sql statements?i,e if there is 1 single sql statement we can copy it and paste it in TOAD or someother tools to test it but if we have multiple sql statements in a single query????

1 Answers   IBM,


Explain the SQL Queries activated to data base from Data provider in BO ?

1 Answers   Polaris,


What is Custom Sorting? In development environment we had applied custom Order on Month which is having the following list of values September,October,March,August and December only.But in Production environment Month is having all LiSt of Values like 12 MOnths(Jan to Dec).So ,How it will effect the Sorting in production environmentof universe and as well as in reporting????? Thanks in advance.

3 Answers   Collabera,


What is the difference between master-detail and Breaks?

3 Answers  


How to get red line in the graph at some point (value)? Example : In graph at 200000 value

1 Answers   Rolta,


why do we use crystal reports rather than webintelligence reports ?

7 Answers   CTS, Tech Mahindra,


How will you know the version of Bo using designer?

4 Answers   Tavant Technologies,


any difficulitis have you phase while creating bo reports and how did u solve it

0 Answers  


How to schedule the report in b.o?

0 Answers  


How do scheduling the report in BO XIR2? can you say what are they steps?

5 Answers  


hi all of u, i want to learn the course in SAP(BI).because of there is no calls for BO. And the another region is it will be converted into SAP module. is it OK for me? is there any feauture in coming days? could any one plz send me the message

0 Answers   Wipro,


What are the join problems comes appart from loop,chasm & fan Traps

0 Answers   IBM,


Categories