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
Explain in detail about type 2(scd),
What is difference between custom hierarchy and report based hierarchy?
Explain what is aggregate table and aggregate fact table ... Any examples of both?
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?
What are the steps to be taken to schedule the report?
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?
can anybody tell me about complicated object you have created
Can Bo generates the Report from the cubical data Explain?
Explain how we drill up week to month?
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
How to execute the plsql procedure from the report by clicking with mouse?
Can we create universe with no cache??
Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?
How would you format some text using css to be verdana and bold?
Explain the difference between union and group?