Oracle biee tools based on Oracle ERP development

　Biee tool Installation

Bi, Bussiness
Intelligence business intelligence. This concept is a bit overwhelming, every application
Vendor is gaining popularity. The basic principle of Bi is to implement OLAP (Online Analytical Processing Oriented to Data Warehouse datawhse ). The common form development is basically based on
OLTP (online transaction processing for database ). Oracle
Diccoverer is also the scope of Bi, But Oracle explicitly included discoverer in the scope of C/S-BI tools. To implement ROLAP,
Molap, you have to use Oracle
Biee. In fact, Oracle BI tools are also messy, including C/S discoverer and web discoverer. Oracle
Biee. In addition, we have acquired Bi tools from other companies.

Download the biee_windows_x86_101340 file from Oracle. Install jdk5 and set the java_home variable before installing biee, because biee is also running in the same way as in the same way. Other installation steps are all the way to next.

　
After installation, check Oracle BI Java host and Oracle BI presentation in services. MSC.
Whether the four services, Oracle BI scheduler, and Oracle BI server, are started. Normal Oracle BI
Scheduler is not started because it must be configured first. Start Menu => Oracle biee => job
Manage. Then file => Configuration Options

　　

　
Then run sajobs. Oracle. SQL under X:/oraclebi/Server/Schema (select the corresponding script for different databases ). After configuration
Then, start Oracle BI scheduler. Then select "Welcome to" in the Start Menu.
Biee, you can log on to IE (initial user and password: Administrator/administrator ).

　　Concepts of biee tools

Login interface.

　　

Set Data Warehouse dimensions (physical layer, logical layer, and presentation layer). This function is similar to discoverer aministrator. Of course, the function is more powerful ).

　 BI Publisher Tool

BI Publisher is included in the biee suite. Open BI Publisher in the Start Menu. User and password: Administrator/administrator. The BI Publisher logon page is very similar to EBS R12.

　　

Configure JDBC and create folders and reports. You can implement the same "Page List" as discoverer. Of course, it is much easier to use than discoverer. The web-based interface is very good.

　　

Select the corresponding data source, that is, the name of the newly created JDBC connection. This is much more convenient than discoverer. Discoverer can only connect to the Oracle database. BI Publisher can use JDBC to access all databases.

　　

The query speed is faster than that of discoverer. Because discoverer extracts database tables every time, while BI Publisher converts the data table into XML, caches the data table in the Solaris, and passes it to the page.

　　

　
BI Publisher can also implement cross-report, but it has fewer functions than discoverer. This can be achieved through bi
Add the Excel plug-in. After installing Oracle BI Publisher desktop, you can access BI Publisher through Excel.

 

 

This article from: http://tech.it168.com/a2009/0507/275/000000275336.shtml