Difference Between OTBI and BI Publisher

Difference Between OTBI and BI Publisher

OTBI	BI Publisher
+ Drop and Drag Interface/No SQL Needed	-More Technical/SQL Needed
+ Presentation Layer Developed so user does not need to join different tables together	-Thousand of Tables, multiple joins needed
+ Subject Area fields are intuitive	-Table name, fields, joins are not intuitive, and documentation can be vague
+ Reports can be built relatively quickly and updated rather quickly	-Reports can take very long to build, very complex, difficult to update
+ Oracle investing heavily in this type of reporting so additional fields will continuously be added	-OTBI is the Oracle preferred way of getting at data if possible.
+ As more and more clients adopt Cloud, more and more reporting resources will be available	+ As more and more clients adopt Cloud, more and more reporting resources will be available
-+ Viewing results is limited by use security	-+ Viewing results is not limited by use security
-Not all fields are available in subject areas	+ can get at almost all needed information
-Joining subject area is not always possible and you may have requirements from multiple subject areas.	+ Joins may be complicated, but joining multiple tables can be done to get all required fields
-Data is subject areas can be misleading, drop and drag interface can make subject areas/data seems simpler than actuality and no visibility how data is actually retrieved from database.	+ Once SQL is mastered, creating datasets and modifying past data sets can be easy.