Blue Prism Vs OpenSpan

Blue Prism vs. OpenSpan Base Technology

The process of extracting SQL for reports from OBIEE

OBIEE Training, Oracle Business Intelligence Enterprise Edition (OBIEE) is a complete business intelligence platform that distributes a complete range of reporting capabilities and analytical. Designed for reliability, performance, and scalability, Oracle Business Intelligence Enterprise Edition 11g gives relevant, actionable and contextual insight to everyone in a resulting, organization in improved better-informed actions, more efficient business processes and decision-making. It also presents the industries isolated multi-sourced BI applications, further power of BI platform is performed as market-leading performance management applications.

There are several ways with the help of which SQL can be extracted from OBIEE. 

  • The request can be changed and then by clicking on the Advance option the user will be able to get the XML code and the original SQL. 
  • Select the option of Tools Create a report from the catalog manager. Then click the request Structured Query Language option from the create report window. Also, the sales to physical path should be saved on the computer. 
  • In the OBIEE 11g administration tool, go to the mange option and then select the security option. Then by selecting the properties for user option make sure to enable the level of Log to 2. 
7 visits |0 Comments|Reply

Related Posts

There are no comments on this post

Write a New Comment on The process of extracting SQL for reports from OBIEE

Please Log In or Register to post comments.

[]