Store procedure is used to excutea set of sql queries , Its used in the s

What is the stored procedure ? What is the need of stored
procedure ? How to create a stored procedure Universe?

Question Posted / sivakumar

1 Answers
5832 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

Please Help Members By Posting Answers For Below Questions

Explain how can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?

999

how to prepare the documentation in business objects and where to get the requirement?

2179

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??

4376

how many reports have u created ? explain a few.

2047

How we drill up week to month?

1008

how to create metric universe ?

2293

Difference between zabo and webi?

1073

(1) Is it possible to create measures using objects from different context. (2) If cross context measures are not possible then what about @aggregate_aware() function ,here we use objects from different contexts. (3)Two measures from two different context ,can they be summed at report level.

1486

How to schedule the report in b.o?

970

What is the profile and package?

2258

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?

2192

what are the tables used in health care domain project and columns used in report?

4477

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...