Difference between otbi and bip reports
Hi Friends , We are going to discuss about the Difference between otbi and bip reports. OTBI and BIP are two important reporting tools available in Oracle fusion. Both OTBI and BIP helps to extract the data from Oracle Fusion system. In this Post , we will describe the difference between the OTBI and BIP reports. We will be try to find out the difference in the working and use of OTBI and BIP reports in Oracle Fusion. Both these reporting tools are very usefully and important in the day to day operations in the Oracle Fusion application. We will also try to share some posts to create the OTBI report and the BIP reports in Oracle Fusion. Please find below the details Difference between otbi and bip reports.
 |
| Difference between otbi and bip reports |
11 Main Differences between otbi and bip reports
1.BIP Reports is less user friendly as we need some technical expertise to develop the BIP reports but OTBI reports are more user friendly , we don't need technical expertise. We can develop the BIP report with just drag and drop option.
2.BIP report is the combination of two Objects (Data Model & Report) but OTBI report has only one object Analysis.
3.For BIP reports , we need to write the SQL Query to extract the Data from Oracle fusion but in OTBI reports , we don't need to write the SQL query , except we just select the column which we want to show in the report using drag and drop and create the OTBI reports.
4. BIP reports mostly suitable for complex reports where we have to extract the data from multiple tables but OTBI report only suitable for simple data scenarios where we have two extract data from 1 or 2 tables.
5. In BIP reports , we have the more flexibility in terms of data extraction as we can write the sql query as per our requirement but in OTBI reports , we have no flexibility , we can only extract those data which is available in OTBI reports , we cannot add or do changes in the Data Extraction.
6. In OTBI reports , system write the sql queries automatically based on our column selection for Data extraction but in the BIP report , we have to write the sql's statements as per our requirment.
7. OTBI reports more about simple data extraction tool but BIP is more robust tool as we can extract the design the reports layout as per our requirements.
8. In OTBI reports , we cannot design the Complex Reports Layouts for Data extraction , we can only design table based data extraction layouts but in BIP reports we can design any report layout as per our requirement.
9. We cannot design the statuary reports in OTBI reports. We have to use the BIP reports tool for statuary reports.
10.From user prospective , BIP reports GUI is much better as compared to OTBI reports.
11. OTBI reports can design very quickly but BIP reports development can take some time.
12.In BIP reports we can use the feature of report bursting but in OTBI reports we cannot use Report bursting.
13. In BIP reports, we can design multiple Templates but in the OTBI reports we can have only single template layout.
14. OTBI Reports access related to Data roles assign to our user account , based on that we can access the data in the Oracle Fusion application but in BIP reports , there is no relation of Data roles assigned to user , so user can access data irrespective of Data roles or access.
15. In terms of security , OTBI reports are more secure as compared to BIP Reports.
BIP Reports Overview :
OTBI Report Overview :-
2.BIP report is the combination of two Objects (Data Model & Report) but OTBI report has only one object Analysis.
3.For BIP reports , we need to write the SQL Query to extract the Data from Oracle fusion but in OTBI reports , we don't need to write the SQL query , except we just select the column which we want to show in the report using drag and drop and create the OTBI reports.
4. BIP reports mostly suitable for complex reports where we have to extract the data from multiple tables but OTBI report only suitable for simple data scenarios where we have two extract data from 1 or 2 tables.
5. In BIP reports , we have the more flexibility in terms of data extraction as we can write the sql query as per our requirement but in OTBI reports , we have no flexibility , we can only extract those data which is available in OTBI reports , we cannot add or do changes in the Data Extraction.
6. In OTBI reports , system write the sql queries automatically based on our column selection for Data extraction but in the BIP report , we have to write the sql's statements as per our requirment.
7. OTBI reports more about simple data extraction tool but BIP is more robust tool as we can extract the design the reports layout as per our requirements.
8. In OTBI reports , we cannot design the Complex Reports Layouts for Data extraction , we can only design table based data extraction layouts but in BIP reports we can design any report layout as per our requirement.
9. We cannot design the statuary reports in OTBI reports. We have to use the BIP reports tool for statuary reports.
10.From user prospective , BIP reports GUI is much better as compared to OTBI reports.
11. OTBI reports can design very quickly but BIP reports development can take some time.
12.In BIP reports we can use the feature of report bursting but in OTBI reports we cannot use Report bursting.
13. In BIP reports, we can design multiple Templates but in the OTBI reports we can have only single template layout.
14. OTBI Reports access related to Data roles assign to our user account , based on that we can access the data in the Oracle Fusion application but in BIP reports , there is no relation of Data roles assigned to user , so user can access data irrespective of Data roles or access.
15. In terms of security , OTBI reports are more secure as compared to BIP Reports.
BIP Reports Overview :
 |
| Difference between otbi and bip reports |
OTBI Report Overview :-
 |
| Difference between otbi and bip reports |
1 comments:
Please clarify the first point "We can develop the BIP report with just drag and drop option." is it OTBI or BIP to create using D&D
Post a Comment