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.

Views: 56

Replies to This Discussion

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
PIPE ROW(my_row(1.23));
END; /

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 =)

http://stackoverflow.com/questions/18253369/oracle-business-intelli...

Slifer,

Please follow below link.

http://obieeelegant.blogspot.com/p/obiee-11g-material.html

There are lot of options to generate a report, you case can also be possible.

Regards

Naeem Akhtar

RSS

© 2019   Created by Maisam Agha.   Powered by

Badges  |  Report an Issue  |  Terms of Service