Interested to Buy Any Domain ? << Click Here >> for more details...
What is the stored procedure ? What is the need of stored
procedure ? How to create a stored procedure Universe?
- 1 Answers
- 6020 Views
- HCL, I also Faced
- E-Mail Answers
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 thumbnail?
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...
webI report not showing Barcode in PDF format, i have used BC39 font,but barcode is shown in HTML but not in PDF, please any solutions??
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
What is a fantrap in business objects?
Tell me a business scenario where I can achieve the data through MINUS only not through subquery.
BO Security (creating the restriction sets in Universe and applying on selected groups or users) or Database security (Creating the tables in database insrting the user details in that tables and giving conditions in self restricting joins in Universe )Which Security will improve the performance of the reports and for best practices ? I am thinking BO Security will give the better performance, could you please share your thoughts on this please... Thanks...
Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?
Explain the data types present in bo and what happens if we implement view in the designer and report?
Explain is there any other repository domains rather than universe, security, document?
Explain about a time when you discovered a more efficient way to do a work task?
What sort of existing documents should business analysts refer to when starting on a new project?
How to schedule the report in b.o?
When we use aggregate awareness function in designer?
Explain what are the steps to do to use alerts in bo?
