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

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.

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.

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.

What is batch processing in Business Objects?

2 Answers  

---

Why do we need metrics and sets?

1 Answers  

---

Explain the difference between detect alias and detect context?

0 Answers  

---

why do we use crystal reports rather than webintelligence reports ?

7 Answers   CTS, Tech Mahindra,

---

Is it possible to generate reports without having knowledge of the Universe structure?

4 Answers  

---

HOW TO CREATE THE HEIRARCHY IN WEBI OR DESKI NOT IN UNIVERSE LEVEL?

5 Answers   HCL,

---

1) How can you use slowly changing dimension type 2 in Universe, Reporting and what would be the build process. 2) How can you identify the users in webintelligence not using the reports past few months. And delete them. 3) How can you move documents from one environment to other environment

3 Answers   Hexaware,

---

solve the following loops? dimension table fact table fact table dimension table link will be there between tables?

4 Answers  

---

if we shortcut join between two tables what will be the output?that it will give all columns or same columns?

2 Answers  

---

Hi, i have 10 data providers in report? i want to see only two data providers remaining are hide? how can do it? Thanks&Regards raghu.shiva

1 Answers  

---

HOW DO YOU SCHEDULE THE REPORTS?

5 Answers  

---

. In production reports, some dimensions are missing. how do you load these dimensions in production

2 Answers   TCS,

---