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
- 5921 Views
- HCL, I also Faced
- E-Mail Answers
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 |
HI EVERYONE I HAVE A QUESTION I FACED A QUESTITON FROM INTERVIEWER IN WEBI REPORT CREATING CROSS TAB REPORT FOR EX: YEAR IS COLUMN WISE AND MONTH IS ROW WISE AND INTERSECTIO IS REVENUES . HE WANTS BREAKS AT FIRST 3 MONTHS IN ROW LEVEL .. COULD U PLEASE TELL ME IF ANYONE KNOWS..
How can I display the query execution time for a particular DP on Web-I report? Or is there any other way to know the 'exact query execution' time at BO end?
which is the best way to resolve loop context r alias why?
i want to take a report 10 records per page. How to take it? is there any paging option in BO?
without creating the business view is there possible to create & generate the Crystal reports?
I have a situation like one manager can have multiple learners under him. each learner will registered for more than one certifications . their statuses for different courses like completed, inprogress, dropped, no certifications. the question is i have check for each user for statuses if he had some completed certifications i have to get latest completed date and omit all other stauses. if he had no complete staus then i have to get latest inprogress record based on date. like this i have to select only one record for user. but i am getting one row for each status. among all completion status one record, for all inprogress one record, for all dropped status one record. how can i show only one record
What is a Set?
What is the difference between Sychronisatio and join?
Can anybody tell me the difference b/w canned and adhoc reporting?.
What is the use of Surrogate Key in BO?
What are all the points to keep in consideration, while we are migrating the Universes,Reports from BO5.1.6 to BO 6.5? Is is compatible to migrate like this? Does it effect the filters in Reports and Join in the Universe?
What is the BO project Architecture? Explain in detail? Thanks in advance for ur answers?
Teradata 
