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 |
What is the pivot option ? what is the need of it?
What is maximum number of promts we can give in a BO report?
What is a fantrap in business objects?
IS THERE ANY MINIMUM RQUIREMENT TO DEFINE CONTEXT?
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?
how we send repotrts/documents to end user
i want to use prompt for select the country names. eg, india. japan. america. like that. which delimeter is used for to seperate the countries?
What is the difference between Boxir2 and Boxir3?
Can we configure two instances of CMS pointing to two different CMS system databases?
How to particiapte the columns availabe in the Derived tables in the Reporting window? How it's done?
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.
while migrate bo 5.1 report into boxir2 ,what are the problems faced