explain about Prompt with example?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain in detail about type 2(scd),

785


What is difference between custom hierarchy and report based hierarchy?

762


Explain what is aggregate table and aggregate fact table ... Any examples of both?

818


If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?

1971


What are the steps to be taken to schedule the report?

722


What are all the points to keep in consideration, while we are migrating the Universes,Reports from BO5.1.6 to BO 6.5? Is is compatible to migrate like this? Does it effect the filters in Reports and Join in the Universe?

1786


can anybody tell me about complicated object you have created

2944


Can Bo generates the Report from the cubical data Explain?

1811


Explain how we drill up week to month?

824


Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye

1618


How to execute the plsql procedure from the report by clicking with mouse?

796


Can we create universe with no cache??

2155


Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?

886


How would you format some text using css to be verdana and bold?

859


Explain the difference between union and group?

821