| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Experiences / Notes on Data Warehousing on 9iRAC on Linux
User ad-hoc queries are not necessarily the problem.
Do you pay someone to do BO (just kidding)?
BO includes a 'designer' to build objects in the universe *and* control access to DB data.
The universe holds all DB schema metadata. Its easy to just reverse engineer an Oracle schema into a BO universe and give the prototype to the users. But, that's not what is supposed to happen. The BO 'designer' is supposed to create report objects and tailor access paths for the user's ad-hoc reports.
(Note: Otherwise, what good are BO reports? Ad-hoc user reports require some level of effort by an BO designer. Otherwise, the reports are static and use custom SQL).
The BO reports access the DB through the universe both for static and ad-hoc reports. If the BO person has not done any 'designer' *work* then the report objects and access paths are not optimized.
Your users have simply exposed a lack of design, analysis, and *work* by a BO person. Next, watch for the complaint that the users have not defined their report requirements. Ad-hoc is supposed to be ad-hoc, eh? Someone with 'designer' experience (maybe not your guy?) should be able to design objects and access paths to overcome most of your ad-hoc performance problems.
Surely, your existing user reports can serve as some definition of user requirements?
Good luck. HTH.
Regards,
Mike Thomas
 |
 |