What is the stored procedure ? What is the need of stored
procedure ? How to create a stored procedure Universe?
Answer Posted / 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 |
Post New Answer View All Answers
What is the difference between business requirement document and use case document.
What is package in BO
What is aggregate table and aggregate fact table ... Any examples of both?
Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?
Explain the difference between union and group?
Hi, I would like to know how is the integration if we want to use Oracle Essbase as the Cube Engine, and present the Cube by Business Objects Presentation Layer? Can Oracle Essbase be integrated with Business Objects? Thanks,
How to create a new calendar in CMC? Can u please tell me the process to create the required calendar. Ex:- Year of that calendar to start with Jan-15 and ends with Jan -30 and the Next month to start with Feb-31 and ends with Feb-14.
Explain the data types present in bo and what happens if we implement view in the designer and report?
What we need to discuss with designer before starting the universe designing.
how to prepare the documentation in business objects and where to get the requirement?
What task is 98% of the required work of a business analyst?
Explain is there any default username & pwd for bo designer & supervisor?
what is universe null
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
Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...