Oracle Business Intelligence Applications (OBIA)

143 members

Oracle Business Intelligence (BI) Applications are complete, prebuilt BI solutions that deliver intuitive, role-based intelligence for everyone in an organization from front line employees to senior management that enable better decisions, actions, and business processes. Designed for heterogeneous environments, these solutions enable organizations to gain insight from a range of data sources and applications including Siebel, Oracle E-Business Suite, PeopleSoft, and third party systems such as SAP.

Oracle BI Applications are built on the Oracle BI Suite Enterprise Edition, a comprehensive, innovative, and leading BI platform. This enables organizations to realize the value of a packaged BI Application, such as rapid deployment, lower TCO, and built-in best practices, while also being able to very easily extend those solutions to meet their specific needs, or build completely custom BI applications, all on one common BI architecture.

Comments Discussions Members

Oracle Business Intelligence 10 data source

by Danette Slifer

Oct 4, 2013

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.

up
Orval Hickman
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:
- Presentation catalog privileges:
  - Edit Direct Database Analysis
  - Execute Direct Database Analysis
- RPD privileges:
  - Execute direct database request
I think the same privileges apply for 10g, contact your Bi Admin =)

http://stackoverflow.com/questions/18253369/oracle-business-intelli...
Oct 4, 2013
up

Naeem Akhtar

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

Oct 4, 2013

2 members like this

OracleConnections

Oracle Business Intelligence Applications (OBIA)

Oracle Business Intelligence 10 data source

Orval Hickman

Naeem Akhtar