What is the stored procedure ? What is the need of stored
procedure ? How to create a stored procedure Universe?
Answer / sivakumar
Store procedure is used to excutea set of sql queries ,
Its used in the scenario where the query is used in
mulitple times.
there is a option in the designer to retrive the structure
of the universe through store procedure.
Is This Answer Correct ? | 2 Yes | 0 No |
suppose case1:a person buy a car case2: rent a car which is context & which is alias? why?
define universe parameters?
HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?
difference between xir2 and 6.5 version
can we create aliases for every table beforehand? if yes whar are the disadvantages?
How to add additional objects or tables into the universe,and what are steps we need to follow to achieve the above task.
What is shortcut join?could give any one example?
IS IT POSSIBLE TO CREATE REPORTS FROM DIFFERENT UNIVERSES IN ONE DOCUMENT?
How to create Index to the table in the universe designer and how it improves the Query performence
IF VIEW IS FASTER THAN DERIVED TABLE WHY WE ARE USING DERIVED TABLE IN BUSINESS OBJECTS?
How to restrict the user to refresh or Run the report only 1 time in BO?
what is meant by slowly changing dimensions?