PL/SQL and Bo reports

[suzreid]

Can a BO report be based on a piece of PL/SQL?
The database holds records which contain a date range <date1> to <date2>. I need to produce a bar graph which counts occurances of an event for each day in the date range. As I can't get the information directly from the records I was planning on creating PL/SQL to do it but I need to know if it's possible to create the report this way?

 

[pabloj]

Can't you create a view? Stick to your guns

 

[blom0344]

Hello Suzreid,
Probably not (to answer the question you started your thread with)

As PL/SQL is the programming language to SQL it is focussed on acting upon data instead of producing data-sets to work with. If you cannot get the proper structure set-up using a universe upon database-tables ALWAYS go for a view first. This will create a virtual entity you can adress by incorporating in a universe or by free-hand SQL. I would be very surprised if , in your case, you could not create a usable view. If you run aground, there are plenty members to get you afloat again ............. T. Blom
Information analyst
tbl@shimano-eu.com

 

[suzreid]

Can I create the view in BO or do i have to create it in the Oracle database. The problem I have is that the database belongs to another company and I don't know how willing they would be to allow me to add views to their database?

 

[pabloj]

The view has to be created in the db AFAIK, sorry Stick to your guns

 

[blom0344]

Hello Suzreid,

A view is strictly a database object. In fact it is nothing more than a SQL at DB level. As long as you stick to just &quot;select&quot; views that perform quick enough (test!) when they are called , a select view is also much less potentially harmfull than a PL/SQL procedure, so the third party would sooner give the go for a view than for a procedure, me thinks

(Last week , in my case I got the go from the vendor of our warehouse system, which puts me in the same situation you are in, but just a little further ahead ......) T. Blom
Information analyst
tbl@shimano-eu.com

 

[suzreid]

Thanks for your help. I'll wait for the vendor to give the go ahead.

 

[nimmy99]

If your using any Stored Procedure, then you can select the stored procedure as your data source while creating reports