Replies to This Discussion

Permalink Reply by Orval Hickman on October 4, 2013 at 11:48am

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...

Permalink Reply by Naeem Akhtar on October 4, 2013 at 11:50am

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