Oracle Business Intelligence 10 data source - OracleConnections2024-03-29T12:44:23Zhttp://www.oracleconnections.com/forum/topics/oracle-business-intelligence-10-data-source?groupUrl=oracle-business-intelligence-applicatons-obia&commentId=6612035%3AComment%3A39879&groupId=6612035%3AGroup%3A38498&feed=yes&xn_auth=noSlifer,
Please follow below l…tag:www.oracleconnections.com,2013-10-04:6612035:Comment:398822013-10-04T06:50:10.860ZNaeem Akhtarhttp://www.oracleconnections.com/profile/NaeemAkhtar
<p>Slifer,</p>
<p>Please follow below link.</p>
<p><a href="http://obieeelegant.blogspot.com/p/obiee-11g-material.html">http://obieeelegant.blogspot.com/p/obiee-11g-material.html</a></p>
<p>There are lot of options to generate a report, you case can also be possible.</p>
<p>Regards</p>
<p>Naeem Akhtar</p>
<p>Slifer,</p>
<p>Please follow below link.</p>
<p><a href="http://obieeelegant.blogspot.com/p/obiee-11g-material.html">http://obieeelegant.blogspot.com/p/obiee-11g-material.html</a></p>
<p>There are lot of options to generate a report, you case can also be possible.</p>
<p>Regards</p>
<p>Naeem Akhtar</p> You can create a new analysis…tag:www.oracleconnections.com,2013-10-04:6612035:Comment:398792013-10-04T06:48:36.206ZOrval Hickmanhttp://www.oracleconnections.com/profile/OrvalHickman
<p>You can create a new analysis using the Direct Database Request option described <a href="http://gerardnico.com/wiki/dat/obiee/direct_database_request" rel="nofollow">here</a>.</p>
<p>The example below was taken from <a href="http://gerardnico.com/wiki/dat/obiee/direct_database_request_table_function" rel="nofollow">this link</a></p>
<p><strong>Create the function in the database:</strong></p>
<pre><code>CREATE OR REPLACE TYPE my_row AS OBJECT (my_num NUMBER); <br></br> CREATE OR REPLACE TYPE…</code></pre>
<p>You can create a new analysis using the Direct Database Request option described <a href="http://gerardnico.com/wiki/dat/obiee/direct_database_request" rel="nofollow">here</a>.</p>
<p>The example below was taken from <a href="http://gerardnico.com/wiki/dat/obiee/direct_database_request_table_function" rel="nofollow">this link</a></p>
<p><strong>Create the function in the database:</strong></p>
<pre><code>CREATE OR REPLACE TYPE my_row AS OBJECT (my_num NUMBER); <br/> CREATE OR REPLACE TYPE my_tab AS TABLE OF my_row;<br/> CREATE OR REPLACE FUNCTION my_table_function RETURN my_tab<br/> PIPELINED IS BEGIN <br/>PIPE ROW(my_row(1.23));<br/> END; / </code></pre>
<p><strong>Create the direct SQL request:</strong></p>
<pre><code>SELECT CAST(my_num AS double precision) AS my_num3 FROM TABLE(my_table_function) </code></pre>
<p>However, you need special privileges to do this. In 11g the required privileges are:</p>
<ul>
<li><a href="http://docs.oracle.com/cd/E28280_01/bi.1111/e10543/mgrgrpsusers.htm#BIESC191" rel="nofollow">Presentation catalog privileges</a>:<ul>
<li>Edit Direct Database Analysis</li>
<li>Execute Direct Database Analysis</li>
</ul>
</li>
<li><a href="http://docs.oracle.com/cd/E28280_01/bi.1111/e10543/intro.htm#CJHGABJI" rel="nofollow">RPD privileges</a>:<ul>
<li><a href="http://docs.oracle.com/cd/E28280_01/bi.1111/e10540/dataaccess.htm#CHDJFFEG" rel="nofollow">Execute direct database request</a></li>
</ul>
</li>
</ul>
<p>I think the same privileges apply for 10g, contact your Bi Admin =)</p>
<p></p>
<p><a href="http://stackoverflow.com/questions/18253369/oracle-business-intelligence-10-data-source">http://stackoverflow.com/questions/18253369/oracle-business-intelligence-10-data-source</a></p>