Oracle Community Network
I am new to Oracle Business Intelligence (10). Can it connect to a data source (Oracle) and use PL SQL script or procedure/function, etc to generate a report? Where can I find some tutorial/documentation on that? Thanks.
I am not sure the product I use is OBIEE or not.
You can create a new analysis using the Direct Database Request option described here.
The example below was taken from this link
Create the function in the database:
CREATE OR REPLACE TYPE my_row AS OBJECT (my_num NUMBER);
CREATE OR REPLACE TYPE my_tab AS TABLE OF my_row;
CREATE OR REPLACE FUNCTION my_table_function RETURN my_tab
PIPELINED IS BEGIN
Create the direct SQL request:
SELECT CAST(my_num AS double precision) AS my_num3 FROM TABLE(my_table_function)
However, you need special privileges to do this. In 11g the required privileges are:
I think the same privileges apply for 10g, contact your Bi Admin =)
Please follow below link.
There are lot of options to generate a report, you case can also be possible.